Exam Professional Data Engineer topic 1 question 160 discussion

A. Cloud SQL (30TB)

A as limit is now 30 TB for Cloud SQL

Cloud SQL storage limit: dedicated core up to 64 TB.

two keywords: Transactional data, 20 TB

Scalability: Cloud Spanner is designed to handle large volumes of data, making it suitable for a 20 TB database. It can scale horizontally and vertically to accommodate growing data needs. Global Distribution: Cloud Spanner allows you to distribute data globally for low-latency access across regions, which can be advantageous for operational systems. Strong Consistency: It provides strong transactional consistency, which is important for operational systems that require ACID compliance. SQL Support: Cloud Spanner supports SQL, which is a familiar query language for developers. While Cloud SQL, Cloud Bigtable, and Cloud Datastore have their use cases, Cloud Spanner is better suited for larger databases with strong consistency requirements, making it a suitable choice for migrating a 20 TB operational system database to GCP.

Cloud SQL, upto 64 TB now, you can always call GCP for increasing the quota though !!

Cloud SQL is generally better for OLTP, and Cloud SQL is up to 64 TB now. https://cloud.google.com/sql/docs/quotas#storage_limits

"move its operational system transaction data from an on-premises database to GCP". Cloud SQL may be plug-and-play

Not 100% in favour of A, Should i recommend my client Cloud SQL, when they are coming to me with 20TB already 30TB is limit, its transactional data, which i can't compromise. I will propose cloud spanner. There is nothing mentioned that they want to save cost.

A. Cloud SQL

A is the answer. https://cloud.google.com/sql/docs/features#features Up to 64 TB of storage available, with the ability to automatically increase storage size as needed.

With the given requirements A. Cloud SQL is more than sufficient. Don't try to overthink scenarios like what if it grows.. what if there's additional requirement in future.. what if this what if that.. just look at the question and see the stated requirement. If there are more than one answer try to see which is simple and doesn't come with extra frills.

A 65 TB now in Nov 2022

it is already 20 TB at the moment, and you probably want to change the database because the capacity of your current storage solution is not enough. Then you decide to change it to Cloud SQL(up to 30 TB) which may not increase much capacity? I am not sure about the answer but A looks weird imho.

Cloud SQL can store 64 Tb, but in the intial set up the operation are 20tb. It will reach the limitation soon if you choose Cloud SQL

Depends.. I mean, C is correct if the exam is not updated. A is correct if the exam is updated. So ... kinda in catch 22 situation ...

Hi everyone, Can i purchase this exam? is it worthable?