DA-100 Free Practice Test

- (Exam Topic 4)
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

You need to prepare the data to support the following:
Visualizations that include all measures in the data over time
Year-over-year calculations for all the measures
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Solution:
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 1)
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

1. A. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
2. B. Add the Weekly_Returns data to the Sales table by using related DAX functions.
3. C. Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

Correct Answer: A
Scenario: Region managers require a visual to analyze weekly sales and returns. To relate the two tables we need a common column.

- (Exam Topic 4)
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

1. A. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
2. B. Publish the reports to a different workspace other than the one hosting the datasets.
3. C. Publish the reports in an app and grant the HR managers access permission.
4. D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Correct Answer: C
Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

- (Exam Topic 4)
You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:
A line chart that shows the number of defective products manufactured by day.
A KPI visual that shows the current daily percentage of defective products manufactured.
You need to be notified when the daily percentage of defective products manufactured exceeds 3%. What should you create?

1. A. a Q&A visual
2. B. a subscription
3. C. a smart narrative visual
4. D. an alert

Correct Answer: D

- (Exam Topic 3)
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. bar chart
2. B. scatterplot
3. C. pie chart

Correct Answer: A
Scenario: The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter
Note: Bar and column charts are some of the most widely used visualization charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values.
The difference between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart.
Reference:
https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi