The latest Google Professional Cloud Database Engineer certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Google Professional Cloud Database Engineer exam and earn Google Professional Cloud Database Engineer certification.
Table of Contents
- Question 71
- Exam Question
- Correct Answer
- Question 72
- Exam Question
- Correct Answer
- Question 73
- Exam Question
- Correct Answer
- Question 74
- Exam Question
- Correct Answer
- Question 75
- Exam Question
- Correct Answer
- Question 76
- Exam Question
- Correct Answer
- Question 77
- Exam Question
- Correct Answer
- Question 78
- Exam Question
- Correct Answer
- Question 79
- Exam Question
- Correct Answer
- Question 80
- Exam Question
- Correct Answer
Question 71
Exam Question
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 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.
Correct Answer
A. Issue a gcloud sql instances patch command to increase the number of vCPUs.
Question 72
Exam Question
You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:
- Can read tables, views, and DDL
- Can write rows to the tables
- Can add columns and indexes
- Cannot drop the database
What should you do?
A. Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
B. Assign the Cloud Spanner Database Admin role.
C. Assign the Cloud Spanner Database User role.
D. Assign the Cloud Spanner Admin role.
Correct Answer
C. Assign the Cloud Spanner Database User role.
Question 73
Exam Question
You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?
A. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
B. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
C. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
D. Configure the primary, standby, and read replica instances in zone A, all in the same region.
Correct Answer
B. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
Question 74
Exam Question
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
A. Set up all read replicas in a different region using asynchronous replication.
B. Set up all read replicas in the same region as the primary instance with synchronous replication.
C. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
D. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
Correct Answer
C. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
Question 75
Exam Question
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
A. Create a clone database from a read replica database, and restore the clone in the same region.
B. Create a clone database from a read replica database, and restore the clone into a different zone.
C. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
D. Use the Cloud SQL database import feature. Import last week’s dump file from Cloud Storage.
Correct Answer
C. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
Question 76
Exam Question
Your hotel booking company is expanding into Country A, where personally identifiable information
(PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer dat a. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?
A. Apply a schema data management pattern.
B. Apply an instance data management pattern.
C. Apply a table data management pattern.
D. Apply a database data management pattern.
Correct Answer
B. Apply an instance data management pattern.
Question 77
Exam Question
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?
A. Create the database with Google-managed encryption keys.
B. Create the database with customer-managed encryption keys.
C. Create the database persistent disk with Google-managed encryption keys.
D. Create the database persistent disk with customer-managed encryption keys.
Correct Answer
D. Create the database persistent disk with customer-managed encryption keys.
Question 78
Exam Question
Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?
A.
Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Keep backups older than one day stored in Actifio OnVault storage.
B.
Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Keep backups older than one day stored in Actifio OnVault storage.
C.
Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.
D.
Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.
Correct Answer
B.
Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Keep backups older than one day stored in Actifio OnVault storage.
Question 79
Exam Question
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?
A. Export the data from the existing instance, and import the data into a new instance with solidstate drives (SSDs).
B. Edit the instance to change the storage type from HDD to SSD.
C. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
D. Create a read replica of the instance with SSDs, and perform a failover to the new instance.
Correct Answer
C. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
Question 80
Exam Question
You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?
A. Automate instance creation by writing a Dataflow job.
B. Automate instance creation by setting up Terraform scripts.
C. Create the instances using the Google Cloud Console UI.
D. Create clones from a template Cloud SQL instance.
Correct Answer
C. Create the instances using the Google Cloud Console UI.