ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 157 - Professional Cloud Architect discussion

Report
Export

You are implementing a single Cloud SQL MySQL second-generation database that contains business-critical transaction data. You want to ensure that the minimum amount of data is lost in case of catastrophic failure. Which two features should you implement? (Choose two.)

A.
Sharding
Answers
A.
Sharding
B.
Read replicas
Answers
B.
Read replicas
C.
Binary logging
Answers
C.
Binary logging
D.
Automated backups
Answers
D.
Automated backups
E.
Semisynchronous replication
Answers
E.
Semisynchronous replication
Suggested answer: C, D

Explanation:

Section: [none]

Backups help you restore lost data to your Cloud SQL instance. Additionally, if an instance is having a problem, you can restore it to a previous state by using the backup to overwrite it. Enable automated backups for any instance that contains necessary data. Backups protect your data from loss or damage.

Enabling automated backups, along with binary logging, is also required for some operations, such as clone and replica creation. Reference: https://cloud.google.com/sql/docs/mysql/backup-recovery/backups

asked 18/09/2024
Billy Mitchell
29 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first