Professional-Cloud-Database-Engineer by Google Actual Free Exam Questions And Answers

Question 1

You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions.
You want to follow Google-recommended practices for the migration. What should you do?

A. Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

B. Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

C. Enable high availability (HA) for the database to make it regional.

D. Create a read replica in another region, and promote the read replica if a failure occurs.

Discussion 0

Correct Answer: C Vote an answer

Question 2

You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency.
What should you do?

A. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.

B. Use linear scaling to implement the Autoscaler-based architecture

C. Use direct scaling to implement the Autoscaler-based architecture.

D. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

A. Configure Firestore, and modify your application to offload queries.

B. Configure Bigtable, and modify your application to offload queries.

C. Configure Cloud SQL for PostgreSQL read replicas to offload queries.

D. Configure Memorystore, and modify your application to offload queries.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?

A. Use Cloud Debugger to inspect the state of an application.

B. Use Error Reporting to count, analyze, and aggregate the data.

C. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

D. Use Logs Explorer to analyze log data.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

You are the DBA of your organization. You provided a cloned instance from the production Cloud SQL for PostSQL database to the developers for testing purposes. After the creation of the clone. Your developers notice missing data in one of the recently altered tables. What should you do to ensure that all data in included?

A. Take a back up of the production database and restore It to another Cloud SQL for PostgreSQL Instance. Provide access to the new instance to the developers.

B. Clone the current production database, and restore it to an earlier point in time IPITR) Provide access to the cloned instance to the developers.

C. check for missing rotes and privileges in 'he cloned Cloud SQL instance. Grant missing privileges to the developers.

D. Dump the production database to a fie. Modify the dumped file to ALTER TABLE to SET LOGGED on tables that were unlogged in production. Reload the data in the new Cloud SQL for PostgreSQL Instance.

Discussion 0

Correct Answer: B Vote an answer

Question 6

You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

A. Use external server replication.

B. Use Data Migration Service.

C. Use the mysqldump utility and binary logs.

D. Use Cloud SQL for MySQL external replica.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 7

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 through Pub/Sub to call the cloudsql.instances.export API.

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

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

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

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 8

You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

A. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.

B. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

C. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

D. Use the default configuration for the automated backups location.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer Exam Practice Test

Contact Us

Useful Links

Latest Updated