A company runs a Cloud SQL for MySQL instance in us-central1. They need to ensure that the database remains available if a zone fails. They do not need cross-region redundancy. What should they configure?

Enable high availability (HA) configuration on the instance.

Create a cross-region failover replica in us-east1.

Create a read replica in the same region.

A company runs a Cloud SQL for SQL Server instance. They need to recover from accidental data deletion by an administrator. They want to restore the database to a specific point in time from the last 7 days. What should they enable?

A cross-region failover replica.

Automated backups with point-in-time recovery (PITR) enabled.

Object versioning on the Cloud Storage bucket.

High availability (HA) configuration.

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

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 21–22

21application · medium
A company runs a Cloud SQL for MySQL instance in us-central1. They need to ensure that the database remains available if a zone fails. They do not need cross-region redundancy. What should they configure?
Select an answer first
22application · medium
A company runs a Cloud SQL for SQL Server instance. They need to recover from accidental data deletion by an administrator. They want to restore the database to a specific point in time from the last 7 days. What should they enable?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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 5)

Questions 21–22

A company runs a Cloud SQL for MySQL instance in us-central1. They need to ensure that the database remains available if a zone fails. They do not need cross-region redundancy. What should they configure?

A company runs a Cloud SQL for SQL Server instance. They need to recover from accidental data deletion by an administrator. They want to restore the database to a specific point in time from the last 7 days. What should they enable?

Keep studying — Data Management