CAF-3 · Chapter 6 · Question 9 of 15
In the ETL process, standardizing date formats across different systems (e.g., converting DD/MM/YYYY to MM/DD/YYYY) and calculating new metrics from raw figures occurs during which phase?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: B) Transform
Explanation
The "Transform" phase involves cleaning, standardizing, and enriching the raw data to ensure it is structured and consistent before loading
More Data Warehouse Schemas & Data Marts MCQs
- Q11A data architect designs a schema for a new data warehouse. The design features a single central 'Fact Table' containing total sales…
- Q12To save storage space and ensure stricter data integrity, a database engineer modifies a Star Schema by breaking down the 'Product'…
- Q13An enterprise wants to integrate its 'Sales' process and its 'Inventory' process into one analytical model. The database designer creates…
- Q14What is the primary trade-off between choosing a Star Schema versus a Snowflake Schema for a data warehouse?
- Q15The Marketing Department of a large corporation finds the main enterprise data warehouse too massive and slow for their specific daily…