Exam AWS Certified Solutions Architect - Professional topic 1 question 428 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional

Question #: 428
Topic #: 1

[All AWS Certified Solutions Architect - Professional Questions]

A Solutions Architect has been asked to look at a company's Amazon Redshift cluster, which has quickly become an integral part of its technology and supports key business process. The Solutions Architect is to increase the reliability and availability of the cluster and provide options to ensure that if an issue arises, the cluster can either operate or be restored within four hours.
Which of the following solution options BEST addresses the business need in the most cost-effective manner?

A. Ensure that the Amazon Redshift cluster has been set up to make use of Auto Scaling groups with the nodes in the cluster spread across multiple Availability Zones.
B. Ensure that the Amazon Redshift cluster creation has been templated using AWS CloudFormation so it can easily be launched in another Availability Zone and data populated from the automated Redshift back-ups stored in Amazon S3.
C. Use Amazon Kinesis Data Firehose to collect the data ahead of ingestion into Amazon Redshift and create clusters using AWS CloudFormation in another region and stream the data to both clusters.
D. Create two identical Amazon Redshift clusters in different regions (one as the primary, one as the secondary). Use Amazon S3 cross-region replication from the primary to secondary region, which triggers an AWS Lambda function to populate the cluster in the secondary region.

Show Suggested Answer

Suggested Answer: B 🗳️
Q: What happens to my data warehouse cluster availability and data durability if my data warehouse cluster's Availability Zone (AZ) has an outage?
If your Amazon Redshift data warehouse cluster's Availability Zone becomes unavailable, you will not be able to use your cluster until power and network access to the AZ are restored. Your data warehouse cluster's data is preserved so you can start using your Amazon Redshift data warehouse as soon as the AZ becomes available again. In addition, you can also choose to restore any existing snapshots to a new AZ in the same Region. Amazon Redshift will restore your most frequently accessed data first so you can resume queries as quickly as possible.
Reference:
https://aws.amazon.com/redshift/faqs/?nc1=h_ls

by donathon at Oct. 7, 2019, 2:47 a.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

Submit Cancel

Moon

Highly Voted 3 years, 9 months ago

I do support answer "B". The question does not request availability on different AZ. The solution can tolerate 4 hours RTO. Therefore, CloudFront for Redshift, and backup stored in S3. https://aws.amazon.com/blogs/big-data/building-multi-az-or-multi-region-amazon-redshift-clusters/ A: Redshift can not work on Multi AZ! C: Kinesis not meant for cross region population! D: is a perfect answer, but not cost effective. More redundant than required!

upvoted 45 times

DashL

3 years, 8 months ago

Option C can't be a solution because it is cost effective. But the link provided by Moon (https://aws.amazon.com/blogs/big-data/building-multi-az-or-multi-region-amazon-redshift-clusters/) brings up a very interesting point: The link outlines a solution where Kinesis Streams can be used to deliver data to a Redshift Cluster either in a different AZ or in a different different Region. Redshift can be a destination for Kinesis Firehose (https://docs.aws.amazon.com/firehose/latest/dev/create-destination.html#create-destination-redshift). If Kinesis Streams can be cross regional, then why Firehose can't be? However I couldn't find any documentation on how Kinesis (Either Streams or Firehose) can be used for cross region population?

upvoted 2 times

...

Marcos

Highly Voted 3 years, 9 months ago

Agree with B. https://aws.amazon.com/redshift/faqs/?nc1=h_ls Q: What happens to my data warehouse cluster availability and data durability if my data warehouse cluster's Availability Zone (AZ) has an outage? If your Amazon Redshift data warehouse cluster's Availability Zone becomes unavailable, you will not be able to use your cluster until power and network access to the AZ are restored. Your data warehouse cluster's data is preserved so you can start using your Amazon Redshift data warehouse as soon as the AZ becomes available again. In addition, you can also choose to restore any existing snapshots to a new AZ in the same Region. Amazon Redshift will restore your most frequently accessed data first so you can resume queries as quickly as possible.

upvoted 10 times

...

Chris22usa

Most Recent 1 year, 7 months ago

now Redshift can support Multi AZ! ----------- Unlike single-AZ deployments, customers can now improve availability of Redshift by running their data warehouse in a multi-AZ deployment. A multi-AZ deployment allows you to run your data warehouse in multiple AWS Availability Zones (AZ) simultaneously and continue operating in unforeseen failure scenarios. No application changes are required to maintain business continuity since the Multi-AZ deployment is managed as a single data warehouse with one endpoint. Multi-AZ deployments reduce recovery time by guaranteeing capacity to automatically recover and are intended for customers with business-critical analytics applications that require the highest levels of availability and resiliency to AZ failures. This also allows customers to implement a solution that is more compliant with the recommendations of the Reliability Pillar of the AWS Well-Architected Framework. To learn more about Amazon Redshift Multi-AZ refer here.

upvoted 1 times

...

SkyZeroZx

2 years ago

3 years, 8 months ago

B A: Redshift cluster doesn't support Multi-AZ C/D: Both need to deploy multiple identical Redshift clusters into two AZ/Regions, which double the cost.

upvoted 2 times

newme

3 years, 8 months ago

Only that, how to know 4 fours is enough for CloudFormation to start up new Redshift cluster?

upvoted 2 times

...

T14102020

3 years, 9 months ago

B is correct as most cost-effective.

upvoted 1 times

...

Load full discussion...