Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Google Cloud Database Engineer Professional-Cloud-Database-Engineer Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam Professional-Cloud-Database-Engineer Premium Access

View all detail and faqs for the Professional-Cloud-Database-Engineer exam

Go to Exam

725 Students Passed

90% Average Score

91% Same Questions

Viewing page 2 out of 5 pages

Viewing questions 11-20 out of questions

Questions # 11:

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

Options:

Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

Shut down your existing Cloud SQL for MySQL instance, and enable HA.

Questions # 12:

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

Options:

Set up all read replicas in a different region using asynchronous replication.

Set up all read replicas in the same region as the primary instance with synchronous replication.

Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

Questions # 13:

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?

Options:

Enable serializable isolation in the Firebase app.

Deploy a US multi-region Firestore location.

Build a Firestore bundle, and deploy bundles to Cloud CDN.

Create a Firestore index on the news story date.

Questions # 14:

Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?

Options:

Use Logs Explorer to analyze log data.

Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

Use Error Reporting to count, analyze, and aggregate the data.

Use Cloud Debugger to inspect the state of an application.

Questions # 15:

You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?

Options:

Setup a static external IP address in your VPC network.

Set up bring your own IP (BYOIP) in your VPC.

Set up a Cloud NAT gateway on the Compute Engine VM.

Set up Cloud NAT service.

Questions # 16:

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?

Options:

Create a read replica for the Sales Reporting application.

Create two separate databases in the instance, and perform dual writes from the Order Management application.

Use a Cloud SQL federated query for the Sales Reporting application.

Queue up all the requested reports in PubSub, and execute the reports at night.

Questions # 17:

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?

Options:

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.

Questions # 18:

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?

Options:

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.

Questions # 19:

You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?

Options:

Deploy the database using Cloud SQL.

Use BigQuery, and load data in batches.

Deploy the database using Bigtable.

Deploy the database using Cloud Spanner.

Questions # 20:

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?