AWS Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Your company is planning to implement a data warehousing solution to support business intelligence and analytics. Describe the steps you would take to design and implement an ETL pipeline for a data warehouse, and explain the considerations involved in optimizing the data model for query performance.
A
Use a single-stage ETL process to load all data into the data warehouse and perform all transformations and analysis there, without considering the data model optimization.
B
Design a multi-stage ETL pipeline with appropriate data modeling techniques, such as star schema or snowflake schema, to optimize the data model for query performance.
C
Use a traditional file-based storage system to store the data, as it is more cost-effective than using a data warehouse.
D
Focus only on the ETL process and ignore the data modeling aspect, as it is not relevant to query performance.