
Ultimate access to all questions.
Your company is planning to migrate its data processing infrastructure to the cloud. Describe the steps you would take to design and implement an ETL pipeline in the cloud, considering the scalability, cost-effectiveness, and performance requirements. Explain how you would leverage cloud computing and distributed computing concepts in the process.
A
Use a single cloud service provider and deploy a monolithic ETL pipeline without considering scalability or cost-effectiveness.
B
Design a multi-cloud, serverless ETL pipeline that leverages cloud computing and distributed computing concepts, such as auto-scaling, pay-as-you-go pricing, and parallel processing.
C
Migrate the existing on-premises ETL pipeline to the cloud without any modifications or optimizations for cloud computing.
D
Use a traditional on-premises ETL pipeline and only store the processed data in the cloud for backup and disaster recovery purposes.