DA-100 Exam Prep - Topic 4

DRAG DROP -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:

1. Duplicate the query 2. Group the query to find the max modified date 3. Merge the query on inner join

DRAG DROP -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:

1. Select the line chart 2. Add the average line 3. Turn on Data Label

HOTSPOT -You view a query named Transactions as shown in the following exhibit. (Check Image) 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:

9 10

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? A. Create a new aggregation that summarizes by employee. B. Create a new group on the state column and set the Group type to List. C. Create a new group on the state column and set the Group type to Bin. D. Create a new aggregation that summarizes by state.

B. Create a new group on the state column and set the Group type to List.

HOTSPOT -You are enhancing a Power BI model that has DAX calculations. You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year. Which DAX functions should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

CALCULATE DATESBETWEEN

HOTSPOT -You are creating a Microsoft Power BI 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. Sales contains the data shown in the following table.You are evaluating how to optimize 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.Hot Area:

Yes No No