ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 17 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 17
Topic #: 1
[All AWS Certified Database - Specialty Questions]

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?

  • A. Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while keeping all the data on local Amazon Redshift storage. Provision enough instances to support high demand.
  • B. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Provision enough instances to support high demand.
  • C. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Enable Amazon Redshift Concurrency Scaling.
  • D. Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum layer. Leverage Amazon Redshift elastic resize.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by BillyMadison at July 20, 2020, 6:30 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
BillyMadison
Highly Voted 3 years, 7 months ago
C. https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html "ith 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."
upvoted 14 times
...
aviathor
Most Recent 1 year, 11 months ago
These days, wouldn't you rather use RA3 nodes that automatically unload unused data to 23
upvoted 2 times
...
novice_expert
3 years ago
Selected Answer: C
https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html
upvoted 1 times
...
JustPassIt
3 years, 1 month ago
D. Main cluster can't be a single-node cluster.
upvoted 1 times
...
GMartinelli
3 years, 5 months ago
Selected Answer: C
Option C
upvoted 2 times
...
GaryY
3 years, 6 months ago
Why not D? I think D (Redshift elastic resize) is also correct.
upvoted 1 times
surisitcs
3 years, 6 months ago
Elastic resize is only available for Amazon Redshift clusters that use the EC2-VPC platform. Option of "Dense Storage" and "Elastic resize" is mutually exclusive I think
upvoted 1 times
Jiang_aws1
2 years, 7 months ago
# https://aws.amazon.com/redshift/faqs/ Q: What is Elastic Resize and how is it different from Concurrency Scaling? Elastic Resize adds or removes nodes from a single Redshift cluster within minutes to manage its query throughput. For example, an ETL workload for certain hours in a day or month-end reporting may need additional Amazon Redshift resources to complete on time. Concurrency Scaling adds additional cluster resources to increase the overall query concurrency.
upvoted 3 times
...
...
...
GMartinelli
3 years, 6 months ago
C. But I would argue that you could use redshift spectrum for everything, I just don´t know if you can use it on S3 IA for the historical data, but it might work.
upvoted 1 times
im_not_robot
2 years, 3 months ago
redshift spectrum doesn't have fast response so C is incorrect.
upvoted 1 times
...
...
guru_ji
3 years, 7 months ago
C ==>> Correct
upvoted 2 times
...
aws4myself
3 years, 7 months ago
C => S3 + local storage + concurrency scaling
upvoted 1 times
...
LMax
3 years, 7 months ago
Agree with C
upvoted 1 times
...
myutran
3 years, 7 months ago
Ans: C
upvoted 1 times
...
Ebi
3 years, 7 months ago
C is the answer
upvoted 2 times
...
BillyC
3 years, 7 months ago
C Here
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago