DA-100 Free Practice Test

- (Exam Topic 4)
You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

1. A. A user pressed F5
2. B. A new transaction was added to the data source.
3. C. A user added a comment to a tile.
4. D. The dashboard tile cache refreshed.

Correct Answer: D
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

- (Exam Topic 4)
You have a data model that contains many complex DAX expressions. The expressions contain frequent
references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions. What should you recommend?

1. A. Merge tables by using Power Query.
2. B. Hide unused columns in the model.
3. C. Split the model into multiple models.
4. D. Transpose.

Correct Answer: A
Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
When you have one or more columns that you’d like to add to another query, you merge the queries. Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical
expression.
CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values. Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

- (Exam Topic 4)
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the following format:
at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do?

1. A. Change the data type of the Logged column to Date.
2. B. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
3. C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
4. D. Apply a transform to extract the first 11 characters of the Logged column.

Correct Answer: C

- (Exam Topic 4)
You have a collection of reports for the HR department of your company.
You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.
Which type of visualization should you use?

1. A. scatter chart
2. B. ribbon chart
3. C. line chart
4. D. key influences

Correct Answer: C
The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart has to have only one line.
Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.
Reference:
https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-36

- (Exam Topic 3)
You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Solution:
Text Description automatically generated
Box 1: many-to-one
Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
The Suppliers table has a Region column. Box 2: Suppliers table

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A