Exam Associate Cloud Engineer topic 1 question 260 discussion

Actual exam question from Google's Associate Cloud Engineer

Question #: 260
Topic #: 1

[All Associate Cloud Engineer Questions]

You are building a backend service for an ecommerce platform that will persist transaction data from mobile and web clients. After the platform is launched, you expect a large volume of global transactions. Your business team wants to run SQL queries to analyze the data. You need to build a highly available and scalable data store for the platform. What should you do?

A. Create a multi-region Cloud Spanner instance with an optimized schema.
B. Create a multi-region Firestore database with aggregation query enabled.
C. Create a multi-region Cloud SQL for PostgreSQL database with optimized indexes.
D. Create a multi-region BigQuery dataset with optimized tables.

Show Suggested Answer

Suggested Answer: A 🗳️

by shiowbah at Dec. 30, 2023, 6:56 a.m.

Comments

Submit Cancel

apb98

Highly Voted 1 year, 6 months ago

Selected Answer: A

A. Key is “large volume of global transactions”, so Cloud Spanner would be a good choice.

upvoted 7 times

...

Timfdklfajlksdjlakf

Most Recent 10 months, 2 weeks ago

Selected Answer: A

PiperMe perfectly summed it up. Rember: Global + SQL = Cloud Spanner

upvoted 4 times

...

PiperMe

1 year, 4 months ago

Selected Answer: A

A. Global + SQL = Cloud Spanner

upvoted 4 times

...

KelvinToo

1 year, 6 months ago

Selected Answer: A

Per ChatGPT, Option A, creating a multi-region Cloud Spanner instance with an optimized schema, is the best choice for building a highly available and scalable data store that can efficiently handle global transactions and support SQL queries for analysis.

upvoted 4 times

...

shiowbah

1 year, 6 months ago

A. Create a multi-region Cloud Spanner instance with an optimized schema.

upvoted 4 times

...