Google Professional Cloud Architect Exam - Topic 11 Question 23 Discussion

Actual exam question for Google's Professional Cloud Architect exam

Question #: 23
Topic #: 11

[All Professional Cloud Architect Questions]

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

ASharding

BRead replicas

CBinary logging

DAutomated backups

ESemisynchronous replication

Show Suggested Answer

Suggested Answer: C, D

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.

by Nicolette at May 08, 2022, 04:10 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Architect Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Justine

4 months ago

Sharding won't help with data loss, just saying.

upvoted 0 times

...

Blair

4 months ago

Automated backups and Semisynchronous replication are the best combo!

upvoted 0 times

...

Paris

4 months ago

Wait, are backups really enough? What if they fail?

upvoted 0 times

...

Madelyn

4 months ago

I think Read replicas are also important for recovery.

upvoted 0 times

...

Kaitlyn

5 months ago

Definitely go with Automated backups and Binary logging.

upvoted 0 times

...

Erinn

5 months ago

Semisynchronous replication sounds familiar, but I feel like automated backups and binary logging are safer bets for minimizing data loss.

upvoted 0 times

...

Stephaine

5 months 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.

upvoted 0 times

...

Chantell

5 months 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.

upvoted 0 times

...

Melissia

5 months ago

I think automated backups are definitely one of the features we should choose, but I'm not entirely sure about the second one.

upvoted 0 times

...

Tamra

5 months 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.

upvoted 0 times

...

Dottie

5 months 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.

upvoted 0 times

...

Laila

5 months 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.

upvoted 0 times

...

Jackie

5 months 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.

upvoted 0 times

...

Dong

5 months 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.

upvoted 0 times

...