Practice Test 4 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You work as a data engineer in a bank that is migrating from an on-premise database to Google Cloud. You need to select a database in Google Cloud that should cater to below needs:
- Database should be relational and should support SQL features.
- Should be ACID compliant
- Applying a DML should be fast and should not bring the database down.
- Should cater growing need for data storage
- Should be fast and atomic for transaction handling
Below are the options available. Select the most appropriate one.
A. Cloud SQL
B. Cloud Datastore
C. Cloud Spanner
D. Maria DB
Correct answer is C.
Option A is incorrect. As one of the requirement in the question is to consider the growing need for data storage, Cloud SQL is not the correct database as it supports up to 10 TB (Shared Core) for storage per database server. Cloud SQL does vertical scalability and not horizontal scalability.
Option B is incorrect. As the requirement states that the database should be relational, Cloud Datastore is NOSQL database.
Option C is correct. Cloud Spanner should be the choice of a database based on the requirement. Spanner is a relational database with horizontal scaling. Also, it is ACID-compliant and can handle the transaction with strong consistency. Users can add nodes to spanner to increase the database size. Also, implementing a DML/bulk update does not bring the database down. Spanner takes care of all.
Option D is incorrect. There is no managed service in Google Cloud for Maria DB. User will have to create its own instance of Maria DB using Google compute engine. Also, the maintenance of the database will be user responsibility. It has also, the same limitation as Cloud SQL.
Comments are closed, but trackbacks and pingbacks are open.