
Explanation:
Amazon Redshift Serverless automatically scales capacity up and down based on query load, eliminating the need to provision or manage clusters. It handles the unpredictable spike pattern cost-effectively, integrates seamlessly with QuickSight in direct query mode, and requires zero capacity management — the least operational overhead of all options.
Ultimate access to all questions.
Question 11.
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?
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.
No comments yet.