DA-100 exam

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?A . In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to...

What should you create to meet the reporting requirements of the sales department?A . a calculated column that use a formula of couMTA(Sales[sales_id]>B . a calculated measure that uses a formula of couNTROws(Sales)C . a calculated column that uses a formula of suM(Sales[sales_id])D . a measure that uses a formula...

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...

HOTSPOT You have an API that returns more than 100 columns. The following is a sample of column names. ✑ client_notified_timestamp ✑ client_notified_source ✑ client_notified_sourceid ✑ client_notified_value ✑ client_responded_timestamp ✑ client_responded_source ✑ client_responded_sourceid ✑ client_responded_value You plan to include only a subset of the returned columns. You need to remove...

HOTSPOT You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario: The sales managers require a visual...

DRAG DROP You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total...

You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine 1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?A . 1318B . 1319C . 21318 Lasalle StreetD . 21319 Lasalle StreetView AnswerAnswer: D...

HOTSPOT How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Using a workspace membership Scenario: The company wants to provide a single package of reports to the...

DRAG DROP You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity. How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than...

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...