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 111
- Exam Question
- Correct Answer
- Question 112
- Exam Question
- Correct Answer
- Question 113
- Exam Question
- Correct Answer
- Question 114
- Exam Question
- Correct Answer
- Question 115
- Exam Question
- Correct Answer
- Question 116
- Exam Question
- Correct Answer
- Question 117
- Exam Question
- Correct Answer
- Question 118
- Exam Question
- Correct Answer
- Question 119
- Exam Question
- Correct Answer
- Question 120
- Exam Question
- Correct Answer
Question 111
Exam Question
Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?
A. Use workload identity federation to impersonate a service account.
B. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
C. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
D. Ask existing users to set their Google password to match their corporate password.
Correct Answer
A. Use workload identity federation to impersonate a service account.
Question 112
Exam Question
Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?
A. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
Run gsutil –m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.
B. Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
Schedule downtime to run each Cloud Data Fusion pipeline.
Verify that the migration was successful.
Re-point the applications to the Cloud SQL for MySQL instance.
C. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in compressed format.
Run gsutil –m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.
D. Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.
Correct Answer
D. Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.
Question 113
Exam Question
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?
A. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
B. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.
C. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
D. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
Correct Answer
A. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
Question 114
Exam Question
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?
A. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
B. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
C. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
D. Use Database Migration Service to migrate your database.
Correct Answer
A. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
Question 115
Exam Question
Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?
A. Build indexes on heavily accessed tables.
B. Run the Recommender API to identify overprovisioned instances.
C. Remove inactive user accounts.
D. Use Query Insights to identify idle instances.
Correct Answer
B. Run the Recommender API to identify overprovisioned instances.
Question 116
Exam Question
You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?
A. Disable and remove the external IP address assignment.
B. Specify an authorized network with the CIDR range of the VM.
C. Disable and remove the internal IP address assignment.
D> Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
Correct Answer
A. Disable and remove the external IP address assignment.
Question 117
Exam Question
Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?
A. Use Database Migration Service.
B. Create a database on Google Cloud, and use database links to perform the migration.
C. Use the native export and import functionality of the source database.
D. Create a database on Google Cloud, and use Dataflow for database migration.
Correct Answer
A. Use Database Migration Service.
Question 118
Exam Question
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?
A. Create a streaming Datatlow job to export the table.
B. Use Cloud Scheduler and Cloud Functions to run the daily export.
C. Run the cron job on a Compute Engine instance to continue the export.
D. Set up Cloud Composer, and create a task to export the table daily.
Correct Answer
B. Use Cloud Scheduler and Cloud Functions to run the daily export.
Question 119
Exam Question
Your team is building an application that stores and analyzes streaming time series financial data. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?
A. Use Firestore.
B. Use Bigtable
C. Use BigQuery.
D. Use Cloud Spanner.
Correct Answer
B. Use Bigtable
Question 120
Exam Question
You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest data. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?
A. Create two separate databases in the instance, and perform dual writes from the Order Management application.
B. Create a read replica for the Sales Reporting application.
C. Queue up all the requested reports in PubSub, and execute the reports at night.
D. Use a Cloud SQL federated query for the Sales Reporting application.
Correct Answer
B. Create a read replica for the Sales Reporting application.