DP-600 Exam Dumps - Microsoft Certified: Fabric Analytics Engineer Associate Questions and Answers

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. References = Guidance on using explicit measures and preventing implicit measures in reports can be found in the Power BI and Tabular Editor official documentation.

Remove the files: Run the VACUUM command on a schedule.

Combine the files: Set the optimizeWrite table setting. or Run the OPTIMIZE command on a schedule.

To remove files that are no longer used, the VACUUM command is used in Delta Lake to clean up invalid files from a table. To combine smaller files into larger ones, you can either set the optimizeWrite setting to combine files during write operations or use the OPTIMIZE command, which is a Delta Lake operation used to compact small files into larger ones.

For the HighestSellingPrice, you should use the GREATEST function to find the highest value from the given price columns. However, T-SQL does not have a GREATEST function as found in some other SQL dialects, so you would typically use a CASE statement or an IIF statement with nested MAX functions. Since neither of those are provided in the options, you should select MAX as a placeholder to indicate the function that would be used to find the highest value if combining multiple MAX functions or a similar logic was available.

For the TradePrice, you should use the COALESCE function, which returns the first non-null value in a list. The COALESCE function is the correct choice as it will return AgentPrice if it ' s not null; if AgentPrice is null, it will check WholesalePrice , and if that is also null, it will return ListPrice .

The complete code with the correct SQL functions would look like this:

SELECT ProductID,

MAX(ListPrice, WholesalePrice, AgentPrice) AS HighestSellingPrice, -- MAX is used as a placeholder

COALESCE(AgentPrice, WholesalePrice, ListPrice) AS TradePrice

FROM Sales.Products

Select MAX for HighestSellingPrice and COALESCE for TradePrice in the answer area.

To ensure read-write access to DS1 is available by using the XMLA endpoint, the C1 settings (which refer to the capacity settings) should be modified first. XMLA endpoint configuration is a capacity feature, not specific to individual datasets or workspaces. References = The configuration of XMLA endpoints in Power BI capacities is detailed in the Power BI documentation on dataset management.

 The issue is that USERNAME() is returning blank in Fabric because it needs the user principal name (UPN) from Microsoft Entra ID.

 Simply creating a role in the model does not fix the problem of the identity not being surfaced.

 To solve this, you need to ensure that the Entra UPN is synced correctly (via Entra Connect attribute mappings) and use the right function ( USERPRINCIPALNAME() in modern models).

 Therefore, just creating a role does not meet the goal.

For users to create and publish custom Direct Lake semantic models using external tools, following the principle of least privilege, the actions to be included are enabling XMLA Endpoints (A), editing data models in Power BI service (C), and setting XMLA Endpoint to Read-Write in the capacity settings (D). References = More information can be found in the Admin portal of the Power BI service documentation, detailing tenant and capacity settings.

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.

References

Duration.Days function (Power Query M)

Working with dates in Power Query

ISEMPTY(CALCULATETABLE( ' Order Item ' )) checks if there are no related rows in ' Order Item ' for a customer. Wrapping this in NOT returns true if the customer has at least one order. This avoids calculating row counts and instead just checks existence, which is more efficient for performance. This reduces execution time and meets the goal.

Lookup activity can execute a SQL query or stored procedure and retrieve a single row or dataset. The returned values can then be passed to downstream pipeline activities .

Switch is for branching logic, not executing procedures.

Append variable just adds values to a variable.

KQL activity executes Kusto queries, not SQL stored procedures.

Therefore, the correct choice is Lookup .