DA-100 Free Practice Test

- (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 create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"})
A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

1. A. 1318
2. B. 1319
3. C. 21318 Lasalle Street
4. D. 21319 Lasalle Street

Correct Answer: D
Example:
Replace the text "ur" with the text "or" in the table.

Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue

- (Exam Topic 4)
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?

1. A. Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
2. B. Duplicate the Date query in Power Query and use active relationships between both Date tables.
3. C. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
4. D. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Correct Answer: D
Only one relationship can be active.
Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

- (Exam Topic 4)
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Solution:
Reference:
https://finance-bi.com/power-bi-basket-analysis/

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You need to modify the chart to meet the following requirements:
Identify months that have order counts above the mean.
Display the mean monthly order count.
Which three 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:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A