ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam
Go to 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 Hide Answer
Suggested Answer: D 🗳️
by [deleted] at March 22, 2020, 4:39 p.m.

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
Submit Cancel
[Removed]
Highly Voted 4 years, 7 months ago
Answer - D
upvoted 24 times
...
[Removed]
Highly Voted 4 years, 7 months ago
Answer: D Description: Cloud SQl cheap and relational DB.
upvoted 13 times
...
midgoo
Most Recent 1 year, 8 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
1 year, 10 months ago
Selected Answer: D
D is the answer.
upvoted 1 times
...
Nirca
2 years ago
Selected Answer: D
Cloud SQL is relational DB (pg mssql, mysql)
upvoted 1 times
...
Dhass
2 years, 4 months ago
Answer - D
upvoted 1 times
...
homaj
2 years, 5 months ago
Selected Answer: D
answer D
upvoted 1 times
...
sumanshu
3 years, 3 months ago
Vote for D
upvoted 3 times
...
daghayeghi
3 years, 7 months ago
D: https://cloud.google.com/sql/docs/features
upvoted 1 times
...
GypsyMonkey
3 years, 10 months ago
D, cloud SQL is a relational database; if > 10tb, then choose spanner
upvoted 3 times
...
atnafu2020
4 years, 2 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
2 years, 11 months ago
64TB AS OF TODAY
upvoted 5 times
...
...
haroldbenites
4 years, 2 months ago
D is correct. Obviously
upvoted 3 times
...
Barniyah
4 years, 6 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
8 months, 1 week ago
Nope. Now, the Dedicated core is Up to 64 TB https://cloud.google.com/sql/docs/quotas
upvoted 1 times
...
taepyung
4 years, 6 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
3 years, 10 months 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
10 months, 2 weeks ago
Well explained I can confirmed.
upvoted 1 times
...
...
Barniyah
4 years, 5 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
...
...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago