MENU
You are implementing a single Cloud SQL MySQL second-generation database that contains business-critical transaction dat
a. 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.)
Suggested Answer: C, D
Get Premium Professional Cloud Architect Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
14 comments · newest first
JU
Justine
12 months ago
Sharding won't help with data loss, just saying.
BL
Blair
1 year ago
Automated backups and Semisynchronous replication are the best combo!
PA
Paris
1 year ago
Wait, are backups really enough? What if they fail?
MA
Madelyn
1 year ago
I think Read replicas are also important for recovery.
KA
Kaitlyn
1 year ago
Definitely go with Automated backups and Binary logging.
ER
Erinn
1 year ago
Semisynchronous replication sounds familiar, but I feel like automated backups and binary logging are safer bets for minimizing data loss.
ST
Stephaine
1 year ago
I'm a bit confused about sharding; I don't think it helps with data loss, but I'm leaning towards read replicas and automated backups.
CH
Chantell
1 year ago
I remember practicing a question similar to this, and I think binary logging is crucial for data recovery, so I might go with that.
ME
Melissia
1 year ago
I think automated backups are definitely one of the features we should choose, but I'm not entirely sure about the second one.
TA
Tamra
1 year ago
This seems straightforward. I think the key is to allow the ECS instance to access the RDS database through the private IP, while also making the public endpoint available for internet clients.
DO
Dottie
1 year ago
Hmm, I'm a bit unsure about this one. There are a few options that seem reasonable, but I'm not sure which one is the best approach. I'll need to carefully read through each choice and think about the pros and cons.
LA
Laila
1 year ago
I've got a good feeling about this one. The Layout component reference is all about allowing for efficient reuse of report objects, so I'm going to go with option D.
JA
Jackie
1 year ago
I'm a little confused by this question. The passage talks about data model transformation, but doesn't really give a clear recommendation on when to use it. I'll have to guess on this one.
DO
Dong
1 year ago
I think the bank has to believe the customer is high net worth, but I'm not completely sure if that's a strict requirement or more of a guideline.