Free PROFESSIONAL-CLOUD-DATABASE-ENGINEER Exam Braindumps (page: 2)

Page 2 of 34

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy.
What should you do?

  1. Use Database Migration Service to migrate all databases to Cloud SQL.
  2. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
  3. Use data replication tools and CDC tools to enable migration.
  4. Use a combination of Database Migration Service and partner tools to support the data migration strategy.

Answer(s): A

Explanation:

https://cloud.google.com/blog/products/databases/tips-for-migrating-across-compatible-database- engines



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?

  1. Setup a static external IP address in your VPC network.
  2. Set up bring your own IP (BYOIP) in your VPC.
  3. Set up a Cloud NAT gateway on the Compute Engine VM.
  4. Set up Cloud NAT service.

Answer(s): C

Explanation:

https://cloud.google.com/bare-metal/docs/bms-setup?hl=en#bms-access-internet-vm-nat The docs specifically says "Setting up a NAT gateway on a Compute Engine VM" is the way to give BMS internet access.



Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation.
What should you do?

  1. Use Logs Explorer to analyze log data.
  2. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
  3. Use Error Reporting to count, analyze, and aggregate the data.
  4. Use Cloud Debugger to inspect the state of an application.

Answer(s): B

Explanation:

https://cloud.google.com/sql/docs/mysql/diagnose-
issues#:~:text=If%20your%20instance%20stops%20responding%20to%20connections%20or%20performance%20is%20degraded%2C%20make%20sure%20it%20conforms%20to%20the%20Operational %20Guidelines



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?

  1. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
  2. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
  3. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
  4. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.

Answer(s): B



Page 2 of 34



Post your Comments and Discuss Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam with other Community members:

muksgreen commented on March 01, 2024
brainstorming excellent
JAPAN
upvote