Back to Amazon Redshift

Backup & Restore on Amazon Redshift

5 minutes 5 Questions

Amazon Redshift provides automated backup and restore capabilities to protect and recover your data. By default, Amazon Redshift takes regular snapshots of your data and stores them in Amazon S3 for 1 day, which can be increased up to 35 days as per your backup retention policy. The snapshots can b…

Test mode:
Start practice test
AWS Certified Solutions Architect - Backup & Restore on Amazon Redshift Example Questions

Test your knowledge of Backup & Restore on Amazon Redshift

Question 1

A company runs a production Amazon Redshift cluster with business‑critical data. They require automatic backups and off‑site redundancy across AWS Regions to maximize durability and support disaster recovery with minimal operational effort. Which configuration should they enable on the cluster?

Correct Answer: Enable automated snapshots and cross-region snapshot copy

Automated snapshots provide continuous, scheduled backups of the Redshift cluster to Amazon S3 in the same Region, giving point-in-time recovery without operator action. Configuring cross-region snapshot copy replicates those snapshots automatically to a different AWS Region, adding off-site redundancy for disaster recovery and higher durability. Enabling only automated snapshots keeps backups in a single Region. Enabling only cross-region copy without automated snapshots provides nothing to replicate. Relying solely on manual snapshots introduces operational risk and does not ensure consistent RPO/RTO for business-critical workloads.

Question 2

An ETL operation has caused data corruption in an Amazon Redshift cluster. The corruption was identified 3 hours after the operation began. How can you restore the data in the cluster to the state it was in at the start of the ETL operation?

Correct Answer: Restore the cluster from a snapshot taken prior to the ETL operation and specify the desired time for the new cluster

In this scenario, you should restore the cluster from a snapshot taken prior to the ETL operation and specify the desired time for the new cluster. This will create a new cluster with data at the state it was in at the specified time. Other options either don't work for Redshift or are not feasible in this situation.

Question 3

A company is currently storing its sensitive data in an Amazon Redshift cluster. The company wants to ensure that all data is encrypted, both at rest and in transit. What should you recommend?

Correct Answer: Enable cluster encryption and SSL encryption

To ensure that all data is encrypted in a Redshift cluster, both at rest and in transit, you should enable cluster encryption for data at rest and SSL encryption for data in transit. Other options are either not applicable or do not provide the required encryption mechanism.

More Backup & Restore on Amazon Redshift questions
18 questions (total)
Start 18 question test