[Q41-Q62] Professional-Cloud-Database-Engineer Actual Questions – Instant Download Tests Free Updated Today!

NEW QUESTION 41
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.

NEW QUESTION 42
You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

Increase the number of processing units.

Modify the database schema, and add additional indexes.

Shard data required by the application into multiple instances.

Decrease the number of processing units.

NEW QUESTION 43
You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

Reuse the existing service account that populates this database.

Create a new service account, and grant it the Cloud Spanner Database Admin role.

Create a new service account, and grant it the Cloud Spanner Database Reader role.

Create a new service account, and grant it the spanner.databases.select permission.

NEW QUESTION 44
Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?

Use Cloud Spanner instead of Cloud SQL.

Increase the number of CPUs for your instance.

Increase the storage size for the instance.

Use many smaller Cloud SQL instances.

NEW QUESTION 45
Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?

Migrate all the databases to Cloud SQL.

Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.

Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.

Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.

NEW QUESTION 46
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?

Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.

Use Cloud SQL Auth proxy.

Connect to Cloud SQL using a connection that has SSL encryption.

Use customer-managed encryption keys with Cloud SQL.

NEW QUESTION 47
Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?

Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.

Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.

Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.

Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.

NEW QUESTION 48
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?

Export the data from the existing database, and load the data into a new Cloud SQL database.

Use Migrate for Compute Engine to complete the migration.

Use Datastream to complete the migration.

Use Database Migration Service to complete the migration.

NEW QUESTION 49
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?

Disable and remove the internal IP address assignment.

Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.

Specify an authorized network with the CIDR range of the VM.

Disable and remove the external IP address assignment.

NEW QUESTION 50
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?

Use Cloud Scheduler and Cloud Functions to run the daily export.

Create a streaming Datatlow job to export the table.

Set up Cloud Composer, and create a task to export the table daily.

Run the cron job on a Compute Engine instance to continue the export.

NEW QUESTION 51
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.

NEW QUESTION 52
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?

Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.

Use Cloud SQL Auth proxy.

Connect to Cloud SQL using a connection that has SSL encryption.

Use customer-managed encryption keys with Cloud SQL.

NEW QUESTION 53
You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

Configure the automated backups to use a regional Cloud Storage bucket as a custom location.

Use the default configuration for the automated backups location.

Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

NEW QUESTION 54
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?

Isolate the data analysts and operations user groups to use different Bigtable instances.

Check the Cloud Monitoring table/bytes_used metric from Bigtable.

Use Key Visualizer for Bigtable.

Add more nodes to the Bigtable cluster.

NEW QUESTION 55
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?

Develop a custom data replication service to send data into BigQuery.

Use Cloud SQL federated queries.

Use Database Migration Service to replicate tables into BigQuery.

Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

NEW QUESTION 56
Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?

Use Database Migration Service to migrate all databases to Cloud SQL.

Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.

Use data replication tools and CDC tools to enable migration.

Use a combination of Database Migration Service and partner tools to support the data migration strategy.

NEW QUESTION 57
You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:
configure where data is stored
control where the encryption keys are stored
govern the access to data
What should you do?

Replicate Cloud SQL databases across different zones.

Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.

Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.

Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.

NEW QUESTION 58
You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

Drop or disable all users except database administration users.

Disable all foreign key constraints on the source PostgreSQL database.

Ensure that all PostgreSQL tables have a primary key.

Shut down the database before the Data Migration Service task is started.

Ensure that pglogical is installed on the source PostgreSQL database.

NEW QUESTION 59
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

Use Cloud SQL with cross-region replicas.

Use high availability (HA) Cloud SQL with multiple zones.

Use zonal Cloud SQL without high availability (HA).

Use Cloud Spanner in a regional configuration.

NEW QUESTION 60
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?

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.

Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.

Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.

Configure the primary, standby, and read replica instances in zone A, all in the same region.

NEW QUESTION 61
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?

Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.

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.

Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.

Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.

NEW QUESTION 62
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.