Pass Google Professional-Cloud-Database-Engineer Exam with Guarantee Updated 134 Questions [Q15-Q32]

5/5 - (2 votes)

Pass Google Professional-Cloud-Database-Engineer Exam with Guarantee Updated 134 Questions

Latest Professional-Cloud-Database-Engineer Pass Guaranteed Exam Dumps Certification Sample Questions

The Google Professional-Cloud-Database-Engineer exam consists of several sections that cover various topics such as designing and implementing a database solution using Google Cloud Platform, optimizing database performance, troubleshooting database issues, and ensuring data security and compliance. Candidates are assessed on their ability to apply cloud-native technologies that enable businesses to manage their data on Google Cloud Platform efficiently. Those who pass the exam effectively demonstrate their ability to design, develop, and manage cloud-based database solutions using Google Cloud Platform.

NEW QUESTION 15
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)

Create secondary indexes on the replica.

Create additional read replicas, and partition your analytics users to use different read replicas.

Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.

Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.

Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.

NEW QUESTION 16
You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

Create one regional Cloud SQL instance with a read replica in another region.

Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.

Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

NEW QUESTION 17
You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?

Issue a rollback, and download your server certificate.

Create a new client certificate, and download it.

Create a new server certificate, and download it.

Reset your SSL configuration, and download your server certificate.

NEW QUESTION 18
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?

Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.

Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.

Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.

Create a CSV file by running the SQL statement SELECT…INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.

NEW QUESTION 19
Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?

Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.

Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.

Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

NEW QUESTION 20
You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?

Use the default app profile with single-cluster routing.

Use the default app profile with multi-cluster routing.

Create a custom app profile with multi-cluster routing.

Create a custom app profile with single-cluster routing.

NEW QUESTION 21
Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this dat a. What should you do?

Use Identity and Access Management (IAM) for Bigtable access control.

Use VPC Service Controls to create a trusted network for the Bigtable service.

Use customer-managed encryption keys (CMEK).

Use Google Cloud Armor to add IP addresses to an allowlist.

NEW QUESTION 22
You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?

Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.

Check whether your service account has cloudsql.instances.connect permission.

Enable the Cloud SQL Admin API.

Ensure that you are using an external (public) IP address interface.

NEW QUESTION 23
Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?

roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupWriter for Application C

roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupAdmin for Application C

roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner databaseReader for Application C

roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter for Application C

NEW QUESTION 24
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)

Create secondary indexes on the replica.

Create additional read replicas, and partition your analytics users to use different read replicas.

Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.

Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.

Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.

NEW QUESTION 25
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).

NEW QUESTION 26
You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

Create a read replica in another region, and promote the read replica if a failure occurs.

Enable high availability (HA) for the database to make it regional.

NEW QUESTION 27
You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?

Set up a Shared VPC, configure multiple service projects, and create firewall rules.

Set up Serverless VPC Access.

Set up Private Service Connect.

Set up Traffic Director.

NEW QUESTION 28
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?

Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.

Use sharded Cloud SQL instances with one or more stores per database instance.

Use a Biglable cluster with autoscaling.

Use Cloud Spanner with a custom autoscaling solution.

NEW QUESTION 29
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)

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

Use a cross-region read replica to migrate the databases to Cloud SQL.

Use replication from an external server to migrate the databases to Cloud SQL.

Use an external read replica to migrate the databases to Cloud SQL.

Use a read replica to migrate the databases to Cloud SQL.

NEW QUESTION 30
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 31
Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

Migrate the databases to Cloud Spanner.

Migrate the databases to Cloud SQL, and enable a standby database.

Migrate the databases to Compute Engine using regional persistent disks.

Migrate the databases to Bare Metal Solution for Oracle.

NEW QUESTION 32
You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

Use Identity and Access Management (IAM) authentication.

Use Managed Active Directory authentication.

Use Cloud SQL federated queries.

Use PostgreSQL database’s built-in authentication.

New Professional-Cloud-Database-Engineer Test Materials & Valid Professional-Cloud-Database-Engineer Test Engine: https://www.testbraindump.com/Professional-Cloud-Database-Engineer-exam-prep.html

Pass Google Professional-Cloud-Database-Engineer Exam with Guarantee Updated 134 Questions [Q15-Q32]

[2026] Free Professional-Data-Engineer Exam Dumps to Pass Exam Easily [Q202-Q217]

[Q118-Q136] Jan-2024 Realistic Professional-Data-Engineer Accurate & Verified Answers As Experienced in the Actual Test!

Pass Guaranteed Quiz 2022 Realistic Verified Free Professional-Cloud-Network-Engineer Exam Dumps [Q17-Q40]

Leave a Reply Cancel reply

Related Posts

Leave a Reply Cancel reply