Free DA-100 Exam Braindumps

You view a query named Transactions as shown in the following exhibit.


The query gets CSV files from a folder.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.
Hot Area:

Exhibit A:



Exhibit B:

  1. Please refer to Exhibit B for the answer.

Answer(s): A

Explanation:

Box 1: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.



You have a query named Customer that imports CSV files from a data lake. The query contains 50,000 rows as shown in the exhibit. (Click the Exhibit tab.)


Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.

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.

Select and Place:

Exhibit A:



Exhibit B:

  1. Please refer to Exhibit B for the answer.

Answer(s): A



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.

Select and Place:

Exhibit A:



Exhibit B:

  1. Please refer to Exhibit B for the answer.

Answer(s): A

Explanation:

Step 1: Create a 12-month...
You can use calculated measure to get the expected result.
1. Create a calculated column for the date.
2. Create a measure for 12 months moving average.
3. Drag the Line Chart into your canvas as below. (step 2 below)


Step 2: Select the line chart
Step 3: From the Analytics pane, add a Median line


Reference:

https://community.powerbi.com/t5/Desktop/Moving-Average/td-p/43041



Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.

You have a data model that contains employee information by state. The model does NOT include region information.

You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible. What should you do?

  1. Create a new aggregation that summarizes by employee.
  2. Create a new group on the state column and set the Group type to List.
  3. Create a new group on the state column and set the Group type to Bin.
  4. Create a new aggregation that summarizes by state.

Answer(s): C

Explanation:

With grouping you are normally working with dimensional attributes.
Here we add three new groups (East, West, and North) and add each state to the appropriate group.

Incorrect Answers:
C: You can set the bin size for numerical and time fields in Power BI Desktop.


Reference:

https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/



You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table.

Which type of visualization should you use?

  1. donut chart
  2. pie chart
  3. area chart
  4. scatter plot

Answer(s): D

Explanation:

Outliers are those data points that lie outside the overall pattern of distribution & the easiest way to detect outliers is though graphs. Box plots, Scatter plots can help detect them easily.


Reference:

https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using-the-microsoft-power-bi-d7ad16ac9ccc