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
13. Question 13 How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Currency_Dim table? 1 point 11 …
12. Question 12 Which field did you use to sort data before the merge with the Currency_Dim table? 1 point Currency_Name Currency Currency_Id CurrencyDim
11. Question 11 How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Branch_Plant_Dim table? 1 point 11 …
10. Question 10 Which field did you use to sort data before the merge with the Branch_Plant_Dim table? 1 point BranchPlantID BranchPlantkey BPName BranchPlantDim
9. Question 9 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 …
