Free DA-100 Exam Dumps

Question 11

- (Exam Topic 4)
You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model. What should you do?

A. Round the hour of the Date column to startOfHour.
B. Change the data type of the Date column to Text.
C. Trim the Date column.
D. Split the Date column into two columns, one that contains only the time and another that contains only the date.

Correct Answer:D
We have to separate date & time tables. Also, we don’t need to put the time into the date table, because the time is repeated every day.
Split your DateTime column into a separate date & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.
Reference:
https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi

Question 12

- (Exam Topic 4)
You need to create a measure that will return the percentage of late orders.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
DA-100 dumps exhibit
Solution:
.
Graphical user interface Description automatically generated

Does this meet the goal?

A. Yes
B. No

Correct Answer:A

Question 13

- (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 a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary. Solution: You create an average line by using the Salary measure.
Does this meet the goal?

A. Yes
B. No

Correct Answer:B
Instead create a percentile line by using the Salary measure and set the percentile to 50%.
Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference:
https://dash-intel.com/powerbi/statistical_functions_percentile.php

Question 14

- (Exam Topic 4)
You import a large dataset to Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point

A. Show whitespace
B. Column distribution
C. Column profile
D. Column quality
E. Monospaced

Correct Answer:AD

Question 15

- (Exam Topic 4)
You plan to create the chart shown in the following exhibit.
DA-100 dumps exhibit
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

A. Create a horizontal line that has a fixed value of 24,000.
B. Add a measure to the visual that uses the following DAX expression.Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)
C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
D. Add a measure to the visual that uses the following DAX expression.Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Correct Answer:C
The analytics feature enables you to show percentiles across groups specified along a specific axis. Example:
* 1. Click on the analytics tab
* 2. Select Percentile
* 3. You can choose a specific percentile along with other formatting options.
* 4. Drag a date or non-numeric dimension into the Axis of a column chart
DA-100 dumps exhibit

Add percentile lines to monitor daily revenue