Google Professional Cloud Database Engineer Exam Practice Test Instant Access

Question 1

Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?

ACreate the database with Google-managed encryption keys.

BCreate the database with customer-managed encryption keys.

CCreate the database persistent disk with Google-managed encryption keys.

DCreate the database persistent disk with customer-managed encryption keys.

Answer : B

https://cloud.google.com/sql/docs/postgres/configure-cmek#createcmekinstance

Question 2

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 stored

control where the encryption keys are stored

govern the access to data

What should you do?

AReplicate Cloud SQL databases across different zones.

BCreate 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.

CAllow 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.

DUse features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.

Answer : D

https://cloud.google.com/blog/products/identity-security/meet-data-residency-requirements-with-google-cloud

Question 3

Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?

AIdentify and optimize slow running queries, or set parallel replication flags.

BStop all running queries, and re-create the replicas.

CEdit the primary instance to upgrade to a larger disk, and increase vCPU count.

DEdit the primary instance to add additional memory.

Answer : A

https://cloud.google.com/sql/docs/mysql/replication/replication-lag#optimize_queries_and_schema

Question 4

Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?

AOpen a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.

BUse Cloud SQL maintenance settings to prevent any maintenance during the month of December.

CCreate MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.

DCreate a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

Answer : B

https://cloud.google.com/sql/docs/mysql/maintenance?hl=fr

Question 5

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?

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

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

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

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

Answer : A

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

Question 6

You are planning to migrate a 10TB relational database from an on-premises environment la Cloud SQL for PostgreSQL. The database contains sensitive customer

Information. You want to follow Google-recommended practices to keep data secure during the migration. What should you do?

Choose 2 answers

AEstablish a Private Se-vice Connect connection between your on-premises environment and the Cloud SQL instance

BSet up identity Access Management JIAM) roles to restrict access with Cloud SQL with an internal IP address.

CUse an external IH address for the Cloud SQL Instance, and configure firewall rules.

DConfigure Cloud SQL for automatic patching, and enable binary logging.

ELeverage Storage Transfer Service with client side encryption.

Answer : A, B

Question 7

You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

AIncrease the number of processing units.

BModify the database schema, and add additional indexes.

CShard data required by the application into multiple instances.

DDecrease the number of processing units.

Answer : A

In case of high CPU utilization like, mentioned in question, refer: https://cloud.google.com/spanner/docs/identify-latency-point#:~:text=Check%20the%20CPU%20utilization%20of%20the%20instance.%20If%20the%20CPU%20utilization%20of%20the%20instance%20is%20above%20the%20recommended%20level%2C%20you%20should%20manually%20add%20more%20nodes%2C%20or%20set%20up%20auto%20scaling. 'Check the CPU utilization of the instance. If the CPU utilization of the instance is above the recommended level, you should manually add more nodes, or set up auto scaling.' Indexes and schema are reviewed post identifying query with slow performance. Refer : https://cloud.google.com/spanner/docs/troubleshooting-performance-regressions#review-schema