Easy — DP-600 Practice Quiz

Question 1

A Fabric Analytics Engineer is building a Dataflow Gen2 to load customer data into a lakehouse. The source contains a single column named FullName with values formatted as "LastName, FirstName" (for example, "Smith, John"). The target table requires two separate columns, FirstName and LastName. Which transformation should the engineer apply in the Power Query editor to accomplish this most efficiently?

Accepted Answer

Use Split Column by Delimiter, choosing the comma as the delimiter and splitting into columns

Answer

Use Group By on the FullName column to create the two new columns

Answer

Use Merge Columns to combine FullName with an empty column

Answer

Use Fill Down to populate FirstName and LastName from FullName

Question 2

You are analyzing web telemetry stored in an Eventhouse (KQL database). Each row in the PageViews table has RequestBytes and ResponseBytes columns (both long). Analysts need a query result that adds a new column named TotalBytes representing the sum of RequestBytes and ResponseBytes for every row, without changing the existing columns. Which KQL operator should you use?

Accepted Answer

extend TotalBytes = RequestBytes + ResponseBytes

Answer

summarize TotalBytes = sum(RequestBytes + ResponseBytes)

Answer

project TotalBytes = RequestBytes + ResponseBytes

Answer

where TotalBytes = RequestBytes + ResponseBytes

Question 3

You are building a query in the Visual Query Editor of a Fabric Warehouse SQL analytics endpoint. Business users need a preview limited to sales transactions from the current fiscal quarter where the order status is 'Completed'. You want to reduce the number of rows returned before any grouping or joining steps, using the low-code interface rather than writing raw SQL. Which Visual Query Editor action should you apply first?

Accepted Answer

Add a 'Filter rows' step with conditions on OrderDate within the quarter range and Status equals 'Completed'

Answer

Add a 'Group by' step on Status and then keep only the 'Completed' group

Answer

Add a 'Merge queries' step to join the sales table to a calendar table and drop unmatched rows

Answer

Add a 'Keep top rows' step to return the first 1000 rows of the table

Question 4

You are building a T-SQL view in a Fabric warehouse to feed a Power BI semantic model. The source fact table stores a nvarchar column named RegionCode that contains values like 'North', ' north ', 'NORTH', and 'South'. Downstream reporting requires a single consistent value per region so that grouping produces correct totals. Which single expression should you apply to RegionCode inside the view to standardize the values before grouping?

Accepted Answer

UPPER(TRIM(RegionCode))

Answer

CAST(RegionCode AS date)

Answer

COALESCE(RegionCode, 'Unknown')

Answer

SUBSTRING(RegionCode, 1, 1)