Free Professional-Cloud-Database-Engineer Exam Questions - Easiest Way for Success

Prepare for the Google Professional-Cloud-Database-Engineer exam questions with our authentic preparation materials, including free Professional-Cloud-Database-Engineer practice exam questions and answers. TheExamsLab provides all the support you need to succeed in the Professional Cloud Database Engineer Professional-Cloud-Database-Engineer exam. This dedication to student success is why we have the most satisfied Professional-Cloud-Database-Engineer certification exam candidates worldwide.

Page: 1 / 25

Total 122 Questions | Updated On: Sep 13, 2024

Add To Cart

Question 1

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

A : Use Cloud SQL with cross-region replicas.

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

C : Use zonal Cloud SQL without high availability (HA).

D : Use Cloud Spanner in a regional configuration.

Answer: A

Question 2

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?

A : Use Cloud SQL for PostgreSQL with both cross-region read replicas.

B : Use Cloud Spanner in a multi-region configuration.

C : Use Firestore in Datastore mode.

D : Use a Bigtable instance with clusters in multiple regions.

Answer: A

Question 3

Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?

A : Create the database on a Bare Metal Solution server with the database running on flash storage.Keep a local backup copy on all flash storage.Keep backups older than one day stored in Actifio OnVault storage.

B : Create the database on a Bare Metal Solution server with the database running on flash storage.Keep a local backup copy on standard storage.Keep backups older than one day stored in Actifio OnVault storage.

C : Create the database on a Bare Metal Solution server with the database running on flash storage.Keep a local backup copy on standard storage.Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to aColdline Storage bucket.

D : Create the database on a Bare Metal Solution server with the database running on flash storage.Keep a local backup copy on all flash storage.Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to anArchive Storage bucket.

Answer: B

Question 4

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?

A : Use Cloud Spanner instead of Cloud SQL.

B : Increase the number of CPUs for your instance.

C : Increase the storage size for the instance

D : Use many smaller Cloud SQL instances.

Answer: A

Question 5

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?

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

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

C : 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.

D : 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.

Answer: C

Page: 1 / 25

Total 122 Questions | Updated On: Sep 13, 2024

Add To Cart