Google Google Certifications PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions & Answers

• Question 111:

  Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?

  A. Recommend solid-state drives (SSD).

  B. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.

  C. Recommend hard disk drives (HDD).

  D. Recommend mixed storage types.

  Correct Answer: A

  if you plan to store extensive historical data for a large number of remote-sensing devices and then use the data to generate daily reports, the cost savings for HDD storage might justify the performance tradeoff. On the other hand, if you plan to use the data to display a real-time dashboard, it probably would not make sense to use HDD storage--reads would be much more frequent in this case, and reads that are not scans are much slower with HDD storage.

• Question 112:

  You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached data. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

  A. Use Firestore and ensure that the PersistenceEnabled option is set to true.

  B. Use Memorystore for Memcached.

  C. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.

  D. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

  Correct Answer: A

  https://firebase.google.com/docs/firestore/manage-data/enable-offline

• Question 113:

  An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?

  A. roles/cloudsql.viewer and roles/spanner.databaseUser

  B. roles/cloudsql.editor and roles/spanner.admin

  C. roles/cloudsql.client and roles/spanner.databaseReader

  D. roles/cloudsql.instanceUser and roles/spanner.databaseUser

  Correct Answer: A

  To read data out of Cloud SQL for SQL Server, you need to use a service account with the roles/cloudsql.viewer role on the Cloud SQL instance. This role grants the service account permission to read data from the instance. Whereas roles/ cloudsql.instanceUser will only allow to login to cloud SQL instance. No resource will be allowed to view.

• Question 114:

  Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer data. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

  A. Apply a schema data management pattern.

  B. Apply an instance data management pattern.

  C. Apply a table data management pattern.

  D. Apply a database data management pattern.

  Correct Answer: B

  https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner#multi-tenancy-data-management-patterns https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner

• Question 115:

  Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?

  A. Enable serializable isolation in the Firebase app.

  B. Deploy a US multi-region Firestore location.

  C. Build a Firestore bundle, and deploy bundles to Cloud CDN.

  D. Create a Firestore index on the news story date.

  Correct Answer: C

  A global audience strongly suggests serving content via Google's Content Delivery Network. Changing the isolation level won't decrease cost or latency

• Question 116:

  You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?

  A. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.

  B. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.

  C. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.

  D. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.

  Correct Answer: C

  The Cloud SQL connectors are libraries that provide encryption and IAM-based authorization when connecting to a Cloud SQL instance. They can't provide a network path to a Cloud SQL instance if one is not already present. Other ways to connect to a Cloud SQL instance include using a database client or the Cloud SQL Auth proxy. https://cloud.google.com/sql/docs/postgres/connect-connectors https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory/blob/main/ docs/jdbc-postgres.md

• Question 117:

  During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

  A. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

  B. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

  C. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

  D. Shut down your existing Cloud SQL for MySQL instance, and enable HA.

  Correct Answer: C

  Creating a new instance and migrating data can be time-consuming and disruptive to your application's availability. Shutting down the existing instance is not a recommended approach, as it will cause downtime for your application.

  The recommended approach is to use the gcloud instances patch command to enable high availability on your existing Cloud SQL for MySQL instance. This command updates the instance's configuration to enable the failover replica, configure it, and enable automatic failover.

  By following this approach, you can ensure minimal downtime, and your application can continue to operate during the process.

• Question 118:

  You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

  A. Use Cloud SQL with cross-region replicas.

  B. Use high availability (HA) Cloud SQL with multiple zones.

  C. Use zonal Cloud SQL without high availability (HA).

  D. Use Cloud Spanner in a regional configuration.

  Correct Answer: D

  https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform

• Question 119:

  You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

  A. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.

  B. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.

  C. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.

  D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.

  Correct Answer: A

  https://cloud.google.com/sql/docs/mysql/quotas#table_limit

• Question 120:

  You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

  A. Place the bulk of the read and write workloads closer to the default leader region.

  B. Use staleness of at least 15 seconds.

  C. Add more read-write replicas.

  D. Keep the total CPU utilization under 45% in each region.

  Correct Answer: A

  https://cloud.google.com/spanner/docs/instance-configurations#multi-region-best-practices Best practices For optimal performance, follow these best practices: Design a schema that prevents hotspots and other performance issues. For optimal write latency, place compute resources for write-heavy workloads within or close to the default leader region. For optimal read performance outside of the default leader region, use staleness of at least 15 seconds. To avoid single-region dependency for your workloads, place critical compute resources in at least two regions. A good option is to place them next to the two different read-write regions so that any single region outage will not impact all of your application. Provision enough compute capacity to keep high priority total CPU utilization under 45% in each region.