Microsoft DP-500 Practice Test - Questions Answers, Page 15

You are creating a Power Bl report that will contain multiple visuals.

You need to ensure that the report is accessible to users who use a screen reader.

Which two configurations should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

HOTSPOT

You deploy a tabular model to the Power Bl service. The model is developed and maintained by using Microsoft Visual Studio. Power Bl connects to the model by using the Connect live option.

You need to recommend a source control solution for the model and the report files.

What should you include in the recommendation for each type of file? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

HOTSPOT

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo. Dim Product. You need to write a query to meet the following requirements:

* Return the ranked position of each product ordered by list price descending within each product category, allowing gaps in the ranking values after ties.

* Specify the quartile in which each product's list price falls within each product category.

How should you complete the query? To answer, select the appropriate options in the answer area.

You have a Power BI report named Report1. Repor1 is connected to an imported dataset that contains a matrix. The matrix displays five measures. When users view the report they discover that the matrix is slow to render.

You need to review the execution times and durations in the formula engine and the storage engine for the DAX query executed by the matrix. What should you use?

HOTSPOT

You have a Power BI report and dataset in Power BI Desktop. The dataset contains a calculation group named CG1 that contains four calculation items. The Current calculation item is shown in the following exhibit.

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

From the Power Bl Premium Capacity Metrics app, you discover the following:

* There is insufficient CPU to execute dataset refreshes.

* Out-of-memory throttling occurs when the dataset is waiting.

You need to recommend a solution to resolve the performance issues.

Solution: You scale up the capacity.

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

From the Power Bl Premium Capacity Metrics app, you discover the following:

* There is insufficient CPU to execute dataset refreshes.

* Out-of-memory throttling occurs when the dataset is waiting.

You need to recommend a solution to resolve the performance issues.

Solution: You move the datasets to a larger capacity.

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

From the Power Bl Premium Capacity Metrics app, you discover the following:

* There is insufficient CPU to execute dataset refreshes.

* Out-of-memory throttling occurs when the dataset is waiting.

You need to recommend a solution to resolve the performance issues.

Solution: You assign Premium per user licenses to all workspace members.

Does this meet the goal?

You have a Power Bl tenant and an Azure subscription named Sub1. The Power Bl tenant and Sub1 are linked to a single Azure AD tenant.

In Sub1, you create a storage account named storage1.

You need to configure a Power Bl workspace to store dataflows in storage1. The solution must use the principle of least privilege.

Which three roles should you assign for storage1? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.