Transform Data DP-600 Practice Questions (Page 7)

Questions 31–35

1. 31application · medium

   A Fabric warehouse has a Sales table and a Product table. Business analysts frequently need to query sales with product category and region, but they should not see the internal ProductCost column. You need to provide a simplified, secure interface for these analysts. What should you create?

   • AA function that returns the product cost and the analysts join it themselves.
   • BA view that joins Sales and Product, selects only the needed columns, and grants the analysts access to the view.
   • CA stored procedure that returns the joined data and grants execute permission to the analysts.
   • DA new table that copies the joined data and grants select on the table.
   Reveal Solution Discussion Select an answer first
2. 32application · medium

   A Fabric warehouse has an orders table and a customers table. The team needs a report that lists all orders, including orders that do not have a matching customer record (for example, orders placed by deleted customers). The report must include customer name when available. Which join type should they use?

   • ARIGHT OUTER JOIN
   • BFULL OUTER JOIN
   • CLEFT OUTER JOIN
   • DINNER JOIN
   Reveal Solution Discussion Select an answer first
4. 33application · medium

   A Fabric pipeline loads a CSV file into a lakehouse table. The OrderDate column is stored as a string in the format 'YYYYMMDD'. You need to convert it to a date data type so that date-based filters work correctly. Some rows contain '00000000' for unknown dates. What should you do?

   • AUse a Dataflow to convert the column to date using the appropriate locale format, and replace '00000000' with null before the conversion.
   • BCast the column directly to date in a SQL query, and let the invalid rows fail the load.
   • CLeave the column as string and create a calculated column that parses the date only for valid rows.
   • DConvert the column to integer first, then to date using the DATEADD function.
   Reveal Solution Discussion Select an answer first
5. 34application · medium

   A logistics company has a Fabric lakehouse table with shipment records. The table has a weight_kg column that contains NULL for some rows and a weight_lb column that is always populated. The team needs a new column, weight_standardized, that uses weight_lb converted to kg when weight_kg is NULL, otherwise uses weight_kg. What is the most efficient way to add this column?

   • AConvert the weight_lb column to a string data type.
   • BCreate a view that only selects rows where weight_kg is not NULL.
   • CCreate a stored procedure that updates the weight_kg column with converted values.
   • DAdd a calculated column using a CASE expression that checks for NULL and performs the conversion.
   Reveal Solution Discussion Select an answer first
6. 35expert · hard

   A Fabric warehouse has a Sales table with a Discount column that contains NULL for orders without a discount. You need to calculate the total revenue after discount, but you also need to report the number of orders that did not receive a discount. Which approach should you use?

   • AUse a CASE statement to set Discount to 0 for NULL and then use COUNT(Discount) for the count.
   • BUse COALESCE(Discount, 1) for the revenue calculation and COUNT(Discount) for the count.
   • CReplace NULL with 0 in the Discount column and then use SUM(Quantity * UnitPrice * (1 - Discount)).
   • DUse ISNULL(Discount, 0) for the revenue calculation and COUNT(CASE WHEN Discount IS NULL THEN 1 END) for the count of non-discounted orders.
   Reveal Solution Discussion Select an answer first