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 41
- Exam Question
- Correct Answer
- Question 42
- Exam Question
- Correct Answer
- Question 43
- Exam Question
- Correct Answer
- Question 44
- Exam Question
- Correct Answer
- Question 45
- Exam Question
- Correct Answer
- Question 46
- Exam Question
- Correct Answer
- Question 47
- Exam Question
- Correct Answer
- Question 48
- Exam Question
- Correct Answer
- Question 49
- Exam Question
- Correct Answer
- Question 50
- Exam Question
- Correct Answer
Question 41
Exam Question
You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?
A. Use Cloud SQL with read replicas for throughput.
B. Use Firestore, and rely on automatic serverless scaling.
C. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
D. Use Bigtable, and add nodes as necessary to achieve the required throughput.
Correct Answer
C. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
Question 42
Exam Question
Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?
A. Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes onpremises.
B. Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
C. Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
D. Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.
Correct Answer
C. Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
Question 43
Exam Question
Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?
A. Identify and optimize slow running queries, or set parallel replication flags.
B. Stop all running queries, and re-create the replicas.
C. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
D. Edit the primary instance to add additional memory.
Correct Answer
C. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
Question 44
Exam Question
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?
A. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
B. Create your database with one primary node and one read replica in the region.
C. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
D. Configure your Cloud SQL instance with high availability enabled.
Correct Answer
A. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
Question 45
Exam Question
You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?
A. Use Cloud Spanner with a customer-managed encryption key (CMEK).
B. Use Cloud Spanner with default encryption.
C. Use Cloud SQL with a customer-managed encryption key (CMEK).
D. Use Bigtable with default encryption.
Correct Answer
C. Use Cloud SQL with a customer-managed encryption key (CMEK).
Question 46
Exam Question
You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?
A. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
B. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
C. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
D. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
Correct Answer
B. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
Question 47
Exam Question
You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?
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.
Correct Answer
B. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
Question 48
Exam Question
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?
A. Use Logs Explorer to analyze log data.
B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
C. Use Error Reporting to count, analyze, and aggregate the data.
D. Use Cloud Debugger to inspect the state of an application.
Correct Answer
B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
Question 49
Exam Question
You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company’s disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?
A. Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
B. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
C. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a crossregion read replica, and promote the read replica as the primary node for disaster recovery.
D. Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
Correct Answer
C. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a crossregion read replica, and promote the read replica as the primary node for disaster recovery.
Question 50
Exam Question
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?
A. Setup a static external IP address in your VPC network.
B. Set up bring your own IP (BYOIP) in your VPC.
C. Set up a Cloud NAT gateway on the Compute Engine VM.
D. Set up Cloud NAT service.
Correct Answer
C. Set up a Cloud NAT gateway on the Compute Engine VM.