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 81
- Exam Question
- Correct Answer
- Question 82
- Exam Question
- Correct Answer
- Question 83
- Exam Question
- Correct Answer
- Question 84
- Exam Question
- Correct Answer
- Question 85
- Exam Question
- Correct Answer
- Question 86
- Exam Question
- Correct Answer
- Question 87
- Exam Question
- Correct Answer
- Question 88
- Exam Question
- Correct Answer
- Question 89
- Exam Question
- Correct Answer
- Question 90
- Exam Question
- Correct Answer
Question 81
Exam Question
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
A. Use a change data capture (CDC) migration strategy.
B. Move the physical database servers from on-premises to Google Cloud.
C. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
D. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
E. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
Correct Answer
A. Use a change data capture (CDC) migration strategy.
D. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
Question 82
Exam Question
You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?
A. Export the data from the existing database, and load the data into a new Cloud SQL database.
B. Use Migrate for Compute Engine to complete the migration.
C. Use Datastream to complete the migration.
D. Use Database Migration Service to complete the migration.
Correct Answer
A. Export the data from the existing database, and load the data into a new Cloud SQL database.
Question 83
Exam Question
You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?
A. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
B. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
C. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
D. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
Correct Answer
B. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
Question 84
Exam Question
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?
A. Enable serializable isolation in the Firebase app.
B. Deploy a US multi-region Firestore location.
C. Build a Firestore bundle, and deploy bundles to Cloud CDN.
D. Create a Firestore index on the news story date.
Correct Answer
C. Build a Firestore bundle, and deploy bundles to Cloud CDN.
Question 85
Exam Question
You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?
A. Use Firestore and ensure that the PersistenceEnabled option is set to true.
B. Use Memorystore for Memcached.
C. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
D. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
Correct Answer
C. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
Question 86
Exam Question
You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)
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).
Correct Answer
C. Identity all tables that do not have at least one foreign key.
E. Identify whether the source database uses customer-managed encryption keys (CMEK).
Question 87
Exam Question
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?
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.
Correct Answer
D. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
Question 88
Exam Question
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?
A. Use Firestore.
B. Use Cloud Spanner.
C. Use Cloud SQL.
D. Use Bigtable.
Correct Answer
C. Use Cloud SQL.
Question 89
Exam Question
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?
A. Create a VM in Compute Engine, and run a cron job.
B. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
C. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
D. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
Correct Answer
C. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
Question 90
Exam Question
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?
A. Isolate the data analysts and operations user groups to use different Bigtable instances.
B. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
C. Use Key Visualizer for Bigtable.
D. Add more nodes to the Bigtable cluster.
Correct Answer
B. Check the Cloud Monitoring table/bytes_used metric from Bigtable.