Google Cloud Certified - Professional Cloud Database Engineer (Professional-Cloud-Database-Engineer) Free Practice Test

Question 1

Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?

A. Watch Cloud Trace for application requests that are failing.

B. Watch the Cloud SQL instance monitor for CPU utilization metrics.

C. Watch the Cloud SQL recommenders for overprovisioned instances.

D. Watch Query Insights for long running queries.

Correct Answer: D

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

Question 2

You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?

A. Migrate the existing database to Cloud SQL for PostgreSQL.

B. Migrate the existing database to Firestore.

C. Migrate the existing database to PostgreSQL running on Compute Engine.

D. Migrate the existing database to Cloud Spanner.

Correct Answer: A

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

Question 3

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud.
You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

A. Create migration job using Database Migration Service.
Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode.
Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete.
Update your application connections to the new instance.

B. Create migration job using Database Migration Service.
Set the migration job type to One-time, and perform this migration during a maintenance window.
Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database.
Update your application connections to the new instance.

C. Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window.
Move the files to Cloud Storage, and import each database into your Cloud SQL instance.
Continue to dump each database until all the databases are migrated.
Update your application connections to the new instance.

D. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL.
Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination.
Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance.

Correct Answer: A

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

Question 4

You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

A. Use Cloud Spanner in a regional configuration.

B. Use Cloud Spanner in a multi-region configuration.

C. Use Cloud SQL with cross-region replicas.

D. Use highly available Cloud SQL with multiple zones.

Correct Answer: A

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

Question 5

Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?

A. Issue a gcloud compute instances update command to increase the number of vCPUs.

B. Back up the database, create an instance with additional vCPUs, and restore the database.

C. Update a MySQL database flag to increase the number of vCPUs.

D. Issue a gcloud sql instances patch command to increase the number of vCPUs.

Correct Answer: D

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

Question 6

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. Create a new VPC network in each project, and use VPC Network Peering to connect the two together.

C. Place both the application VMs and the Cloud SQL instances in the default network of each project.

D. Create a Shared VPC that both the application VMs and Cloud SQL instances will use.

Correct Answer: D

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

Question 7

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS.
You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

A. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.

B. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).

C. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.

D. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.

Correct Answer: D

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

Welcome to TestSimulate

Google Cloud Certified - Professional Cloud Database Engineer (Professional-Cloud-Database-Engineer) Free Practice Test