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 9 Discussion

Your company has an internal application for managing transactional orders. The application is used exclusively by employees in a single physical location. The application requires strong consistency, fast queries, and ACID guarantees for multi-table transactional updates. The first version of the application is implemented inPostgreSQL, and you want to deploy it to the cloud with minimal code changes. Which database is most appropriate for this application?
B) Cloud SQL
A) BigQuery
C) Cloud Spanner
D) Cloud Datastore

Google Associate Cloud Engineer Exam - Topic 4 Question 9 Discussion

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

Your company has an internal application for managing transactional orders. The application is used exclusively by employees in a single physical location. The application requires strong consistency, fast queries, and ACID guarantees for multi-table transactional updates. The first version of the application is implemented inPostgreSQL, and you want to deploy it to the cloud with minimal code changes. Which database is most appropriate for this application?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Shawnda at May 06, 2022, 09:01 AM

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
Lashunda
10 months ago
Surprised that Cloud SQL is the top choice! I expected something else.
upvoted 0 times
...
Ryann
10 months ago
Really? I thought Cloud Datastore was more flexible for transactions.
upvoted 0 times
...
Mozell
10 months ago
But what about scalability? Cloud Spanner might be better.
upvoted 0 times
...
Ceola
10 months ago
I agree, Cloud SQL has the ACID properties we need.
upvoted 0 times
...
Luisa
10 months ago
Cloud SQL is a great fit since it supports PostgreSQL.
upvoted 0 times
...
Antonio
10 months ago
I feel like Cloud Datastore is more for NoSQL applications, so it probably wouldn’t meet the ACID requirements we need here.
upvoted 0 times
...
Keva
11 months ago
I practiced a similar question where we had to choose between Cloud SQL and Cloud Spanner, and I think Cloud SQL was the right choice for strong consistency and ACID compliance.
upvoted 0 times
...
Merri
11 months ago
I'm not entirely sure, but I think Cloud Spanner is more for horizontal scaling and might not be necessary for a single location application.
upvoted 0 times
...
Helene
11 months ago
I remember that Cloud SQL is designed for relational databases and supports PostgreSQL, so it might be a good fit for minimal code changes.
upvoted 0 times
...
Ronna
11 months ago
Hmm, I'm a bit confused. The question mentions "unable to connect" in the browser, but the pool member is functioning correctly. I'll need to think this through step-by-step.
upvoted 0 times
...
Karan
11 months ago
Okay, let me think this through step-by-step. I believe the key is understanding where the products should be associated.
upvoted 0 times
...

Save Cancel