March Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 2493360325

Good News !!! Professional-Cloud-Database-Engineer Google Cloud Certified - Professional Cloud Database Engineer is now Stable and With Pass Result

Professional-Cloud-Database-Engineer Practice Exam Questions and Answers

Google Cloud Certified - Professional Cloud Database Engineer

Last Update 23 hours ago
Total Questions : 132

Professional-Cloud-Database-Engineer is stable now with all latest exam questions are added 23 hours ago. Just download our Full package and start your journey with Google Cloud Certified - Professional Cloud Database Engineer certification. All these Google Professional-Cloud-Database-Engineer practice exam questions are real and verified by our Experts in the related industry fields.

Professional-Cloud-Database-Engineer PDF

Professional-Cloud-Database-Engineer PDF (Printable)
$48
$119.99

Professional-Cloud-Database-Engineer Testing Engine

Professional-Cloud-Database-Engineer PDF (Printable)
$56
$139.99

Professional-Cloud-Database-Engineer PDF + Testing Engine

Professional-Cloud-Database-Engineer PDF (Printable)
$70.8
$176.99
Question # 1

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

Options:

A.  

Identify whether the database has over 512 tables.

B.  

Identify all tables that do not have a primary key.

C.  

Identity all tables that do not have at least one foreign key.

D.  

Identify whether the source database is encrypted using pgcrypto extension.

E.  

Identify whether the source database uses customer-managed encryption keys (CMEK).

Discussion 0
Question # 2

You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

Options:

A.  

Increase the number of processing units.

B.  

Modify the database schema, and add additional indexes.

C.  

Shard data required by the application into multiple instances.

D.  

Decrease the number of processing units.

Discussion 0
Question # 3

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:

A.  

Create a read replica for the Sales Reporting application.

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 4

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

Options:

A.  

Take no backups, and turn off transaction log retention.

B.  

Take one manual backup per day, and turn off transaction log retention.

C.  

Turn on automated backup, and turn off transaction log retention.

D.  

Turn on automated backup, and turn on transaction log retention.

Discussion 0
Question # 5

Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?

Options:

A.  

Issue a gcloud sql instances patch command to increase the number of vCPUs.

B.  

Update a MySQL database flag to increase the number of vCPUs.

C.  

Issue a gcloud compute instances update command to increase the number of vCPUs.

D.  

Back up the database, create an instance with additional vCPUs, and restore the database.

Discussion 0
Question # 6

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:

A.  

Setup a static external IP address in your VPC network.

B.  

Set up bring your own IP (BYOIP) in your VP

C.  

C.  

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

D.  

Set up Cloud NAT service.

Discussion 0
Question # 7

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?

Options:

A.  

Develop a custom data replication service to send data into BigQuery.

B.  

Use Cloud SQL federated queries.

C.  

Use Database Migration Service to replicate tables into BigQuery.

D.  

Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

Discussion 0
Question # 8

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:

A.  

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.

B.  

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.

C.  

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.

D.  

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.

Discussion 0
Question # 9

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

Options:

A.  

Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).

B.  

Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SS

D.  

C.  

Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SS

D.  

D.  

Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SS

D.  

Discussion 0
Question # 10

You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?

Options:

A.  

Use the Google Cloud Console or gcloud CLI to manually create a new clone database.

B.  

Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.

C.  

Verify that the new replica is created automatically.

D.  

Start the original primary instance and resume replication.

Discussion 0
Question # 11

You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?

Options:

A.  

Disable and remove the internal IP address assignment.

B.  

Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.

C.  

Specify an authorized network with the CIDR range of the VM.

D.  

Disable and remove the external IP address assignment.

Discussion 0
Question # 12

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)

Options:

A.  

Use Database Migration Service to migrate the databases to Cloud SQL.

B.  

Use a cross-region read replica to migrate the databases to Cloud SQL.

C.  

Use replication from an external server to migrate the databases to Cloud SQL.

D.  

Use an external read replica to migrate the databases to Cloud SQL.

E.  

Use a read replica to migrate the databases to Cloud SQL.

Discussion 0
Question # 13

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?

Options:

A.  

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

B.  

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.

C.  

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

D.  

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

Discussion 0
Question # 14

Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

Options:

A.  

Isolate the data analysts and operations user groups to use different Bigtable instances.

B.  

Check the Cloud Monitoring table/bytes_used metric from Bigtable.

C.  

Use Key Visualizer for Bigtable.

D.  

Add more nodes to the Bigtable cluster.

Discussion 0
Question # 15

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?

Options:

A.  

roles/spanner.databaseAdmin for Person A

roles/spanner.databaseReader for Person B

roles/spanner.backupWriter for Application C

B.  

roles/spanner.databaseAdmin for Person A

roles/spanner.databaseReader for Person B

roles/spanner.backupAdmin for Application C

C.  

roles/spanner.databaseAdmin for Person A

roles/spanner.databaseUser for Person B

roles/spanner databaseReader for Application C

D.  

roles/spanner.databaseAdmin for Person A

roles/spanner.databaseUser for Person B

roles/spanner.backupWriter for Application C

Discussion 0
Question # 16

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:

A.  

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

B.  

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

C.  

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

D.  

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

A.  

Discussion 0
Question # 17

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 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

Options:

A.  

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.

B.  

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

C.  

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

D.  

Configure your Cloud SQL instance with high availability enabled.

Discussion 0
Question # 18

Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?

Options:

A.  

Use query parameters to speed up frequently executed queries.

B.  

Change the Cloud Spanner configuration from multi-region to single region.

C.  

Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.

D.  

Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.

Discussion 0
Get Professional-Cloud-Database-Engineer dumps and pass your exam in 24 hours!

Free Exams Sample Questions