Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Associate Cloud Engineer Exam - Topic 4 Question 87 Discussion

You want to select and configure a cost-effective solution for relational data on Google Cloud Platform. You are working with a small set of operational data in one geographic location. You need to support point-in-time recovery. What should you do?
B) Select Cloud SQL (MySQL). Select the create failover replicas option.
A) Select Cloud SQL (MySQL). Verify that the enable binary logging option is selected.
C) Select Cloud Spanner. Set up your instance with 2 nodes.
D) Select Cloud Spanner. Set up your instance as multi-regional.

Google Associate Cloud Engineer Exam - Topic 4 Question 87 Discussion

Actual exam question for Google's Associate Cloud Engineer exam
Question #: 87
Topic #: 4
[All Associate Cloud Engineer Questions]

You want to select and configure a cost-effective solution for relational data on Google Cloud Platform. You are working with a small set of operational data in one geographic location. You need to support point-in-time recovery. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Beatriz at Jul 10, 2024, 10:14 PM

Limited Time Offer

25%

Off

Get Premium Associate Cloud Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Charlene
9 months ago
Not sure about A, binary logging can add overhead.
upvoted 0 times
...
Ty
9 months ago
A makes sense, especially for a small dataset.
upvoted 0 times
...
Carli
10 months ago
Surprised that Spanner is even an option here, seems overkill!
upvoted 0 times
...
Bobbye
10 months ago
I think B is better for redundancy, though.
upvoted 0 times
...
Alise
10 months ago
A is definitely the way to go for point-in-time recovery!
upvoted 0 times
...
Buck
10 months ago
I recall that failover replicas are more about high availability than point-in-time recovery, so I’m leaning away from option B.
upvoted 0 times
...
Coleen
11 months ago
I practiced a similar question where Cloud SQL was the answer for small datasets. I feel like option A is the safest bet here.
upvoted 0 times
...
Gerardo
11 months ago
I'm not entirely sure, but I think Cloud Spanner is more for larger datasets. Does it even support point-in-time recovery?
upvoted 0 times
...
Terrilyn
11 months ago
I remember that point-in-time recovery is crucial for operational data, so I think Cloud SQL with binary logging might be the right choice.
upvoted 0 times
...
Sanda
11 months ago
Option A looks like the way to go. Cloud SQL is a cost-effective relational database that should meet the requirements, and the binary logging will provide the point-in-time recovery needed.
upvoted 0 times
...
Shawnee
11 months ago
Hmm, I'm a bit unsure here. I'm trying to decide between Cloud SQL and Cloud Spanner. I'll need to review the differences in more detail to determine the best fit for this small operational dataset.
upvoted 0 times
...
Ashley
11 months ago
This seems pretty straightforward. I'd go with option A - Cloud SQL with binary logging enabled to support point-in-time recovery.
upvoted 0 times
...
Tomas
11 months ago
I'm a little confused by the Cloud Spanner options. Isn't that more for large-scale, highly scalable workloads? For a small set of operational data, I think Cloud SQL is the better choice here.
upvoted 0 times
...
Cora
11 months ago
I feel pretty confident about this one. Based on my experience with Citrix App Layering, I think the best approach is to export all the layers from Site A and then import them into Site B. That way, I know everything will be in sync across the two datacenters.
upvoted 0 times
...
Keneth
11 months ago
I think HTML can definitely display images, but I'm unsure about the other types.
upvoted 0 times
...
Cordie
1 year ago
Multi-regional Cloud Spanner? What is this, the Avengers HQ? I just need a straightforward relational database, thank you very much.
upvoted 0 times
...
Lino
1 year ago
Failover replicas? Nah, I'm a basic kind of guy. Just give me that binary logging and I'm good to go!
upvoted 0 times
...
Francesco
1 year ago
Cloud Spanner? Nah, that's overkill for my needs. I'll stick with Cloud SQL and keep it simple.
upvoted 0 times
Lucy
1 year ago
Cloud Spanner? Nah, that's overkill for my needs. I'll stick with Cloud SQL and keep it simple.
upvoted 0 times
...
Felix
1 year ago
B) Select Cloud SQL (MySQL). Select the create failover replicas option.
upvoted 0 times
...
Billye
1 year ago
A) Select Cloud SQL (MySQL). Verify that the enable binary logging option is selected.
upvoted 0 times
...
...
Hoa
1 year ago
Hmm, I'd go with Cloud SQL and the failover replicas option. Gotta have that high Reenailability!
upvoted 0 times
Micah
1 year ago
Hmm, I'd go with Cloud SQL and the failover replicas option. Gotta have that high Reenailability!
upvoted 0 times
...
Micheline
1 year ago
B) Select Cloud SQL (MySQL). Select the create failover replicas option.
upvoted 0 times
...
Evangelina
1 year ago
A) Select Cloud SQL (MySQL). Verify that the enable binary logging option is selected.
upvoted 0 times
...
...
Reena
1 year ago
Cloud SQL (MySQL) with binary logging seems like the most cost-effective and reliable option for a small set of operational data.
upvoted 0 times
Jesusita
1 year ago
B) Select Cloud SQL (MySQL). Select the create failover replicas option.
upvoted 0 times
...
Douglass
1 year ago
A) Select Cloud SQL (MySQL). Verify that the enable binary logging option is selected.
upvoted 0 times
...
...
Darnell
1 year ago
Hmm, that's a good point. I see the rationale behind selecting Cloud Spanner for this scenario.
upvoted 0 times
...
Phung
1 year ago
I disagree, I believe the better option is D) Select Cloud Spanner and set up the instance as multi-regional for better data availability.
upvoted 0 times
...
Darnell
1 year ago
I think the answer is A) Select Cloud SQL (MySQL) and enable binary logging for point-in-time recovery.
upvoted 0 times
...

Save Cancel