Home / Google / Professional Cloud Database Engineer

Google Professional Cloud Database Engineer Practice Test - Questions Answers

Question list

List of questions

Question 1

(0)

Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency

Question 2

(0)

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You ne

Question 3

(0)

You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises. You need to transfer data from these databases into BigQuery for analytics. You w

Question 4

(0)

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability

Question 5

(0)

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.

Question 6

(0)

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud

Question 7

(0)

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 los

Question 8

(0)

You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?

Question 9

(0)

You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Goo

Question 10

(0)

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 appli

Question 1

Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?

Create the database with Google-managed encryption keys.

Create the database with customer-managed encryption keys.

Create the database persistent disk with Google-managed encryption keys.

Create the database persistent disk with customer-managed encryption keys.

Show Answer Comment (0)

Question 2

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).

Edit the instance to change the storage type from HDD to SSD.

Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.

Create a read replica of the instance with SSDs, and perform a failover to the new instance

Show Answer Comment (0)

Question 3

You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.

You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.

Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.

Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.

Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.

Show Answer Comment (0)

Question 4

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

Migrate the databases to Cloud Spanner.

Migrate the databases to Cloud SQL, and enable a standby database.

Migrate the databases to Compute Engine using regional persistent disks.

Migrate the databases to Bare Metal Solution for Oracle.

Show Answer Comment (0)

Question 5

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?

Create a new VPC network in each project, and use VPC Network Peering to connect the two together.

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

Use the default networks, and leverage Cloud VPN to connect the two together.

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

Show Answer Comment (0)

Question 6

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?

Restore the Cloud SQL instance from the automatic backups in region 3.

Restore the Cloud SQL instance from the automatic backups in another zone in region 1.

Check 'Lag Bytes' in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .

Show Answer Comment (0)

Question 7

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?

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

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

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

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

Show Answer Comment (0)

Question 8

You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?

Issue a rollback, and download your server certificate.

Create a new client certificate, and download it.

Create a new server certificate, and download it.

Reset your SSL configuration, and download your server certificate.

Show Answer Comment (0)

Question 9

Reuse the existing service account that populates this database.

Create a new service account, and grant it the Cloud Spanner Database Admin role.

Create a new service account, and grant it the Cloud Spanner Database Reader role.

Create a new service account, and grant it the spanner.databases.select permission.

Show Answer Comment (0)

Question 10

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?

Watch Query Insights for long running queries.

Watch the Cloud SQL instance monitor for CPU utilization metrics.

Watch the Cloud SQL recommenders for overprovisioned instances.

Watch Cloud Trace for application requests that are failing.

Show Answer Comment (0)

Total 132 questions