DP-500 Free Practice Test

- (Exam Topic 3)
You discover a poorly performing measure in a Power Bl data model.
You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engine.
What should you use?

1. A. Tabular Editor
2. B. Performance analyzer in Power Bl Desktop
3. C. Vertipaq Analyzer
4. D. DAX Studio

Correct Answer: B

- (Exam Topic 3)
You are optimizing a dataflow in a Power Bl Premium capacity. The dataflow performs multiple joins. You need to reduce the load time of the dataflow.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. A. Reduce the memory assigned to the dataflows.
2. B. Execute non-foldable operations before foldable operations.
3. C. Execute foldable operations before non-foldable operations.
4. D. Place the ingestion operations and transformation operations in a single dataflow.
5. E. Place the ingestion operations and transformation operations in separate dataflows.

Correct Answer: CD

- (Exam Topic 3)
You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses Import storage
mode. You need to ensure that the report page updates all the visuals every 30 minutes. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. A. Enable Power Bl embedded.
2. B. Configure the data sources to use DirectQuery.
3. C. Configure the data sources to use a streaming dataset
4. D. Select Auto page refresh.
5. E. Enable the XMIA endpoint.
6. F. Add a Microsoft Power Automate visual to the report page.

Correct Answer: AD

- (Exam Topic 3)
You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the visual. What should you do?

1. A. Replace long text with abbreviations and acronyms.
2. B. Configure a unique marker for each series.
3. C. Configure a distinct color for each series.
4. D. Move important information to a tooltip.

Correct Answer: B

- (Exam Topic 3)
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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power Bl dataset named Datasetl.
In Dataset1, you currently have 50 measures that use the same time intelligence logic. You need to reduce the number of measures, while maintaining the current functionality. Solution: From DAX Studio, you write a query that uses grouping sets.
Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: B