DP-500 Dataset Practice Questions
The free DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI questions that deal with dataset, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #2
You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.) The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.) You need to reduce the model size by eliminating invalid relationships. Which column should you remove?
Correct answer: B
Explanation
Sales[Row ID] has 858,786 missing keys and 858,789 Max From Cardinality. Note: The Max From Cardinality column defines the cost of the relationship which is the amount of time DAX needs to transfer the filters from the dimensions table to the fact table. Reference: https://blog.enterprisedna.co/vertipaq-analyzer-tutorial-relationships-referential-integrity/
Question #6
You have a sales report as shown in the following exhibit. The sales report has the following characteristics: The measures are optimized. The dataset uses import storage mode. Data points, hierarchies, and fields cannot be removed or filtered from the report page. From powerbi.com, users experience slow load times when viewing the report. You need to reduce how long it takes for the report to load without affecting the data displayed in the report. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Select 2 answers.
Correct answer: B, C
Explanation
Consolidating many visuals into fewer ones cuts the number of queries the browser issues, so replacing single-value cards with a multi-row card and merging the category charts into one bar chart with a hierarchy speeds up loading without changing the data shown.
Question #8
You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips. You need to create a chart that will show the total trip distance according to the number of passengers as shown in the following exhibit. How should you configure the chart? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Match each item to its target.
Correct answer: Category column = PassengerCount; Legend (series) column = SumTripDistance
Question #9
You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?
Correct answer: C
Explanation
PREDICT runs a trained model over the input dataset and outputs the predicted value, here the likelihood of engine failure. PIVOT, GROUPING and CAST only reshape or convert data and perform no scoring.
Continue with DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.