Logo ExamsQA
Exit
Official Bank 0/162

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

Last updated on June 22, 2026

97% Exam Compliance
162 Total Questions
1
Question
You have a 2-GB Power Bl dataset. You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize how long it will take to apply changes to the dataset from powerbi.com.

Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point
Options
A Turn on Large dataset storage format.
B Enable XMLA read-write.
C Connect the target workspace to an Azure Data Lake Storage Gen2 account.
D Enable service principal authentication for read-only admin APIs.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files
HOTSPOT representing hourly telemetry dat

Exhibit

Exhibit
Options
A The data is organized in folders by the year, month, and day according to when the telemetry was captured.
You have the following query in Power Query Editor.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
DRAG DROP

You have a Power Bl dataset that contains the following measures:

• Budget

• Actuals

• Forecast
You need provide users with the ability to use a slicer to switch between the measures in two visuals You create a report that contains 10 visuals. only. You create a dedicated measure named cg Measure switch. How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriate values to the targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Exhibit
Reveal Only
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

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

Exhibit

You need to improve the performance of the measure without affecting the logic or the results. What should you do?
Options
A Remove the alternative result of blank( ) from the divide function.
B Remove "calendar'[Flag] = "YTD" from the code.
C Create a variable and replace the values for [sales Amount].
D Replace both calculate functions by using a variable that contains the calculate function.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
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.
Options
A The sensitivity level for the dataset is set to Highly Confidential.
B You have insufficient permissions.
C Row-level security (RLS) is missing from the dataset.
D Dataset certification is disabled for the Power Bl tenant.
E The workspace is in shared capacity.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.