Hurry! The Christmas Clock is Ticking! Get 50% Off | Limited Time Offer - Ends In 0d 00h 00m 00s Coupon code: JINGLE50

Home
Google
Professional-Cloud-Database-Engineer Exam Questions

Home ❯
Google ❯
Professional-Cloud-Database-Engineer Exam Questions

Free Professional-Cloud-Database-Engineer Exam Questions - Google Professional-Cloud-Database-Engineer Exam

Google Professional-Cloud-Database-Engineer Exam

Professional Cloud Database Engineer

Total Questions: 132

Last Updated : 06-12-2024

Get Premium Files

Google Professional-Cloud-Database-Engineer Exam - Prepare from Latest, Not Redundant Questions!

Many candidates desire to prepare their Google Professional-Cloud-Database-Engineer exam with the help of only updated and relevant study material. But during their research, they usually waste most of their valuable time with information that is either not relevant or outdated. Study4Exam has a fantastic team of subject-matter experts that make sure you always get the most up-to-date preparatory material. Whenever there is a change in the syllabus of the Professional Cloud Database Engineer exam, our team of experts updates Professional-Cloud-Database-Engineer questions and eliminates outdated questions. In this way, we save you money and time.

Google Professional-Cloud-Database-Engineer Exam Sample Questions:

Q1.

You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?

AMigrate to Compute Engine.

BMigrate to Bare Metal Solution for Oracle.

CMigrate to Google Kubernetes Engine (GKE)

DMigrate to Google Cloud VMware Engine

Q2.

Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?

AUse Cloud SQL for data storage.

BUse Cloud Spanner for data storage.

CUse Memorystore for data storage.

DUse Bigtable for data storage.

Q3.

Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?

AUse Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.

BBuild a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
Schedule downtime to run each Cloud Data Fusion pipeline.
Verify that the migration was successful.
Re-point the applications to the Cloud SQL for MySQL instance.

CPause the on-premises applications.
Use the mysqldump utility to dump the database content in compressed format.
Run gsutil --m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

DPause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
Run gsutil --m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

Q4.

You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?

AUse Cloud Scheduler and Cloud Functions to run the daily export.

BCreate a streaming Datatlow job to export the table.

CSet up Cloud Composer, and create a task to export the table daily.

DRun the cron job on a Compute Engine instance to continue the export.

Q5.

Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

AUse a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

BUse Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

CUse Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.

DUse Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

Solutions:

Question: 1 Answer: A

Question: 2 Answer: A

Question: 3 Answer: B

Question: 4 Answer: C

Question: 5 Answer: B

Disscuss Google Professional-Cloud-Database-Engineer Topics, Questions or Ask Anything Related

Submit Cancel

− ∔

Cameron 5 days ago

Study4Exam has everything you need for the preparation of your IT certification. I was searching for the syllabus for professional cloud database engineer for 3 days and Ihave got it here.

upvoted 1 times

...

− ∔

Mary 6 days ago

Can I get more questions than having just 5 questions available here?

upvoted 1 times

...

− ∔

Isaac 6 days ago

This platform is trust worthy for passing Professional cloud database engineer Exam in first attempt .

upvoted 1 times

...