exam questions

Exam Associate Cloud Engineer All Questions

View all questions & answers for the Associate Cloud Engineer exam

Exam Associate Cloud Engineer topic 1 question 219 discussion

Actual exam question from Google's Associate Cloud Engineer
Question #: 219
Topic #: 1
[All Associate Cloud Engineer Questions]

You are planning to migrate the following on-premises data management solutions to Google Cloud:

• One MySQL cluster for your main database
• Apache Kafka for your event streaming platform
• One Cloud SQL for PostgreSQL database for your analytical and reporting needs

You want to implement Google-recommended solutions for the migration. You need to ensure that the new solutions provide global scalability and require minimal operational and infrastructure management. What should you do?

  • A. Migrate from MySQL to Cloud SQL, from Kafka to Pub/Sub, and from Cloud SQL for PostgreSQL to BigQuery.
  • B. Migrate from MySQL to Cloud Spanner, from Kafka to Pub/Sub, and from Cloud SQL for PostgreSQL to BigQuery.
  • C. Migrate from MySQL to Cloud Spanner, from Kafka to Memorystore, and from Cloud SQL for PostgreSQL to Cloud SQL.
  • D. Migrate from MySQL to Cloud SQL, from Kafka to Memorystore, and from Cloud SQL for PostgreSQL to Cloud SQL.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
VijKall
Highly Voted 1 year, 1 month ago
Selected Answer: B
Needs Global scalability ---- Spanner is in, CloudSQL is out. Kafka --> Pub/Sub & not memory store. Postgres --> BigQuery as it needs scalability and for analytics.
upvoted 11 times
...
kacper07
Most Recent 6 months, 1 week ago
B is correct, even M$ copilot chose it :D
upvoted 1 times
...
ExamsFR
1 year, 2 months ago
Selected Answer: B
B is the correct answer.
upvoted 2 times
...
joao_01
1 year, 2 months ago
Selected Answer: B
Its B, makes sense
upvoted 2 times
...
Captain1212
1 year, 2 months ago
B is the correrct answer as question demands global scalibity for it cloud spanner , for PostgreSQL to BIG query
upvoted 2 times
...
scanner2
1 year, 3 months ago
Selected Answer: B
For event streaming -> Cloud Pub/Sub is a good choice. https://cloud.google.com/pubsub/docs/overview Database for analytics and reporting -> BigQuery is a good choice. https://cloud.google.com/bigquery/docs/introduction For MySQL, we have two options Cloud SQL or Cloud Spanner. Cloud SQL has MySQL flavored database, while Cloud Spanner provide Google Standard SQL (aka GoogleSQL) which supports standard SQL queries. In addition, the question is asking about "global scalability and require minimal operational and infrastructure management", where Cloud Spanner wins a score. Hence, B is the correct answer. https://cloud.google.com/spanner https://cloud.google.com/spanner/docs/create-query-database-console#create-instance https://cloud.google.com/spanner/docs/create-query-database-console#create-database
upvoted 2 times
...
3arle
1 year, 4 months ago
Selected Answer: B
agree B
upvoted 1 times
...
Speridian
1 year, 4 months ago
B should be the answer. Cloud Spanner - Global support.
upvoted 1 times
...
[Removed]
1 year, 4 months ago
Selected Answer: B
B should be right
upvoted 3 times
...
ankitb4u
1 year, 4 months ago
B should be the answer as cloud spanner provides scalability
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago