A company runs a Cloud SQL for PostgreSQL instance. 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 are willing to pay for a standby instance. What should they configure?

Enable high availability (HA) configuration.

A cross-region failover replica.

Automated backups with a retention of 30 days.

Which Google Cloud feature allows you to restore a previous version of an object in Cloud Storage if it is accidentally overwritten or deleted?

Cloud Storage object versioning

What is the primary difference between zonal and regional data redundancy?

Zonal redundancy is cheaper than regional redundancy.

Zonal redundancy is faster than regional redundancy.

Zonal redundancy is for databases, while regional redundancy is for storage.

Zonal redundancy protects against zone failures, while regional redundancy protects against region failures.

Which Google Cloud managed feature provides a read replica in a different region to support disaster recovery for Cloud SQL?

Cloud SQL cross-region failover replica

Persistent disk snapshot replication

Cloud Storage cross-region replication

Which Google Cloud managed backup feature is specifically designed to protect Cloud SQL databases by creating automated backups that can be used for point-in-time recovery?

Cloud Storage object versioning

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 1)

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 1–5

1application · medium
A company runs a Cloud SQL for PostgreSQL instance. 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 are willing to pay for a standby instance. What should they configure?
Select an answer first
2foundation · easy
Which Google Cloud feature allows you to restore a previous version of an object in Cloud Storage if it is accidentally overwritten or deleted?
Select an answer first
3foundation · easy
What is the primary difference between zonal and regional data redundancy?
Select an answer first
4foundation · easy
Which Google Cloud managed feature provides a read replica in a different region to support disaster recovery for Cloud SQL?
Select an answer first
5foundation · easy
Which Google Cloud managed backup feature is specifically designed to protect Cloud SQL databases by creating automated backups that can be used for point-in-time recovery?
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.