Professional-Cloud-Database-Engineer Google Exam Questions and Free Practice Test

Question 31

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

A. Use Bigtable.

B. Use Firestore.

C. Use Cloud SQL for MySQL

D. Use Cloud Spanner.

Correct Answer:D
Spanner covers the SLA

Question 32

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

A. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.

B. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

C. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.

D. Use Cloud Composer to execute a select * from table(s) query and export results.

Correct Answer:B
https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler

START Professional-Cloud-Database-Engineer EXAM