Google Cloud SQL - High availability and failover MCQ

Google Cloud SQL – 10 – High availability and failover MCQ

1 / 10

1. What are high availability and failover mechanisms designed to minimize in Google Cloud SQL?

Data encryption

Query optimization

Maintenance window

Data redundancy

2 / 10

2. How does automatic failover work in Google Cloud SQL?

It increases storage capacity

It stops the database instance

It promotes a standby instance to primary

It requires manual intervention

3 / 10

3. What is the primary benefit of read replicas in Cloud SQL?

Offloading read-only traffic

Increasing font size

Reducing storage costs

Changing font colors

4 / 10

4. How can you enable high availability for a Google Cloud SQL instance using the Google Cloud Console?

By setting up log export to Cloud Storage

By configuring custom monitoring policies

By enabling "High availability" in instance details

By adjusting the machine type of the instance

5 / 10

5. In the event of a failover, what happens to the standby instance in Google Cloud SQL?

It becomes the new primary instance

It decreases storage capacity

It stops running

It becomes a read replica

6 / 10

6. What is the primary benefit of monitoring failover events in Google Cloud SQL?

Increasing font size

Reducing the cost of the database instance

Minimizing downtime

Exporting logs to Cloud Storage

7 / 10

7. What should you configure to receive notifications about failover events in Google Cloud SQL?

Log export settings

Read replicas

Alerting policies

Maintenance window settings

8 / 10

8. Which feature in Google Cloud SQL automatically configures a standby instance in a different availability zone?

Auto Scaling

Maintenance window

High availability

Read replicas

9 / 10

9. How can you create read replicas in Google Cloud SQL using the Google Cloud Console?

By creating a new project in Google Cloud Platform

By enabling "Read replica" in the instance details

By exporting logs to SQL dump files

By adjusting font size in Cloud Console

10 / 10

10. What’s the primary purpose of high availability and failover in Google Cloud SQL?

Changing font colors

Increasing font size

Exporting logs to SQL dump files

Minimizing downtime

Your score is

Google Cloud SQL – High availability and failover MCQ