Professional-Cloud-Database-Engineer Exam Dumps - Google Cloud Certified - Professional Cloud Database Engineer

Go to page:

Question # 33

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

Export the data from the existing database, and load the data into a new Cloud SQL database.

Use Migrate for Compute Engine to complete the migration.

Use Datastream to complete the migration.

Use Database Migration Service to complete the migration.

Full Access

Question # 34

Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?

Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.

Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.

Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.

Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.

Full Access

Question # 35

You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?

Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.

Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.

Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.

Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.

Full Access

Question # 36

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).

Full Access

Question # 37

You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?

Use linear scaling to implement the Autoscaler-based architecture

Use direct scaling to implement the Autoscaler-based architecture.

Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.

Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

Full Access

Question # 38

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 data. 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.

Full Access

Question # 39

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.

Full Access

Question # 40

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).

Full Access

Go to page: