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…

Question

Options

• AUse Amazon Redshift Serverless to load all the data into Amazon Redshift managed storage
• BUse Amazon Athena to load all the data into Amazon S3 in Apache Parquet format.
• CUse Amazon Redshift provisioned clusters to load all the data into Amazon Redshift managed
• DUse Amazon Aurora PostgreSQL to load all the data into Aurora.

• A
  83% (45)
• B
  6% (3)
• C
  9% (5)
• D
  2% (1)

Explanation

Amazon Redshift Serverless is ideal for this scenario as it provides a fully managed, serverless data warehouse solution with high performance for analytics queries. Key reasons why it meets the requirements with the least operational overhead: Serverless Configuration: Redshift Serverless automatically scales capacity based on query demand, making it well-suited for unpredictable spikes in usage without requiring manual Managed Storage (RMS): Loading data into Amazon Redshift managed storage provides optimized storage for analytics and integrates with Amazon QuickSight for fast query performance in direct query mode. Cost-Effective and Low Management: Since the data warehouse is only actively used for a few hours daily, Redshift Serverless provides a cost- effective option by scaling resources dynamically, which eliminates the need to manage and pay for idle infrastructure.

No community discussion yet for this question.