DBS-C01 · Question #82
A company needs a data warehouse solution that keeps data in a consistent, highly structured format. The company requires fast responses for end-user queries when looking at data from the current…
The correct answer is C. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store. "With the Concurrency Scaling feature, you can support virtually unlimited concurrent users and concurrent queries, with consistently fast query performance. When concurrency scaling is enabled, Amazon Redshift automatically adds additional cluster capacity when you need it to…
Question
A company needs a data warehouse solution that keeps data in a consistent, highly structured format. The company requires fast responses for end-user queries when looking at data from the current year, and users must have access to the full 15-year dataset, when needed. This solution also needs to handle a fluctuating number incoming queries. Storage costs for the 100 TB of data must be kept low. Which solution meets these requirements?
Options
- ALeverage an Amazon Redshift data warehouse solution using a dense storage instance type
- BLeverage an Amazon Redshift data warehouse solution using a dense storage instance to store
- CLeverage an Amazon Redshift data warehouse solution using a dense storage instance to store
- DLeverage an Amazon Redshift data warehouse solution using a dense storage instance to store
How the community answered
(17 responses)- A18% (3)
- B6% (1)
- C71% (12)
- D6% (1)
Explanation
"With the Concurrency Scaling feature, you can support virtually unlimited concurrent users and concurrent queries, with consistently fast query performance. When concurrency scaling is enabled, Amazon Redshift automatically adds additional cluster capacity when you need it to process an increase in concurrent read queries. Write operations continue as normal on your main cluster. Users always see the most current data, whether the queries run on the main cluster or on a concurrency scaling cluster. You're charged for concurrency scaling clusters only for the time they're in use. For more information about pricing, see Amazon Redshift pricing. You manage which queries are sent to the concurrency scaling cluster by configuring WLM queues. When you enable concurrency scaling for a queue, eligible queries are sent to the concurrency scaling cluster instead of waiting in line." https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html
Topics
Community Discussion
No community discussion yet for this question.