Free Microsoft DP-600 Exam Dumps Questions & Answers

You have a Fabric tenant that contains a takehouse named lakehouse1. Lakehouse1 contains a Delta table named Customer.
When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table.
You need to identify whether maintenance tasks were performed on Customer.
Solution: You run the following Spark SQL statement:
DESCRIBE HISTORY customer
Does this meet the goal?

• A.  No
• B.  Yes

You are designing a Fabric semantic model named Model! for a financial analytics workspace. Modell includes a DAX measure named Measure1 that returns total sales.
You have a table named Currency that contains a column named Format. The Format column defines currency formatting strings for each record as follows: $8,880.00, ta,880.00, or yv.sve.ee.
You have a report that uses the Currency column to identify which symbol and format string to display. In the report Measure1 must appear with two decimal places and the appropriate currency symbol based on the selected value in the Currency column.
You create the following DAX formula.
FORMAT = SELECTEDVALUE( ' Currency ' [Format])
You need to ensure that Measure1 appears correctly in visuals. The solution must minimize logic duplication.
What should you do?

• A.  For Modell, set the format type of Measure1 to Currency.
• B.  Create a dynamic format string for Measure1 that references the FORMAT measure.
• C.  For Modell, set the data category of Measure to Country/Region.
• D.  Copy the DAX expression from the Format column and profile the expression into the format string expression of Measure.

You are creating a report and a semantic model in Microsoft Power Bl Desktop.
The Value measure has the expression shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Comprehensive Detailed Explanation
Step 1: Reviewing the provided DAX expression
SWITCH(
SELECTEDVALUE(Metric[Metric]),
" # of Customers " , " # " ,
" Gross Margin % " , " 0.00% " ,
" #,### "
)
This is applied as a dynamic format string .
It changes the display formatting of the Value measure depending on the selected metric.
Step 2: Identify the feature
The screenshot shows Format = Dynamic in the Power BI Modeling tab.
This confirms that a dynamic format string has been applied.
So, for the first blank # dynamic format string .
Step 3: Identify the output formats
If the metric = # of Customers # format is " # " # whole numbers.
If the metric = Gross Margin % # format is " 0.00% " # percentages.
Fallback # " #,### " # also whole numbers.
Thus, the measure supports both whole numbers and percentages .
So, for the second blank # percentages or whole numbers .
References
Dynamic format strings in Power BI
SWITCH function in DAX

You are implementing two dimension tables named Customers and Products in a Fabric warehouse.
You need to use slowly changing dimension (SCO) to manage the versioning of data. The solution must meet the requirements shown in the following table.

Which type of SCD should you use for each table? To answer, drag the appropriate SCD types to the correct tables. Each SCD type may be used once, more than once, or not at all. You may need to drag the split bar between panes o r scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

For the Customers table, where the requirement is to create a new version of the row, you would use:
Type 2 SCD: This type allows for the creation of a new record each time a change occurs, preserving the history of changes over time.
For the Products table, where the requirement is to overwrite the existing value in the latest row, you would use:
Type 1 SCD: This type updates the record directly, without preserving historical data.

You have a Fabric tenant.
You plan to create a Fabric notebook that will use Spark DataFrames to generate Microsoft Power Bl visuals.
You run the following code.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
The code embeds an existing Power BI report. - No
The code creates a Power BI report. - Yes
The code displays a summary of the DataFrame. - Yes
The code provided seems to be a snippet from a SQL query or script which is neither creating nor embedding a Power BI report directly. It appears to be setting up a DataFrame for use within a larger context, potentially for visualization in Power BI, but the code itself does not perform the creation or embedding of a report.
Instead, it ' s likely part of a data processing step that summarizes data.
References =
Introduction to DataFrames - Spark SQL
Power BI and Azure Databricks