DP-500 Practice Online

Question 1

You have a Power BI Premium capacity.

You need to increase the number of virtual cores associated to the capacity.

Which role do you need?

A : Power BI workspace admin

B : capacity admin

C : Power Platform admin

D : Power BI admin

Answer: D

Question 2

When should you enable the setting to restrict content with protected labels from being shared via link with everyone in your organization?

A : When you want to prevent people from sharing protected content by using links

B :

When you want to apply sensitivity labels to downstream content

C : When you want to allow workspace admins to override automatically applied sensitivity labels

D : When you want to remind the dataset owner of the underlying data sensitivity

Answer: A

Question 3

What actions should be taken to enable data engineers to access the data generated from creating dataflows in three out of ten workspaces within a Power BI tenant, using Azure Data Factory? (Choose two options. Each correct answer is worth one point.)

A : Save and store the dataflows within the internal storage of Power BI.

B : Include the managed identity for Data Factory as a member of the workspaces.

C : Connect the Power BI tenant to an Azure Data Lake Storage account.

D : Save and store the dataflows within an Azure Data Lake Storage account.

Answer: C,D

Question 4

What is the purpose of the 'Detect data changes' option in incremental refresh in Power BI?

A : To exclude incomplete periods from refreshes

B : To check the maximum value of a date/time column and refresh data only if the value changes

C :

To partition tables so that the latest data is in DirectQuery mode

D : To define a different incremental refresh policy for each table in the data model

Answer: B

Question 5

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 question, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.

The queries use OPENROWSET and infer the schema shown in the following table.

You need to recommend changes to the queries to reduce I/O reads and tempdb usage.

Solution: You recommend using OPENROWSET WITH to explicitly specify the maximum length for businessName and surveyName.

Does this meet the goal?

A : Yes

B : No

Answer: B

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 23, 2024

Download Demo DP-500 Dumps

Create Account

Password Recovery

Download Demo DP-500 Dumps

Member Login

Create Account

Password Recovery

DP-500 Practice Online