CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Google
  5. PROFESSIONAL-CLOUD-DATABASE-ENGINEER

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

Page 15 of 34
PDF with 132 Questions

You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of data.
You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays.
What should you do?

  1. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
  2. Use sharded Cloud SQL instances with one or more stores per database instance.
  3. Use a Biglable cluster with autoscaling.
  4. Use Cloud Spanner with a custom autoscaling solution.

Answer(s): D

Explanation:

https://cloud.google.com/spanner/docs/autoscaling-overview
1. CloudSQL max out at 64TB, so unable to told 100TB of data. https://cloud.google.com/sql/docs/quotas#metrics_collection_limit
2. Scale is done manually on SQL Cloud



Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases.
What should you do?

  1. Use replication to roll out changes to higher environments.
  2. Use backup and restore to roll out changes to higher environments.
  3. Use Liquibase to roll out changes to higher environments.
  4. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

Answer(s): C

Explanation:

To satisfy audit reporting you would need a way to record what was changed and when. The best answer is one which uses some kind of source code control system (SCCS). That rules out A and B. Any mention of anything manual in a cloud environment should look suspicious, which leave option C. As it happens, Liquibase is an SCCS and can be integrated with Spanner.
https://cloud.google.com/spanner/docs/use-liquibase



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?

  1. Issue a gcloud sql instances patch command to increase the number of vCPUs.
  2. Update a MySQL database flag to increase the number of vCPUs.
  3. Issue a gcloud compute instances update command to increase the number of vCPUs.
  4. Back up the database, create an instance with additional vCPUs, and restore the database.

Answer(s): A

Explanation:

https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch



You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability.
What should you do?

  1. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
  2. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
  3. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
  4. Configure the primary, standby, and read replica instances in zone A, all in the same region.

Answer(s): A

Explanation:

https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview



Page 15 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