Professional-Cloud-Database-Engineer Practice Exam Questions and Answers

A.  

Identify whether the database has over 512 tables.

B.  

Identify all tables that do not have a primary key.

C.  

Identity all tables that do not have at least one foreign key.

D.  

Identify whether the source database is encrypted using pgcrypto extension.

E.  

Identify whether the source database uses customer-managed encryption keys (CMEK).

A.  

Increase the number of processing units.

B.  

Modify the database schema, and add additional indexes.

C.  

Shard data required by the application into multiple instances.

D.  

Decrease the number of processing units.

A.  

Create a read replica for the Sales Reporting application.

B.  

Create two separate databases in the instance, and perform dual writes from the Order Management application.

C.  

Use a Cloud SQL federated query for the Sales Reporting application.

D.  

Queue up all the requested reports in PubSub, and execute the reports at night.

A.  

Take no backups, and turn off transaction log retention.

B.  

Take one manual backup per day, and turn off transaction log retention.

C.  

Turn on automated backup, and turn off transaction log retention.

D.  

Turn on automated backup, and turn on transaction log retention.

A.  

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

B.  

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

C.  

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

D.  

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

A.  

Setup a static external IP address in your VPC network.

B.  

Set up bring your own IP (BYOIP) in your VP

C.  

C.  

Set up a Cloud NAT gateway on the Compute Engine VM.

D.  

Set up Cloud NAT service.

A.  

Develop a custom data replication service to send data into BigQuery.

B.  

Use Cloud SQL federated queries.

C.  

Use Database Migration Service to replicate tables into BigQuery.

D.  

Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

A.  

Provision a Cloud SQL for MySQL instance in us-central1-a.

Create a multiple-zone instance in us-west1-b.

Create a read replica in us-east1-c.

B.  

Provision a Cloud SQL for MySQL instance in us-central1-a.

Create a multiple-zone instance in us-central1-b.

Create a read replica in us-east1-b.

C.  

Provision a Cloud SQL for MySQL instance in us-central1-a.

Create a multiple-zone instance in us-east-b.

Create a read replica in us-east1-c.

D.  

Provision a Cloud SQL for MySQL instance in us-central1-a.

Create a multiple-zone instance in us-east1-b.

Create a read replica in us-central1-b.

A.  

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

B.  

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

D.  

C.  

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

D.  

D.  

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

D.  

A.  

Use the Google Cloud Console or gcloud CLI to manually create a new clone database.

B.  

Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.

C.  

Verify that the new replica is created automatically.

D.  

Start the original primary instance and resume replication.