Professional-Cloud-Database-Engineer Updated Exam Dumps [2022] Practice Valid Exam Dumps Question [Q62-Q83]

Rate this post

Professional-Cloud-Database-Engineer Updated Exam Dumps [2022] Practice Valid Exam Dumps Question

Professional-Cloud-Database-Engineer Sample with Accurate & Updated Questions

NEW QUESTION 62
Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

Use an auto-incrementing value as the primary key.

Normalize the data model.

Promote low-cardinality attributes in multi-attribute primary keys.

Promote high-cardinality attributes in multi-attribute primary keys.

Use bit-reverse sequential value as the primary key.

NEW QUESTION 63
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 64
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?

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.

NEW QUESTION 65
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?

Use gcloud sql instances failover <PrimaryInstanceName>.

Use gcloud sql instances failover <ReplicaInstanceName>.

Use gcloud sql instances promote-replica <PrimaryInstanceName>.

Use gcloud sql instances promote-replica <ReplicaInstanceName>.

NEW QUESTION 66
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 67
You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?

Use Cloud Spanner to deploy the database.

Use Bigtable with clusters in multiple regions to deploy the database

Use BigQuery to deploy the database

Use Cloud SQL with a regional read replica to deploy the database.

NEW QUESTION 68
You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company’s disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?

Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.

Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.

Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.

Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.

NEW QUESTION 69
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

Use external server replication.

Use Data Migration Service.

Use Cloud SQL for MySQL external replica.

Use the mysqldump utility and binary logs.

NEW QUESTION 70
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

Use Database Migration Service to migrate your database.

Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

NEW QUESTION 71
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 72
Your organization is running a critical production database on a virtual machine (VM) on Compute Engine. The VM has an ext4-formatted persistent disk for data files. The database will soon run out of storage space. You need to implement a solution that avoids downtime. What should you do?

In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.

In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use

In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.

In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.

NEW QUESTION 73
You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.

Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.

Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.

Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.

NEW QUESTION 74
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 75
Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?

Recommend solid-state drives (SSD).

Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.

Recommend hard disk drives (HDD).

Recommend mixed storage types.

NEW QUESTION 76
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?

Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).

Migrate applications and Oracle databases to Compute Engine.

Migrate applications to Cloud SQL.

Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).

NEW QUESTION 77
You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?

Automate instance creation by writing a Dataflow job.

Automate instance creation by setting up Terraform scripts.

Create the instances using the Google Cloud Console UI.

Create clones from a template Cloud SQL instance.

NEW QUESTION 78
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 79
Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).

Edit the instance to change the storage type from HDD to SSD.

Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.

Create a read replica of the instance with SSDs, and perform a failover to the new instance

NEW QUESTION 80
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 dat a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

Use Firestore and ensure that the PersistenceEnabled option is set to true.

Use Memorystore for Memcached.

Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.

Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

NEW QUESTION 81
Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?

Cloud SQL

BigQuery

Cloud Spanner

Bigtable

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

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