Practice DP-500 Exam Online

Question 1

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 the Power BI data model shown in the exhibit. (Click the Exhibit tab.)

Users indicate that when they build reports from the data model, the reports take a long time to load.

You need to recommend a solution to reduce the load times of the reports.

Solution: You recommend normalizing the data model.

Does this meet the goal?

A : Yes

B : No

Answer: B

Question 2

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

From the Power BI 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?

A : Yes

B : No

Answer: B

Question 3

You are attempting to configure certification for a Power BI dataset and discover that the certification setting for the dataset is unavailable.

What are two possible causes of the issue? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A : The workspace is in shared capacity.

B : You have insufficient permissions.

C : Dataset certification is disabled for the Power BI tenant.

D : The sensitivity level for the dataset is set to Highly Confidential.

E : Row-level security (RLS) is missing from the dataset.

Answer: B,C

Question 4

You have five Power BI reports that contain R script data sources and R visuals.

You need to publish the reports to the Power BI service and configure a daily refresh of datasets.

What should you include in the solution?

A : a Power BI Embedded capacity

B : a workspace that connects to an Azure Data Lake Storage Gen2 account

C : an on-premises data gateway (personal mode)

D : an on-premises data gateway (standard mode)

Answer: C

Question 5

You have a Power BI tenant.

You plan to publish 10 paginated reports that will be used by a team of business analysts.

You need to create a new workspace for the reports. The solution must minimize costs.

Which license mode should you select for the new workspace?

A : Pro

B : Premium per user

C : Embedded

D : Premium per capacity

Answer: A

Name:	Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
Exam Code:	DP-500
Certification:	Microsoft Azure
Vendor:	Microsoft
Total Questions:	404
Last Updated:	Apr 22, 2024

Microsoft DP-500