Skip to main content

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Real Exam Questions

Google Cloud Certified - Professional Cloud Database Engineer

132 questions available · Page 1 of 14

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

Your company's mission-critical, globally available application is supported by a Cloud Spanner database.
Experienced users of the application have read and write access to the database, but new users are assigned read-only access to the database. You need to assign the appropriate Cloud Spanner Identity and Access Management (IAM) role to new users being onboarded soon.

What roles should you set up?

  1. A

    roles/spanner.databaseReader

  2. B

    roles/spanner.databaseUser

  3. C

    roles/spanner.viewer

  4. D

    roles/spanner.backupWriter

Show answer and explanation

Correct answer: A

Explanation

https://cloud.google.com/spanner/docs/iam?hl=it

Question 2 Single choice

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database.

Which authentication mechanism should you use?

  1. A

    Use Identity and Access Management (IAM) authentication.

  2. B

    Use Managed Active Directory authentication.

  3. C

    Use Cloud SQL federated queries.

  4. D

    Use PostgreSQL database's built-in authentication.

Show answer and explanation

Correct answer: A

Explanation

https://cloud.google.com/sql/docs/postgres/authentication

Question 3 Single choice

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?

  1. A

    Replicate Cloud SQL databases across different zones.

  2. B

    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.

  3. C

    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.

  4. D

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

Show answer and explanation

Correct answer: D

Explanation

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

Question 4 Single choice

You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates.

What should you do?

  1. A

    Setup a static external IP address in your VPC network.

  2. B

    Set up bring your own IP (BYOIP) in your VPC.

  3. C

    Set up a Cloud NAT gateway on the Compute Engine VM.

  4. D

    Set up Cloud NAT service.

Show answer and explanation

Correct answer: C

Explanation

https://cloud.google.com/bare-metal/docs/bms-setup?hl=en#bms-access-internet-vm-nat
The docs specifically says "Setting up a NAT gateway on a Compute Engine VM" is the way to give BMS internet access.

Question 5 Single choice

Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime.

What should you do?

  1. A

    Use Cloud SQL for data storage.

  2. B

    Use Cloud Spanner for data storage.

  3. C

    Use Memorystore for data storage.

  4. D

    Use Bigtable for data storage.

Show answer and explanation

Correct answer: B

Explanation

google Cloud Spanner is a highly scalable, reliable, and fully managed relational database service that runs on Google's infrastructure. It's designed to handle large amounts of data and provide high availability, even in the face of failures. Spanner can be used to store and manage data for a variety of applications, including e-commerce websites. Spanner is a good choice for this scenario because it can handle high write throughput and provides 99.99% uptime. It's also a good fit for applications that need to be highly available, even in the face of failures.

Question 6 Single choice

You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency.

What should you do?

  1. A

    Use linear scaling to implement the Autoscaler-based architecture

  2. B

    Use direct scaling to implement the Autoscaler-based architecture.

  3. C

    Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.

  4. D

    Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

Show answer and explanation

Correct answer: A

Explanation

Linear scaling is best used with load patterns that change more gradually or have a few large peaks. The method calculates the minimum number of nodes or processing units required to keep utilization below the scaling threshold. The number of nodes or processing units added or removed in each scaling event is not limited to a fixed step amount.
https://cloud.google.com/spanner/docs/autoscaling-overview#linear

Question 7 Single choice

You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key.

What should you do?

  1. A

    Use Cloud Spanner with a customer-managed encryption key (CMEK).

  2. B

    Use Cloud Spanner with default encryption.

  3. C

    Use Cloud SQL with a customer-managed encryption key (CMEK).

  4. D

    Use Bigtable with default encryption.

Show answer and explanation

Correct answer: A

Explanation

Yes default encryption comes with AES-256 but the question states that you need to control where you store the encryption keys. that can be achieved by CMEK.

Question 8 Single choice

Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration.

What should you do?

  1. A

    Migrate to Cloud SQL for SQL Server.

  2. B

    Migrate to Cloud SQL for PostgreSQL.

  3. C

    Migrate to Compute Engine.

  4. D

    Migrate to Google Kubernetes Engine (GKE).

Show answer and explanation

Correct answer: C

Explanation

https://cloud.google.com/sql/docs/sqlserver/features

Question 9 Single choice

You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible.

What should you do?

  1. A

    For each application code, set up a common shared user account.

  2. B

    For each application code, set up a dedicated user account.

  3. C

    For the application server, set up a service account.

  4. D

    For the application server, set up a common shared user account.

Show answer and explanation

Correct answer: C

Explanation

https://cloud.google.com/sql/docs/mysql/sql-proxy#using-a-service-account

Question 10 Single choice

Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency.

What should you do?

  1. A

    Use query parameters to speed up frequently executed queries.

  2. B

    Change the Cloud Spanner configuration from multi-region to single region.

  3. C

    Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.

  4. D

    Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.

Show answer and explanation

Correct answer: C

Explanation

To troubleshoot high read latency, you can use SQL statements to analyze the SPANNER_SYS.READ_STATS* tables. These tables contain statistics about read operations in Cloud Spanner, including the number of reads, read latency, and the number of read errors. By analyzing these tables, you can identify the cause of the high read latency and take appropriate action to resolve the issue.
Other options, such as using query parameters to speed up frequently executed queries or changing the Cloud Spanner configuration from multi-region to single region, may not be directly related to the issue of high read latency. Similarly, analyzing the SPANNER_SYS.QUERY_STATS* tables, which contain statistics about query operations, may not be relevant to the issue of high read latency.