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 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!

2
Question
You have two Power BI reports named Report1 and Report2. Report1 connects to a shared dataset named Dataset1. Report2 connects to a local dataset that has the same structure as Dataset1. Report2 contains several calculated tables and parameters. You need to prepare Report2 to use Dataset1.

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

NOTE: Each correct selection is worth one point.
Options
A Update all the parameter values.
B Delete all the Power Query Editor objects.
C Delete all the calculated tables.
D Modify the source of each query.
E Remove the data source permissions.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
HOTSPOT You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column.
pfflag = IF('Calendar'[Date] < TOOAYQ, "Past", "Future")
You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements:

• Returns the fiscal prior year-to-date value for [sales Amount]

• Uses a fiscal year end of June 30

• Produces no result for dates in the future

How should you complete the DAX expression? To answer, select the appropriate options in the
HOTSPOT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
You have a Power Bl data model. You need to refresh the data from the source every 15 minutes.

What should you do first?
Options
A Define an incremental refresh policy.
B Configure a scheduled refresh.
C Change the storage mode of the dataset.
D Enable the XMLA endpoint.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
DRAG DROP You have an Azure Synapse Analytics serverless SQL pool. You need to return a list of files and the number of rows in each file. How should you complete the Transact-SQL statement? 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!

Finish Practice?

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