AWS Certified Data Engineer – Associate (DEA-C01) — Question 183

A company uses a variety of AWS and third-party data stores. The company wants to consolidate all the data into a central data warehouse to perform analytics. Users need fast response times for analytics queries.

The company uses Amazon QuickSight in direct query mode to visualize the data. Users normally run queries during a few hours each day with unpredictable spikes.

Which solution will meet these requirements with the LEAST operational overhead?

Answer options

• A. Use Amazon Redshift Serverless to load all the data into Amazon Redshift managed storage (RMS).
• B. Use Amazon Athena to load all the data into Amazon S3 in Apache Parquet format.
• C. Use Amazon Redshift provisioned clusters to load all the data into Amazon Redshift managed storage (RMS).
• D. Use Amazon Aurora PostgreSQL to load all the data into Aurora.

Correct answer: A

Explanation

The correct answer is A because Amazon Redshift Serverless automatically scales to accommodate varying workloads and minimizes the need for manual management, making it ideal for unpredictable query spikes. Options B, C, and D involve either more complex management or do not align with the requirement for low operational overhead; for instance, provisioned clusters in option C necessitate constant resource management.