25. Question 25 How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Item_Master_Dim table? 1 point 7 …
24. Question 24 Which field did you use to sort data to merge with the Item_Master_Dim table? 1 point ItemId ItemMasterKey ItemMasterDim ItemMasterId
23. Question 23 How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Cust_Vendor_Dim table? 1 point 10 9…
22. Question 22 Which field did you use to sort data to merge with the Cust_Vendor_Dim table? 1 point CustVendorKey Trans_Type_Key State AddreBookId
21. Question 21 How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Trans_Type_Dim table? 1 point 13 12…
19. Question 19 How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Date_Dim table? 1 point 12 …
17. Question 17 How many rows appear in the preview result (or the Written column in the step metrics) after filtering rows of the Access table with null values? 1…
16. Question 16 How many rows are inserted into the Inventory_Fact table? 1 point 9 11 10 8
15. Question 15 For this question, make sure the Quantity is used as the B (right) field in the Calculator step. The ExtCost calculated for the Inventory_Fact table for Customer…
14. Question 14 The UnitCost calculated for the Inventory_Fact table for Customer 1 is 1 point 3.32 11.22 1.71 33.11
