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 4 out of 5 pages

Viewing questions 31-40 out of questions

Questions # 31:

You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?

Options:

Use Firestore.

Use Cloud SQL with an external (public) IP address.

Use an in-app embedded database.

Use Cloud Spanner.

Questions # 32:

You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

Options:

Set the automated backups to occur every other day to lower the frequency of backups.

Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).

Select a different region to store your backups.

Reduce the number of automated backups that are retained to two (2).

Questions # 33:

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

Options:

Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.

Create your database with one primary node and one read replica in the region.

Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.

Configure your Cloud SQL instance with high availability enabled.

Questions # 34:

Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

Options:

Set Terraform deletion_protection to true.

Rerun terraform apply.

Create a read replica.

Use point-in-time-recovery (PITR) to recover the database.

Questions # 35:

You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-dev VPC. You have created an AllayDB cluster with private Service Access (PSA) and no public IP address in the db-dev VPC. You want your application to securely connect to AllowDB in a cost-effective way. What should you do?

Options:

Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.

Connect by using the private IP address of the AlloyDB cluster directly from the application.

Connect by using AlloyDB Auth Proxy installed in the GKE cluster.

Install a SOCKS proxy in a VM in the db-dev VPC. Install AlloyDB Auth Proxy in your GKE cluster, and connect to the AlloyDB cluster through the SOCKS server and port.

Questions # 36:

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

Options:

Provision a Cloud SQL for MySQL instance in us-central1-a.

Create a multiple-zone instance in us-west1-b.

Create a read replica in us-east1-c.

Provision a Cloud SQL for MySQL instance in us-central1-a.

Create a multiple-zone instance in us-central1-b.

Create a read replica in us-east1-b.

Provision a Cloud SQL for MySQL instance in us-central1-a.

Create a multiple-zone instance in us-east-b.

Create a read replica in us-east1-c.

Provision a Cloud SQL for MySQL instance in us-central1-a.

Create a multiple-zone instance in us-east1-b.

Create a read replica in us-central1-b.

Questions # 37:

Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

Options:

Normalize the database to the third normal form.

Compress the data using a different compression algorithm.

Manually or automatically increase the storage capacity.

Create another schema to load older data.

Questions # 38:

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?

Options:

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

Questions # 39:

You are the DBA of your organization. You provided a cloned instance from the production Cloud SQL for PostSQL database to the developers for testing purposes. After the creation of the clone. Your developers notice missing data in one of the recently altered tables. What should you do to ensure that all data in included?

Options:

Take a back up of the production database and restore It to another Cloud SQL for PostgreSQL Instance. Provide access to the new instance to the developers.

check for missing rotes and privileges in 'he cloned Cloud SQL instance. Grant missing privileges to the developers.

Clone the current production database, and restore it to an earlier point in time IPITR) Provide access to the cloned instance to the developers.

Dump the production database to a fie. Modify the dumped file to ALTER TABLE to SET LOGGED on tables that were unlogged in production. Reload the data in the new Cloud SQL for PostgreSQL Instance.

Questions # 40:

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?