PL-300 Practice Questions Correct
Answers
What type of table stores details about business entities?
1. Fact table
2. Dimension table
3. Date table
4. Data table - ANSWER-Dimension table
You are working on a report and need to create a calculated table to return the top
100 spending customers. Complete the DAX expression:
Top 100 Customers = _____
1. ASC[
2. DESC(
3. FILTER(
4. SUMMARIZE[
5. TOPN(
_____(FactTransaction, FactTransaction[CustomerID], "Sales",
SUM(FactTransaction[Sale])),
1. ASC
2. DESC
3. FILTER
4. SUMMARIZE
5. TOPN
[Sales], _____
1. ASC
2. DESC
3. FILTER
4. SUMMARIZE
5. TOPN - ANSWER-TOPN, SUMMARIZE, DESC
Which of the following filters are not available in Power BI reports?
1. Drillthrough
2. Report level
3. Page type
4. Page level - ANSWER-Page type
You build a report on Sales Performance and the Sales team wants a single visual to
identify factors affecting success. Which visual will you use?
1. Line and clustered column chart
, 2. Key influencers
3. Scatter chart
4. Decomposition tree - ANSWER-Key influencers
You are monitoring the performance sales department using a dashboard. A card
visual shows Total Sales. You need to notify when the total sales goes above 1000.
What should you create?
1. a Q&A visual
2. a subscription
3. a smart narrative visual
4. an alert - ANSWER-an alert
Where are the dataset-scheduled refreshes configured?
1. Power BI desktop
2. Power BI service - ANSWER-Power BI service
Which DAX function allows you to filter rows dynamically based on the user's mail
ID?
1. USER
2. USERPRINCIPALNAME
3. USERELATIONSHIP - ANSWER-USERPRINCIPALNAME
You are building a Power BI report and during the development process you need to
import a sample of the data. You write a DAX expression that uses the FILTER
function. This meets your goal.
1. True
2. False - ANSWER-False
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file.
The solution must ensure that date attributes can be used as date hierarchies in
Power BI reports. Which 3 actions should you perform in sequence?
1. Expand the columns
2. Expand the records
3. Add columns that use data type conversions
4. Set the data types
5. Convert the list to a table - ANSWER-Convert the list to a table
Expand the columns
Set the data types
You have a custom connector that returns ID, From, To, Subject, Body, and Has
Attachments or every email sent last year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on who they
send emails to. You need to prevent report recipients from reading the analyzed
emails. The solution must minimize the model size. What should you do?
Answers
What type of table stores details about business entities?
1. Fact table
2. Dimension table
3. Date table
4. Data table - ANSWER-Dimension table
You are working on a report and need to create a calculated table to return the top
100 spending customers. Complete the DAX expression:
Top 100 Customers = _____
1. ASC[
2. DESC(
3. FILTER(
4. SUMMARIZE[
5. TOPN(
_____(FactTransaction, FactTransaction[CustomerID], "Sales",
SUM(FactTransaction[Sale])),
1. ASC
2. DESC
3. FILTER
4. SUMMARIZE
5. TOPN
[Sales], _____
1. ASC
2. DESC
3. FILTER
4. SUMMARIZE
5. TOPN - ANSWER-TOPN, SUMMARIZE, DESC
Which of the following filters are not available in Power BI reports?
1. Drillthrough
2. Report level
3. Page type
4. Page level - ANSWER-Page type
You build a report on Sales Performance and the Sales team wants a single visual to
identify factors affecting success. Which visual will you use?
1. Line and clustered column chart
, 2. Key influencers
3. Scatter chart
4. Decomposition tree - ANSWER-Key influencers
You are monitoring the performance sales department using a dashboard. A card
visual shows Total Sales. You need to notify when the total sales goes above 1000.
What should you create?
1. a Q&A visual
2. a subscription
3. a smart narrative visual
4. an alert - ANSWER-an alert
Where are the dataset-scheduled refreshes configured?
1. Power BI desktop
2. Power BI service - ANSWER-Power BI service
Which DAX function allows you to filter rows dynamically based on the user's mail
ID?
1. USER
2. USERPRINCIPALNAME
3. USERELATIONSHIP - ANSWER-USERPRINCIPALNAME
You are building a Power BI report and during the development process you need to
import a sample of the data. You write a DAX expression that uses the FILTER
function. This meets your goal.
1. True
2. False - ANSWER-False
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file.
The solution must ensure that date attributes can be used as date hierarchies in
Power BI reports. Which 3 actions should you perform in sequence?
1. Expand the columns
2. Expand the records
3. Add columns that use data type conversions
4. Set the data types
5. Convert the list to a table - ANSWER-Convert the list to a table
Expand the columns
Set the data types
You have a custom connector that returns ID, From, To, Subject, Body, and Has
Attachments or every email sent last year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on who they
send emails to. You need to prevent report recipients from reading the analyzed
emails. The solution must minimize the model size. What should you do?
