Professional-Cloud-Database-Engineer Exam Dumps - Google Cloud Certified - Professional Cloud Database Engineer

Go to page:

Question # 17

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

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.

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.

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.

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.

Full Access

Question # 18

You are setting up a new AlloyDB instance and want users to be able to use their existing identity and Access Managemen (IAM) identities to connect to AlloyDB. You have performed the following steps:

Manually enabled IAM authentication on the AlloyDB instance

Granted the allowdb-databaseUser and serviceusage.serviceusageConsumer IAM roles to the users

Created new AllowDB database users based on corresponding IAM identities

Users are able to connect but are reporting that they are not able to SELECT from application tables. What should you do?

Grant the alloydb.client IAM role to each user.

Grant the alloydb.viewer IAM role to each user.

Grant the new database users access privileges to the appropriate tables.

Grant the alloydb.alloydbreplica IAM role to each user.

Full Access

Question # 19

You are migrating critical production database from Amazon RDS for MySQL to Cloud SQL for MYSQL by using Google Cloudâ€™s Migration Service.

You want to keep disruption to your production database to minimum and, at the same time, optimize migration performance. What should you do?

Create and start multiple Database Migration Service jobs to migrate your database to the target Cloud SQL for MySQL instance.

Upgrade the Amazon RDS for MySQL primary instance to an instance with more vCPUs and memory, and then run Google Cloud's Database Migration Service.

Create a single Database Migration Service migration job with initial load parallelism configured to maximum on the source Amazon RDS for MySQL read replica.

Create a single Database Migration Service migration job with initial Load Parallelism configured to Maximum on the Amazon RDS for MySQL primary instance.

Full Access

Question # 20

Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?

Use replication to roll out changes to higher environments.

Use backup and restore to roll out changes to higher environments.

Use Liquibase to roll out changes to higher environments.

Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

Full Access

Question # 21

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?

Use gcloud sql instances failover .

Use gcloud sql instances promote-replica .

Full Access

Question # 22

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

Bring DB-1 back online.

Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

Delete DB-2 so that DB-1 automatically reverts to the primary instance.

Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Full Access

Question # 23

You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?

Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.

Check whether your service account has cloudsql.instances.connect permission.

Enable the Cloud SQL Admin API.

Ensure that you are using an external (public) IP address interface.

Full Access

Question # 24

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?

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

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

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

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

Full Access