Microsoft Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI (DP-500) - Microsoft Exam Questions

You have a Power Bl dataset that contains the following measure.



You need to improve the performance of the measure without affecting the logic or the results. What should you do?

HOTSPOT You have the following Power Bl query.



For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

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 ft. As a result, these questions will not appear in the review screen.
From Power Query Editor, you profile the data shown in the following exhibit.



The loT GUID and loT ID columns are unique to each row in the query. You need to analyze loT events by the hour and day of the year. The solution must improve dataset performance. Solution: You split the loT DateTime column into a column named Date and a column named Time. Does this meet the goal?

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 Dataset1. 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 Tabular Editor, you create a calculation group. Does this meet the goal?

You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode. A database administrator reports a drastic increase in the number of queries sent from the Power BI
service to an Azure SQL database since the creation of the deployment pipeline.

An investigation into the issue identifies the following: One of the datasets is larger than 1 GB and has a fact table that contains more than 500 million rows.

When publishing dataset changes to development, test, or production pipelines, a refresh is triggered against the entire dataset. You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production.

What should you recommend?