- (Exam Topic 4)
You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
Customer ID Customer Name Phone Email Address Address ID
Address contains the following columns: Address ID Address Line 1 Address Line 2 City State/Region Country Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?
Correct Answer:
A
There are two primary ways of combining queries: merging and appending. When you have one or more columns that you’d like to add to another query, you merge the queries. When you have additional rows of data that you’d like to add to an existing query, you append the query.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
- (Exam Topic 4)
The data model must support the following analysis:
Total sales by product by month in which the order was placed 
Quantities sold by product by day on which the order was placed Number Of sales transactions by quarter in Which the order was placed
For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.
Solution:
Does this meet the goal?
Correct Answer:
A
- (Exam Topic 4)
You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?
Correct Answer:
C
Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical
content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied to datasets, reports, dashboards, and dataflows. Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview
- (Exam Topic 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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table. Solution: From Power Query Editor, you import the table and then add a filter step to the query. Does this meet the goal?
Correct Answer:
B
- (Exam Topic 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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports. Solution: You enable included in app for all assets.
Does this meet the goal?
Correct Answer:
B
