DP-500

Practice DP-500 Exam

Is it difficult for you to decide to purchase Microsoft DP-500 exam dumps questions? CertQueen provides FREE online Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP-500 exam questions below, and you can test your DP-500 skills first, and then decide whether to buy the full version or not. We promise you get the following advantages after purchasing our DP-500 exam dumps questions.
1.Free update in ONE year from the date of your purchase.
2.Full payment fee refund if you fail DP-500 exam with the dumps

 

 Full DP-500 Exam Dump Here

Latest DP-500 Exam Dumps Questions

The dumps for DP-500 exam was last updated on Jun 09,2025 .

Viewing page 1 out of 6 pages.

Viewing questions 1 out of 32 questions

Question#1

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.


A. 

Explanation:
Box 1: APPROX_COUNT_DISTINCT
The APPROX_COUNT_DISTINCT function returns the approximate number of unique non-null values in a group.
Box 2: OPENROWSET
OPENROWSET function in Synapse SQL reads the content of the file(s) from a data source. The data source is an Azure storage account and it can be explicitly referenced in the OPENROWSET function or can be dynamically inferred from URL of the files that you want to read. The OPENROWSET function can optionally contain a DATA_SOURCE parameter to specify the data source that contains files.
The OPENROWSET function can be referenced in the FROM clause of a query as if it were a table name OPENROWSET. It supports bulk operations through a built-in BULK provider that enables data from a file to be read and returned as a rowset.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/approx-count-distinct-transact-sql
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset

Question#2

DRAG DROP
You have a Power Bl data model that contains two tables named Products and Sales.
A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a DAX measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.
How should you complete the measure? To answer, drag the appropriate DAX functions to the correct targets. Each function 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.


A. 

Explanation:
Product Sale% =
VAR ProductSales = SUM('Sales'[Sales])
VAR AllSales =
CALCULATE (SUM('Sales'[Sales]), ALLSELECTED ('Product'[Product Name]))
Return
DIVIDE(ProductSales,AllSales)

Question#3

You have an Azure subscription that contains an Azure Synapse Analytics workspace. You create an Azure Data Lake and upload a CSV file named Filel.csv. You need to use Synapse Studio to query the data in Filel.csv by using a serverless SQL pool.
Which Transact-SQL operator should you include in the query?

A. STRIMO_SPLIT
B. OPENOUERY
C. OPCNROWSET
D. OPEMDATASOURCE

Question#4

You have a Power Bl report that contains a card. The card displays the value for year-to-date revenue. You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed.
What should you do?

A. Convert the card into a text box.
B. Populate the alt text by using conditional formatting with a DAX measure.
C. Add the value to the chart title text.
D. Populate the alt text with a static value.

Question#5

DRAG DROP
You have a Power Bl dataset that contains the following measures:
• Budget
• Actuals
• Forecast
You create a report that contains 10 visuals.
You need provide users with the ability to use a slicer to switch between the measures in two 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.


A. 

Explanation:
Box 1: SELECTEDMEASURENAME()
SELECTEDMEASURENAME is used by expressions for calculation items to determine the measure that is in context by name.
Syntax: SELECTEDMEASURENAME()
No parameters.
Example:
The following calculation item expression checks if the current measure is Expense Ratio and conditionally applies calculation logic. Since the check is based on a string comparison, it is not subject to formula fixup and will not benefit from object renaming being automatically reflected. For a similar comparison that would benefit from formula fixup, please see the ISSLECTEDMEASURE function instead.
IF (
SELECTEDMEASURENAME = "Expense Ratio",
SELECTEDMEASURE (),
DIVIDE ( SELECTEDMEASURE (), COUNTROWS ( DimDate ) )
)
Box 2: SELECTEDVALUE()
SELECTEDVALUE returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.
Syntax:
SELECTEDVALUE(<columnName>[, <alternateResult>])
M1, M2, ... - A list of measures.
Reference:
https://docs.microsoft.com/en-us/dax/selectedmeasurename-function-dax
https://docs.microsoft.com/en-us/dax/selectedvalue-function

Exam Code: DP-500         Q & A: 160 Q&As         Updated:  Jun 09,2025

 

 Full DP-500 Exam Dumps Here

Exam Code: DP-500
Q & A: 160 Q&As
Updated:  Jun 09,2025

 

 About DP-500 Dumps

TOP Exams