Transform Data DP-600 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A nightly data load in Fabric needs to perform the following steps: truncate the staging table, load new data from a source file, remove duplicate rows, and merge the cleaned data into the dimension table. You want to automate this as a single reusable process. What should you create?

   • AA single T-SQL script that you run manually each night.
   • BA view that joins the staging table to the dimension table.
   • CA function that returns the deduplicated rows.
   • DA stored procedure that contains the truncate, load, deduplicate, and merge logic, and schedule it to run nightly.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   What is the main benefit of creating a user-defined function (UDF) in a data transformation pipeline?

   • AIt replaces the need for views and stored procedures entirely
   • BIt automatically parallelizes the transformation across nodes
   • CIt physically stores the transformed data for faster retrieval
   • DIt allows you to reuse the same logic in multiple places without duplicating code
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   What is the primary advantage of using a stored procedure for a complex data transformation?

   • AIt creates a physical backup of the data before transformation
   • BIt allows you to save and reuse a series of SQL statements as a single unit
   • CIt automatically scales the transformation across multiple clusters
   • DIt eliminates the need for data modeling in the warehouse
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   In Power Query, which step is commonly used to remove duplicate rows from a table?

   • ADistinct
   • BFilter Rows
   • CRemove Duplicates
   • DRemove Columns
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   In a Fabric Dataflow (Power Query), what is the purpose of the 'Custom Column' step?

   • ATo add a new column based on a formula you define
   • BTo filter rows based on a condition
   • CTo change the data type of a column
   • DTo rename an existing column
   Reveal Solution Discussion Select an answer first