Free Professional Cloud Database Engineer Exam Professional-Cloud-Database-Engineer Exam Practice Test

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

• Place the bulk of the read and write workloads closer to the default leader region.
• Use staleness of at least 15 seconds.
• Add more read-write replicas.
• Keep the total CPU utilization under 45% in each region.

An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?

• roles/cloudsql.viewer and roles/spanner.databaseUser
• roles/cloudsql.editor and roles/spanner.admin
• roles/cloudsql.client and roles/spanner.databaseReader
• roles/cloudsql.instanceUser and roles/spanner.databaseUser

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

• Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL. Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination. Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance.
• Create migration job using Database Migration Service. Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode. Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete. Update your application connections to the new instance.
• Create migration job using Database Migration Service. Set the migration job type to One-time, and perform this migration during a maintenance window. Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database. Update your application connections to the new instance.
• Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window. Move the files to Cloud Storage, and import each database into your Cloud SQL instance. Continue to dump each database until all the databases are migrated. Update your application connections to the new instance.

Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?

• Watch Query Insights for long running queries.
• Watch the Cloud SQL instance monitor for CPU utilization metrics.
• Watch the Cloud SQL recommenders for overprovisioned instances.
• Watch Cloud Trace for application requests that are failing.

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.)

• Identify whether the database has over 512 tables.
• Identify all tables that do not have a primary key.
• Identity all tables that do not have at least one foreign key.
• Identify whether the source database is encrypted using pgcrypto extension.
• Identify whether the source database uses customer-managed encryption keys (CMEK).

You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

• If the corruption is significant, use backup and restore, and specify a recovery timestamp.
• If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
• If the corruption is significant, use import and export.
• If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
• If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.

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?

• Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
• Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
• 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.
• Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:Work with transactions and offer strong consistency.Work with structured and semi-structured (JSON) data.Scale transparently to multiple regions globally as the operation grows.You need a Google Cloud database that meets all the requirements of the application. What should you do?

• Use Cloud SQL for PostgreSQL with both cross-region read replicas.
• Use Cloud Spanner in a multi-region configuration.
• Use Firestore in Datastore mode.
• Use a Bigtable instance with clusters in multiple regions.

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

• Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
• Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
• Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
• Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.

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 data. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

• Use Firestore and ensure that the PersistenceEnabled option is set to true.
• Use Memorystore for Memcached.
• Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
• Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.