Exam Professional Data Engineer topic 1 question 159 discussion

Correct: A It asks for scaling up which can be done in cloud sql, horizontal scaling is not possible in cloud sql Automatic storage increase If you enable this setting, Cloud SQL checks your available storage every 30 seconds. If the available storage falls below a threshold size, Cloud SQL automatically adds additional storage capacity. If the available storage repeatedly falls below the threshold size, Cloud SQL continues to add storage until it reaches the maximum of 30 TB.

Should be C.

I would go to C.

All the arguments below can essentially be boiled down to two questions. 1) is Cloud SQL fully managed? (yes), 2) Does it autoscale? It depends, is the answer. The question is horrifyingly worded, as it comes down to an ambiguity coinflip. I'm going with C, it feels like it's a better fit.

Did not refer to global, thus not spanner. A is correct

Transactional consistency: spanner provides strong consistency across rows, regions, and continents.

Answer : A Cloud SQL and Cloud Spanner are the options for the questions. But here as per requirement they don't need horizontal scaling, they want manager SQL instance and it should support 6 TB of storage. Cloud SQL can support up to 64 TB of storage https://cloud.google.com/sql/docs/quotas#:~:text=Cloud%20SQL%20storage%20limits,core%3A%20Up%20to%203%20TB.

Not horizontal scaling is required, cloud SQL will work for 10 TB

i will go with A, since the question doesnt specifically say it should be scaling horizontally

"Able to scale up to 6 TB" -seems to be the key it looks like autoscaling is related to storage - possible in case of Cloud SQL

Spanner is consistent and fully-managed https://cloud.google.com/spanner/docs/transactions?hl=en

A seems to be correct because of the scaling factor of 6 TB because cloud sql easily supports up to 40 TB and obviously there is a limitation of GLOBALLY MULTI REGIONAL which is nothing to do with question. Hence A seems more closer.

Guys - this is 1000% C. ".....automatically scale up" Cloud SQL needs restart! this is not the solution. Only Spanner (and BQ) are true automatically scale up

C: Cloud Spanner Why not A: Cloud SQL? No "automatically" scale up feature

Fully Managed: Cloud Spanner is a fully managed database service provided by Google Cloud, which means you don't have to worry about managing infrastructure, updates, or backups. Automatic Scaling: Cloud Spanner can automatically scale both horizontally and vertically to handle increased workloads and data volume. It can handle databases ranging from a few gigabytes to multi-terabyte scale. Transactionally Consistent: Cloud Spanner offers strong transactional consistency, making it suitable for applications that require ACID compliance. SQL Querying: You can query Cloud Spanner databases using SQL, which is a familiar query language for many developers and analysts. Given your requirements, Cloud Spanner is designed to meet the need for a fully managed, scalable, transactionally consistent, and SQL-accessible database solution.

Able to automatically scale up = Memory and CPU Able to scale up to 6 TB = Disk Correct is C, because Cloud SQL no scale Memory and CPU.

Cloud SQL can also automatically scale up storage capacity when you are near your limit. https://cloud.google.com/sql/?utm_source=google&utm_medium=cpc&utm_campaign=japac-HK-all-en-dr-BKWS-all-super-trial-PHR-dr-1605216&utm_content=text-ad-none-none-DEV_c-CRE_652279903175-ADGP_Hybrid%20%7C%20BKWS%20-%20BRO%20%7C%20Txt%20~%20Databases_Cloud%20SQL_gcp%20horizontal%20sql_main-KWID_43700076522535474-kwd-2005739330106&userloc_2344-network_g&utm_term=KW_google%20sql%20horizontal&gclid=Cj0KCQjwqs6lBhCxARIsAG8YcDjWaS5NbG3remUHnHQ7EFK-wJNsF0I_IvePKHF0mHaiBK3_-eM7Z-UaAqQeEALw_wcB&gclsrc=aw.ds#section-2:~:text=Cloud%20SQL%20can%20also%20automatically%20scale%20up%20storage%20capacity%20when%20you%20are%20near%20your%20limit.