DA-100 exam

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

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 have the following three versions of an Azure SQL database: ✑ Test ✑ Production ✑ Development You have a dataset that uses the development database as a data source. You need to configure the dataset so that you can easily change the data source between the development, test, and...

ion have a Power B1 dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table. The table has 12 million rows. All the columns are needed for analysis. You need to optimize the dataset to decrease the model size. The solution must...

DRAG DROP You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer...

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: D Explanation: "The analysts responsible for each business unit must see all the data the board...

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

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 pointA . Show whitespaceB . Column distributionC ....

You have the visual shown in the Original exhibit. {Click the Original tab.) You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.) What should you add to the visual?A . a measureB . a trendlineC . a forecastD . an Average lineView AnswerAnswer:...

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?A . area chartB . donut chartC . scatter plotD . pie chartView AnswerAnswer: C Explanation: Outliers are those data points that lie...