Free Google Professional-Cloud-Database-Engineer Exam Dumps Questions & Answers

You have a transactional system on PostgreSQL that is being overwhelmed with analytic queries during the work day. You want to move this workload to AlloyDB for PostgreSQL and need to find the most cost-effective solution that supports the transactional and analytic workloads with minimal downtime.
What should you do?

• A.Define a large primary instance to accommodate the transactional and analytic workloads.
• B.Define a primary instance for the transactional workload and a small read pool that you scale out before the work day starts and scale back at night for the analytic workload.
• C.Define a primary instance for the transactional workload, and a large read pool instance for the analytic workload.
• D.Define a primary instance for the transactional workload and a small read pool instance that you scale up when the read pool instance is over 80% CPU busy for the analytic workload.

You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?

• A.Perform the gcloud sql operations list command.
• B.Use the Google Cloud Console.
• C.Use Cloud Audit Logs to verify the status.
• D.Check the cloudsql.googleapis.com/postgres.log instance log.

Your company is rapidly expanding its user base across North America, nearly doubling in the last 6-months. This expansion causes a substantial increase in query volume on your mission- critical Cloud SQL database. This has led to noticeable performance issues and slower query response times. You suspect that your Cloud SQL instance may not be able to handle the incremental load. You need to identify the root cause of this performance bottleneck and ensure that your database can scale with your growing user base. What should you do-

• A.Review Cloud SQL System Insights for the instance, and analyze CPU, memory, and storage utilization metrics.
• B.Create two Cloud SQL instances, and split the workload between them.
• C.Evaluate the application connection pooling configuration settings.
• D.Migrate the database to Spanner.

You are the database specialist at BlueOrbit Logistics and you must grant access for a group of analysts who need to run queries against Cloud Spanner production databases while they must not write data, change schemas, or administer instances. Which IAM role should you assign to meet this requirement?

• A.roles/spanner.databaseAdmin
• B.roles/spanner.databaseUser
• C.roles/spanner.databaseReader
• D.roles/spanner.viewer

You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project. What should you do to configure the networks?

• A.Use the default networks, and leverage Cloud VPN to connect the two together.
• B.Place both the application VMs and the Cloud SQL instances in the default network of each project.
• C.Create a Shared VPC that both the application VMs and Cloud SQL instances will use.
• D.Create a new VPC network in each project, and use VPC Network Peering to connect the two together.