DA-100 Free Practice Test

- (Exam Topic 4)
You are creating a Microsoft Power BI data model that has the tables shown in the following table.

The Products table is related to the ProductCategory table through the ProductCategoryID column. You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Solution:
Box 1: One-to-many
Box 2: Both
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional).
Note:

Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

Does this meet the goal?

1. A. Yes
2. B. No

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?

1. A. comments
2. B. tiles
3. C. Microsoft Information Protection sensitivity labels
4. D. Active Directory groups

Correct Answer: D
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)
You have the following three versions of an Azure SQL database:
Test
Production
Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com. Which should you do?

1. A. Create a JSON file that contains the database server name
2. B. Import the JSON file to the dataset.
3. C. Create a parameter and update the queries to use the parameter.
4. D. Create a query for each database server and hide the development tables.
5. E. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

Correct Answer: B
https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-s

- (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 (Pll). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?

1. A. Active Directory groups
2. B. tiles
3. C. data classifications
4. D. comments

Correct Answer: A

- (Exam Topic 4)
You need to create the On-Time Shipping report.
The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create?

1. A. scarterplot
2. B. bar chart
3. C. piechart

Correct Answer: A