Free Microsoft DP-600 Korean Practice Test & Real Exam Questions

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Explanation:

Comprehensive Detailed Explanation
Step 1: Understanding the requirement
We need a KQL query that:
Reads data from Weatherdata.
Orders by Datetime.
Calculates Delta_temperature as the difference between the current row and the preceding row.
Returns the final columns: Datetime, Lat, Long, Temperature, Delta_temperature.
Step 2: Evaluate the provided statements
Weatherdata # Starts the query with the source table.
| sort by Datetime asc # Ensures chronological order, required for prev() to work correctly.
| extend Delta_temperature = Temperature - prev(Temperature) # Computes difference between the current row and the previous row's temperature.
| project Datetime, Lat, Long, Temperature, Delta_temperature # Selects the required output columns.
Step 3: Incorrect choices (to avoid)
next(Temperature,1) # Would calculate the difference with the next row, not the previous.
prev(Temperature,2) # Would skip one row, giving the difference with two rows back, which is not needed.
summarize ... by Datetime # Aggregates the data; not required here since we just need row-level differences.
Step 4: Final Correct Sequence
Weatherdata
| sort by Datetime asc
| extend Delta_temperature = Temperature - prev(Temperature)
| project Datetime, Lat, Long, Temperature, Delta_temperature
References
prev() function in KQL
extend operator in KQL
project operator in KQL

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Explanation:

Comprehensive Detailed Explanation
We need to write a query that summarizes order quantities by year and product, and also include the yearly total for all products in each row.
Step 1: What the query needs
Extract the year from SalesOrderDetail.ModifiedDate.
Join with the Product table to get the product name.
Aggregate with SUM(OrderQty).
Return grouped data by year and product, with an additional subtotal row per year (all products combined).
Step 2: Evaluate the SELECT Clause
We must extract the year using:
YEAR(so.ModifiedDate) AS OrderDate
This converts the ModifiedDate column into a year value for grouping.
Step 3: Evaluate the GROUP BY options
CUBE(YEAR, P.Name) # Produces all combinations of year totals, product totals, and grand totals. Too many combinations, not required.
GROUPING SETS # Could achieve the result but requires explicitly listing the sets. Less direct.
ROLLUP(YEAR, P.Name) # Produces grouping by (Year, Product) and then a subtotal per Year. Exactly what is required.
YEAR only # Would group only by year, losing per-product breakdown.
Correct: ROLLUP(YEAR(so.ModifiedDate), P.Name)
Step 4: Completed Query
SELECT
YEAR(so.ModifiedDate) AS OrderDate,
p.Name,
SUM(so.OrderQty) AS OrderQty
FROM dbo.SalesOrderDetail so
INNER JOIN dbo.Product p
ON p.ProductID = so.ProductID
GROUP BY ROLLUP(YEAR(so.ModifiedDate), p.Name);
Why This Works
YEAR(so.ModifiedDate) extracts year for grouping.
ROLLUP(YEAR, P.Name) provides both product-level totals and yearly subtotals.
Ensures the requirement: "include the yearly sum of order quantities for all the products in each row." References GROUP BY ROLLUP in T-SQL Aggregate functions in Microsoft Fabric warehouses

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Explanation:

To create a calculation item that changes the context from the selected date to month-to-date (MTD), the appropriate DAX expression involves using the CALCULATE function to alter the filter context and the DATESMTD function to specify the month-to-date context.
The correct completion for the DAX expression would be:
In the first dropdown, select CALCULATE.
In the second dropdown, select SELECTEDMEASURE.
This would create a DAX expression in the form:
CALCULATE(
SELECTEDMEASURE(),
DATESMTD( ' Date ' [DateColumn])
)

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).