Practice Test 4 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
An application has the following requirement
- It required strongly consistent
- Total data as of now is 1GB, which can grow significantly in future therefore horizontal scaling, is required
- It should be highly available.
Currently, this data is stored in a highly available relational database with a very high memory configuration, so performance is more desired than cost-benefit. Which data technology would be the best fit as per Google’s recommendation?
A. Big Query
B. Big Table
C. Cloud SQL
D. Cloud Spanner
The correct answer is D
Option A is incorrect. BigQuery is wrong, as it does not support consistent transactions. BigQuery is mostly used for analytical purposes.
Option B is incorrect. BigTable is wrong, as BigTable is not a relational database service.
Option C is incorrect. Although Cloud SQL support strong consistency and is highly available but due to horizontal scaling required by the customer Cloud SQL will not be an appropriate choice. Cloud SQL can only store up to 10TB of data and will not be able to scale for future needs.
Option D is correct. Cloud Spanner is a strongly consistent relational database which does not have a limitation on data storage. Also, customer needs performance over cost benefits so cloud spanner could the best choice in this case.
Cloud Spanner is the first scalable, enterprise-grade, globally distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale. This combination delivers high-performance transactions and strong consistency across rows, regions, and continents with an industry-leading 99.999% availability SLA.
Comments are closed, but trackbacks and pingbacks are open.