2.4 Optimize Database Cost and Performance in Google Cloud PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   A database team wants to ensure that a Cloud SQL instance remains available if the primary zone fails. Which replication strategy should be used?

   • AA single-zone instance with automated backups.
   • BA regional instance with automatic failover to a standby in another zone.
   • CA cross-region read replica.
   • DA read replica in the same zone as the primary.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A media streaming company uses Cloud Spanner for its global user metadata. The application is read-heavy, with users accessing their profiles from different regions. The team wants to minimize latency for users in Europe and Asia while keeping costs predictable. What should they do?

   • AUse a single-region Spanner instance in the US and rely on a CDN for profile data.
   • BConfigure a multi-region Spanner instance with regional replicas in Europe and Asia.
   • CDeploy a single-region Spanner instance and use a global load balancer.
   • DCreate read replicas in Europe and Asia using Cloud SQL for PostgreSQL.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A company uses BigQuery for its ad-hoc analytics. A data analyst frequently runs queries that filter on a `customer_id` column in a large table. The table is not partitioned or clustered. The team wants to reduce query costs. What should they do?

   • AUse the `SELECT *` statement to retrieve all columns.
   • BCluster the table on `customer_id`.
   • CPartition the table by `customer_id`.
   • DCreate a view that filters on `customer_id`.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   A database team wants to review the monthly spend on their Cloud SQL instances and identify cost trends. Which Google Cloud tool provides billing cost details and forecasting?

   • ACloud Profiler
   • BCloud Trace
   • CCloud Armor
   • DCloud Billing reports
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   A database administrator is evaluating how to handle an expected increase in read traffic for a Cloud SQL for PostgreSQL instance. Which approach is an example of scaling out?

   • AAdding read replicas and routing read-only traffic to them.
   • BEnabling automatic storage increases to accommodate more data.
   • CIncreasing the machine type of the primary instance to a larger vCPU and memory configuration.
   • DSwitching to a regional instance for higher availability.
   Reveal Solution Discussion Select an answer first