Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam

Exam Professional Data Engineer topic 1 question 92 discussion

Actual exam question from Google's Professional Data Engineer

Question #: 92
Topic #: 1

[All Professional Data Engineer Questions]

You need to migrate a 2TB relational database to Google Cloud Platform. You do not have the resources to significantly refactor the application that uses this database and cost to operate is of primary concern.
Which service do you select for storing and serving your data?

A. Cloud Spanner
B. Cloud Bigtable
C. Cloud Firestore
D. Cloud SQL

Show Suggested Answer

Suggested Answer: D 🗳️

by [deleted] at March 22, 2020, 4:39 p.m.

Comments

Submit Cancel

midgoo

1 year, 11 months ago

Selected Answer: D

Cloud SQL: max storage for shared core = 3TB and for dedicated core = up to 64TB Only use Spanner if we need autoscale (Note that Cloud SQL could scale too but not automatic yet) or the size is too big (as above) or 4/5 9s HA (Cloud SQL is only 99.95)

upvoted 2 times

...

zellck

2 years, 2 months ago

Selected Answer: D

D is the answer.

upvoted 1 times

...

Nirca

2 years, 3 months ago

Selected Answer: D

Cloud SQL is relational DB (pg mssql, mysql)

upvoted 1 times

...

Dhass

2 years, 7 months ago

Answer - D

upvoted 1 times

...

homaj

2 years, 8 months ago

Selected Answer: D

answer D

upvoted 1 times

...

sumanshu

3 years, 7 months ago

Vote for D

upvoted 3 times

...

daghayeghi

3 years, 10 months ago

D: https://cloud.google.com/sql/docs/features

upvoted 1 times

...

GypsyMonkey

4 years, 1 month ago

D, cloud SQL is a relational database; if > 10tb, then choose spanner

upvoted 3 times

...

atnafu2020

4 years, 5 months ago

D Cloud SQL supports MySQL 5.6 or 5.7, and provides up to 624 GB of RAM and 30 TB of data storage, with the option to automatically increase the storage size as needed.

upvoted 3 times

Abhi16820

3 years, 2 months ago

64TB AS OF TODAY

upvoted 5 times

...

haroldbenites

4 years, 5 months ago

D is correct. Obviously

upvoted 3 times

...

Barniyah

4 years, 9 months ago

But cloud SQL storage is limited to several hundreds of GB's for all instances and we need 2TB. So, Cloud spanner is much closer to this, with the exception of the cost

upvoted 3 times

Preetmehta1234

11 months, 2 weeks ago

Nope. Now, the Dedicated core is Up to 64 TB https://cloud.google.com/sql/docs/quotas

upvoted 1 times

...

taepyung

4 years, 9 months ago

At this moment, Cloud SQL is providing up to 30,720GB(about 30TB) So I think it's D.

upvoted 13 times

...

xrun

4 years, 1 month ago

Another consideration is that Cloud SQL uses standard databases like MySQL, PostgreSQL and now MS SQL. Cloud Spanner is a proprietary product of Google and does some things differently than typical databases (no stored procedures and triggers). So migrating to Cloud Spanner makes application refactoring necessary. So Cloud SQL is the answer.

upvoted 5 times

LaxmanTiwari

1 year, 1 month ago

Well explained I can confirmed.

upvoted 1 times

...

Barniyah

4 years, 8 months ago

Sorry , I think it's D https://cloud.google.com/sql/docs/features (Cloud SQL supports MySQL 5.6 or 5.7, and provides up to 416 GB of RAM and 30 TB of data storage, with the option to automatically increase the storage size as needed.)

upvoted 5 times

...