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

Question 13

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?

A. Use gcloud sql instances failover <PrimaryInstanceName>.

B. Use gcloud sql instances failover .

C. Use gcloud sql instances promote-replica .

D. Use gcloud sql instances promote-replica .

Correct Answer:A

Question 14

You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?

A. Set up a Shared VPC, configure multiple service projects, and create firewall rules.

B. Set up Serverless VPC Access.

C. Set up Private Service Connect.

D. Set up Traffic Director.

Correct Answer:A
https://medium.com/google-cloud/shared-vpc-in-google-cloud-64527e0a409e#:~:text=Unlike VPC peering, Shared VPC connects projects within the same organization.&text=There are a lot of,between VPCs in different projects.

Question 15

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 Cloud SQL for MySQL external replica.

D. Use the mysqldump utility and binary logs.

Correct Answer:C
An external replica is a method that allows you to create a read-only copy of your Cloud SQL instance on an external server, such as a Compute Engine instance or an on-premises database server1. An external replica can help you scale reads and offload management operations from your data center to Google Cloud. You can also use an external replica for disaster recovery, migration, or reporting purposes1.
To create an external replica, you need to configure a Cloud SQL instance that replicates to one or more replicas external to Cloud SQL, and a source representation instance that
represents the source database server in Cloud SQL1. You also need to enable access on the Cloud SQL instance for the IP address of the external replica, create a replication user, and export and import the data from the source database server to the external replica1.

Question 16

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?

A. Use Database Migration Service to migrate all databases to Cloud SQL.

B. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.

C. Use data replication tools and CDC tools to enable migration.

D. Use a combination of Database Migration Service and partner tools to support the data migration strategy.

Correct Answer:A
https://cloud.google.com/blog/products/databases/tips-for-migrating-across-compatible-database-engines

Question 17

You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?

A. Use the default app profile with single-cluster routing.

B. Use the default app profile with multi-cluster routing.

C. Create a custom app profile with multi-cluster routing.

D. Create a custom app profile with single-cluster routing.

Correct Answer:C
https://cloud.google.com/bigtable/docs/app-profiles#default-app-profile The question states that a single cluster existed first, then a second cluster was added. Google’s documentation states, “if you created the instance with one cluster, the default app profile uses single-cluster routing. This ensures that adding additional clusters later does not change the behavior of your existing applications”. Simply adding a second cluster does not change the default profile from single-cluster routing to multi-cluster
routing. Since you need multi-cluster routing, you’re going to need a custom app profile. So C is correct. https://cloud.google.com/bigtable/docs/app-profiles#default-app-profile

Question 18

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 Firestore.

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

C. Migrate the existing database to Cloud Spanner.

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

Correct Answer:B
You could migrate to Spanner leveraging the PostgreSQL dialect, but costs
need to be minimized so that wouldn’t be the cheapest option. Especially since the load doesn’t justify Spanner. Again, you could migrate like-for-like to a GCE VM, but that defeats minimizing the migration effort. The cheapest and easiest way to migrate would be Database Migration Service to Cloud SQL for PostgreSQL.

START Professional-Cloud-Database-Engineer EXAM