Practice Test 3 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You have an on-premise MySQL database that you have been asked to move to Google Cloud. Users should run SQL queries to fetch data from the database. Your solution should be cost-effective and allow increasing read capacities in the future. Which of the following Google Cloud product is the best for this scenario?
A. Cloud Storage
B. Cloud Spanner
C. Cloud SQL
D. Cloud Datastore
Correct Answer: C
Cloud SQL is a fully managed database service that makes it easy to set up, maintain, manage, and administer your relational PostgreSQL, MySQL, and SQL Server databases in the cloud.
Option A is incorrect: Google Storage is blob storage. It does not work as an RDMS.
Option B is incorrect: Cloud Spanner is a very sophisticated and expensive approach for this scenario. Cloud SQL is enough to cover the requirements.
Option D is incorrect: Datastore is a schemaless NoSQL database. Migration is from a structured SQL database so Datastore is not a viable choice.
Source(s):
Cloud SQL:
Comments are closed, but trackbacks and pingbacks are open.