DA-100 exam

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

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields: ✑ First name ✑ Last name ✑ Email address ✑ State/Region ✑ Phone number You import the list into Power Query Editor. You need to ensure that the list contains records for...

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

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

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

What is the minimum number of datasets and storage modes required to support the reports?A . two imported datasetsB . a single DirectQuery datasetC . two DirectQuery datasetsD . a single imported datasetView AnswerAnswer: A Explanation: Scenario: Data and Sources Data for the reports comes from three sources. Detailed revenue,...

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

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

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports. What should you recommend?A . Create a shared dataset for each standardized entity.B . Create dataflows for the standardized data and make the dataflows available for...

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