Important Microsoft DP-600 Exam Questions

Answer: B, D, E

Answer: C

Explanation:

Comprehensive Detailed Explanation

Requirement

We have two columns in Power Query Editor:

Order_Date

Shipping_Date

We need to calculate the number of days between the two dates.

Step 1: How date differences work in Power Query (M language)

Subtracting two date or datetime values in Power Query returns a duration value.

Example:

[Shipping_Date] - [Order_Date]

This produces a duration such as 3.00:00:00 (3 days).

Step 2: Converting duration into days

To get the number of days as an integer, we use Duration.Days().

Example:

Duration.Days([Shipping_Date] - [Order_Date])

This returns 3 if the shipping date is 3 days after the order date.

Step 3: Evaluate other options

A . Duration.From Converts a value to a duration type but does not extract the number of days.

B . Date.AddDays Adds days to a given date, not used for calculating the difference.

C . Duration.Days Correct, extracts total days from a duration.

D . DateTime.LocalNow Returns the current system datetime, unrelated to this requirement.

Reference

Duration.Days function (Power Query M)

Working with dates in Power Query

Answer: A, B

Explanation:

Microsoft Power BI Desktop (A) and Tabular Editor (B) are the tools you can use to prevent report creators from using implicit measures. In Power BI Desktop, you can define explicit measures which can be used in visuals. Tabular Editor allows for advanced model editing, where you can enforce the use of explicit measures. Reference = Guidance on using explicit measures and preventing implicit measures in reports can be found in the Power BI and Tabular Editor official documentation.

Answer: A

Explanation:

Comprehensive Detailed Explanation

Step 1: Default permissions when sharing a warehouse in Fabric

When you share a Fabric warehouse (DW1) with a user and assign them default permissions, the user:

Gets Build permission by default.

Build permission allows the user to:

Use the default dataset automatically created for the warehouse.

Build reports and dashboards against that dataset.

It does not grant direct query permissions to the underlying tables or files.

Step 2: Analyze the options

A . Build reports by using the default dataset.

Correct. Sharing a warehouse gives Build permission on the warehouse's default dataset.

User1 can create Power BI reports but cannot directly query the warehouse via SQL.

B . Read the underlying Parquet files from OneLake.

Incorrect. Access to underlying OneLake files requires Direct Lake storage access or shortcut permissions, not provided by default sharing.

C . Connect to DW1 via the TDS endpoint.

Incorrect. The TDS endpoint is supported by semantic models, not warehouses.

D . Read data from the tables in DW1.

Incorrect. Default permissions do not allow table-level SQL access. They allow using the dataset for reporting.

Step 3: Correct Answe r

The only capability User1 has by default is:

A . Build reports by using the default dataset.

Reference

Fabric warehouses -- permissions

Build permission in Power BI

Answer: A, B

Explanation:

Both a dataflow (A) and a Stored procedure activity in a pipeline (B) are capable of creating and populating a date dimension table. A dataflow can perform the transformation needed to create the date dimension, and it aligns with the preference for using low-code tools for data ingestion when possible. A Stored procedure could be written to generate the necessary date dimension data and executed within a pipeline, which also adheres to the technical requirements for the PoC.