Google Professional-Cloud-Database-Engineer Professional Cloud Database Engineer Exam Exam Practice Test Questions

• Question 1

  Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

  • Use Firestore.
  • Use Cloud Spanner.
  • Use Cloud SQL.
  • Use Bigtable.

  Show Answer Answer: C Next

• Question 2

  You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

  • Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
  • Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
  • Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
  • Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.

  Show Answer Answer: B Next

• Question 3

  You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.What should you do?

  • Use gcloud sql instances failover .
  • Use gcloud sql instances failover .
  • Use gcloud sql instances promote-replica .
  • Use gcloud sql instances promote-replica .

  Show Answer Answer: D Next

• Question 4

  You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?

  • Use Cloud SQL with read replicas for throughput.
  • Use Firestore, and rely on automatic serverless scaling.
  • Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
  • Use Bigtable, and add nodes as necessary to achieve the required throughput.

  Show Answer Answer: C Next

• Question 5

  You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:configure where data is storedcontrol where the encryption keys are storedgovern the access to dataWhat should you do?

  • Replicate Cloud SQL databases across different zones.
  • Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.
  • Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.
  • Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.

  Show Answer Answer: C Next