A company runs a Cloud SQL for PostgreSQL instance in us-central1. They need to recover from a regional outage with an RPO of less than 5 minutes and an RTO of less than 1 hour. They also need to minimize cost. They are considering using automated backups with PITR. What should they do?

Use Cloud Storage object versioning.

Enable high availability (HA) configuration.

Create a cross-region failover replica.

Use automated backups with PITR and accept the RTO of restoring from backups.

A company runs a web application on Compute Engine in a single zone. They store user data in a Cloud Storage bucket in the same region. They need to improve availability to protect against a zone failure. They have a limited budget and want to minimize changes to their application. What should they do?

Create a second Compute Engine instance in another zone and put a load balancer in front.

Move the Cloud Storage bucket to a dual-region location.

Move the Cloud Storage bucket to a multi-region location.

Create a managed instance group with instances in multiple zones and a load balancer, and move the Cloud Storage bucket to a dual-region location.

A company runs a Cloud SQL for MySQL instance in the us-central1 region. They need to recover the database with minimal data loss if the entire region becomes unavailable. They can tolerate a recovery time of up to 15 minutes. What should they configure?

A zonal failover replica in a different zone within us-central1.

Automated backups with a retention of 7 days.

Enable high availability (HA) configuration on the primary instance.

A cross-region failover replica in us-east1.

Google CloudAssociate Data Practitioner

Domain 4Objective 3

4.3 Identify High Availability and Disaster Recovery Strategies for Data in Cloud Storage and Cloud SQL ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 4)

Part of the Data Management domain, which accounts for ~25% of the ASSOCIATE-DATA-PRACTITIONER exam.

22questions here

5free pages

7concepts

~25%of the exam

Questions 16–20

16expert · hard
A company runs a Cloud SQL for PostgreSQL instance in us-central1. They need to recover from a regional outage with an RPO of less than 5 minutes and an RTO of less than 1 hour. They also need to minimize cost. They are considering using automated backups with PITR. What should they do?
Select an answer first
17foundation · easy
When evaluating replication for data redundancy, which factor is a trade-off that often increases with more replication?
Select an answer first
18expert · hard
A company runs a web application on Compute Engine in a single zone. They store user data in a Cloud Storage bucket in the same region. They need to improve availability to protect against a zone failure. They have a limited budget and want to minimize changes to their application. What should they do?
Select an answer first
19application · medium
A company runs a Cloud SQL for MySQL instance in the us-central1 region. They need to recover the database with minimal data loss if the entire region becomes unavailable. They can tolerate a recovery time of up to 15 minutes. What should they configure?
Select an answer first
20foundation · easy
Which Cloud Storage location type provides redundancy across two regions within a single location?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to ASSOCIATE-DATA-PRACTITIONER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “ASSOCIATE-DATA-PRACTITIONER” is a trademark of its owner, used for identification only.

4.3 Identify High Availability and Disaster Recovery Strategies for Data in Cloud Storage and Cloud SQL ASSOCIATE-DATA-PRACTITIONER Practice Questions (Page 4)

Questions 16–20

A company runs a Cloud SQL for PostgreSQL instance in us-central1. They need to recover from a regional outage with an RPO of less than 5 minutes and an RTO of less than 1 hour. They also need to minimize cost. They are considering using automated backups with PITR. What should they do?

When evaluating replication for data redundancy, which factor is a trade-off that often increases with more replication?

A company runs a Cloud SQL for MySQL instance in the us-central1 region. They need to recover the database with minimal data loss if the entire region becomes unavailable. They can tolerate a recovery time of up to 15 minutes. What should they configure?

Which Cloud Storage location type provides redundancy across two regions within a single location?

Keep studying — Data Management