Transform Data DP-600 Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A Fabric warehouse stores customer data with a birth_date column as a string in various formats. Several transformation pipelines need to convert this column to a standard date type and replace invalid or missing values with a default date. The team wants to avoid repeating the conversion logic in every pipeline. What should they create?

   • AA view that selects the birth_date column and casts it to date.
   • BA new table that stores the converted birth_date values.
   • CA scalar function that parses a date string and returns a valid date or a default value.
   • DA stored procedure that updates the birth_date column in place.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A Fabric warehouse stores survey responses. The satisfaction_score column is NULL for respondents who did not answer. The team needs to calculate the average satisfaction score, but they want to treat unanswered responses as the midpoint of the scale (for example, 3 on a 1–5 scale) rather than excluding them. What should they do?

   • AUse AVG(satisfaction_score) and ignore NULLs.
   • BUse AVG(COALESCE(satisfaction_score, 3)).
   • CUse MEDIAN(satisfaction_score).
   • DUse SUM(satisfaction_score) / COUNT(*).
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   In a Fabric warehouse, which SQL statement creates a new table by selecting data from an existing table?

   • ACREATE VIEW new_table AS SELECT * FROM old_table
   • BSELECT * INTO new_table FROM old_table
   • CCREATE TABLE new_table AS SELECT * FROM old_table
   • DINSERT INTO new_table SELECT * FROM old_table
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   In a star schema, which type of table contains descriptive attributes about business entities?

   • AFact table
   • BAggregate table
   • CDimension table
   • DStaging table
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A Fabric warehouse has a Sales table with columns: OrderID, ProductID, Quantity, UnitPrice, and OrderDate. You need to create a summary table that shows total sales amount per product per month. The sales amount is not stored as a column. What should you do?

   • ACreate a view that groups by ProductID and month without calculating the amount.
   • BAdd a calculated column for sales amount to the Sales table and then create a summary table that groups by ProductID and month.
   • CUse a stored procedure that returns the raw rows and let the reporting tool aggregate.
   • DCreate a new table using a SELECT that calculates the sales amount as Quantity * UnitPrice, groups by ProductID and month, and sums the amount.
   Reveal Solution Discussion Select an answer first