QUESTION NO: 1
Hotspot Question
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time.
How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hotspot Question
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time.
How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: Total Sales
We select the field Total Sales
Box 2: Date
Select a date field.
Box 3: Month
Monthly periods.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
QUESTION NO: 2
You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart. The date value in ActivityDate is a number column named DateID. DateID is in the YYYYMMDD format.
What should you do in the model before you create the relationship?
You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart. The date value in ActivityDate is a number column named DateID. DateID is in the YYYYMMDD format.
What should you do in the model before you create the relationship?
Correct Answer: A
Vote an answer
QUESTION NO: 3
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit.
You plan to develop a Power BI model as shown in the Power BI Model exhibit.
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to add a measure to rank total sales by product. The results must appear as shown in the following table.
Which DAX formula should you use?
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit.
You plan to develop a Power BI model as shown in the Power BI Model exhibit.
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to add a measure to rank total sales by product. The results must appear as shown in the following table.
Which DAX formula should you use?
Correct Answer: A
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 4
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You implicitly convert the values into the required type.
Does this meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You implicitly convert the values into the required type.
Does this meet the goal?
Correct Answer: A
Vote an answer
QUESTION NO: 5
Hotspot Question
You have a Power BI semantic model that contains the following tables.
All the tables use the same data source.
You need to reduce the number of limited relationships in the model by changing the storage mode of certain tables. The solution must NOT affect the latency of the data.
Which storage mode should you select for the Customer and Geography tables? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hotspot Question
You have a Power BI semantic model that contains the following tables.
All the tables use the same data source.
You need to reduce the number of limited relationships in the model by changing the storage mode of certain tables. The solution must NOT affect the latency of the data.
Which storage mode should you select for the Customer and Geography tables? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: Dual
The Customer table is related to Sales and Survey Response.
Survey Response is in import Storage mode.
We should change Customer to dual mode.
Box 2: DirectQuery
Geography is related to the Customer table.
Customer is in DirectQuery mode (but changed to Dual).
Both tables use DirectQuery. No need to change this.
Reference:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode
QUESTION NO: 6
Drag and Drop Question
You use Power Query Editor to import three tables named Customers, Address, and Country.
In the source system, not every customer has a related address, but every address has a related country.
You need to merge all the tables into a single query. The solution must optimize query refresh performance.
Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Drag and Drop Question
You use Power Query Editor to import three tables named Customers, Address, and Country.
In the source system, not every customer has a related address, but every address has a related country.
You need to merge all the tables into a single query. The solution must optimize query refresh performance.
Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
QUESTION NO: 7
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a median line by using the Salary measure.
Does this meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a median line by using the Salary measure.
Does this meet the goal?
Correct Answer: B
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 8
You have a line chart that shows the number of employees in a department over time.
You need to see the total salary costs of the employees when you hover over a data point.
What should you do?
You have a line chart that shows the number of employees in a department over time.
You need to see the total salary costs of the employees when you hover over a data point.
What should you do?
Correct Answer: B
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 9
Hotspot Question
You have a Power BI semantic model named Model1 that will be used to support reports viewed in the Power BI service.
Model1 contains data from the following sources:
- An Azure SQL database that is accessible only via a private endpoint
- A Microsoft Excel file stored in Microsoft SharePoint Online
- A Microsoft SQL Server database in a private datacenter
You need to publish Model1 and schedule the model to refresh 12 times a day.
How many data sources require a data gateway, and which license mode will the workspace require to support the scheduled refresh? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hotspot Question
You have a Power BI semantic model named Model1 that will be used to support reports viewed in the Power BI service.
Model1 contains data from the following sources:
- An Azure SQL database that is accessible only via a private endpoint
- A Microsoft Excel file stored in Microsoft SharePoint Online
- A Microsoft SQL Server database in a private datacenter
You need to publish Model1 and schedule the model to refresh 12 times a day.
How many data sources require a data gateway, and which license mode will the workspace require to support the scheduled refresh? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
QUESTION NO: 10
Drag and Drop Question
You have the Power BI data model shown in the following exhibit.
The Country table contains the following data.
You create two row-level security (RLS) roles named Manager and CFO.
You plan to publish the dataset to the Power BI service.
You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:
- Each manager must see only the data in the Sales and Human Resources
tables for their own country.
- The CFO must be prevented from seeing the data in the Human Resources table.
- The CFO must see the sales data of all countries.
How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Drag and Drop Question
You have the Power BI data model shown in the following exhibit.
The Country table contains the following data.
You create two row-level security (RLS) roles named Manager and CFO.
You plan to publish the dataset to the Power BI service.
You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:
- Each manager must see only the data in the Sales and Human Resources
tables for their own country.
- The CFO must be prevented from seeing the data in the Human Resources table.
- The CFO must see the sales data of all countries.
How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: False ()
Add CFO user
* The CFO must be prevented from seeing the data in the Human Resources table.
* The CFO must see the sales data of all countries.
Box 2: [Email] = USERPRINCIPALNAME ()
Add manger users:
* Each manager must see only the data in the Sales and Human Resources tables for their own country.
QUESTION NO: 11
You have a Power BI workspace named BI Data that contains a dataset named BI Finance.
You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace, You need to connect to BI Finance and create a report.
Which actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
You have a Power BI workspace named BI Data that contains a dataset named BI Finance.
You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace, You need to connect to BI Finance and create a report.
Which actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Correct Answer: A,D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).