Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER Online Practice Questions and Exam Preparation

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

• Question 81:

  You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?

  A. Shut down and restart each application.
  B. Write a utility to scan database query logs.
  C. Write a utility to scan application logs.
  D. Use query tags to add application-centric database monitoring.
  D. Use query tags to add application-centric database monitoring.

  ---

  Explanation/Reference:

  https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags

• Question 82:

  Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?

  A. Use Firestore with Looker.
  B. Use Cloud Spanner with Data Studio.
  C. Use MongoD8 Atlas with Charts.
  D. Use Bigtable with Looker.
  C. Use MongoD8 Atlas with Charts.

  ---

  Explanation/Reference:

  This scenario has BigTable written all over it -large amounts of data from many devices to be analysed in realtime. I would even argue it could qualify as a multicloud solution, given the links to HBASE. BUT it does not support SQL queries and is not therefore compatible (on its own) with Looker. Firestore + Looker has the same problem. Spanner + Data Studio is at least a compatible pairing, but I agree with others that it doesn't fit this use-case -not least because it's Google-native. By contrast, MongoDB Atlas is a managed solution (just not by Google) which is compatible with the proposed reporting tool (Mongo's own Charts), it's specifically designed for this type of solution and of course it can run on any cloud.

• Question 83:

  You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)

  A. Identify whether the database has over 512 tables.
  B. Identify all tables that do not have a primary key.
  C. Identity all tables that do not have at least one foreign key.
  D. Identify whether the source database is encrypted using pgcrypto extension.
  E. Identify whether the source database uses customer-managed encryption keys (CMEK).
  C. Identity all tables that do not have at least one foreign key.
  E. Identify whether the source database uses customer-managed encryption keys (CMEK).

• Question 84:

  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.
  D. Use Cloud Spanner in a regional configuration.

  ---

  Explanation/Reference:

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

• Question 85:

  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?

  A. Replicate Cloud SQL databases across different zones.
  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.
  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.
  D. Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
  D. Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.

  ---

  Explanation/Reference:

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

• Question 86:

  Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?

  A. Migrate all the databases to Cloud SQL.
  B. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
  C. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
  D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
  D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.

• Question 87:

  Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:

  Person A is a database administrator.

  Person B is an analyst who generates metric reports.

  Application C is responsible for automatic backups.

  You need to assign roles to team members for Cloud Spanner. Which roles should you assign?

  A. roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupWriter for Application C
  B. roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupAdmin for Application C
  C. roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner databaseReader for Application C
  D. roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner.backupWriter for Application C
  A. roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupWriter for Application C

  ---

  Explanation/Reference:

  https://cloud.google.com/spanner/docs/iam#spanner.backupWriter

• Question 88:

  Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

  A. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
  B. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
  C. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
  D. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
  B. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.

  ---

  Explanation/Reference:

  "Read replicas do not have the cloudsql.iam_authentication flag enabled automatically when it is enabled on the primary instance." https://cloud.google.com/sql/docs/postgres/replication/create-replica#configure_iam_replicas

• Question 89:

  Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

  A. Use an auto-incrementing value as the primary key.
  B. Normalize the data model.
  C. Promote low-cardinality attributes in multi-attribute primary keys.
  D. Promote high-cardinality attributes in multi-attribute primary keys.
  E. Use bit-reverse sequential value as the primary key.
  D. Promote high-cardinality attributes in multi-attribute primary keys.
  E. Use bit-reverse sequential value as the primary key.

  ---

  Explanation/Reference:

  https://cloud.google.com/spanner/docs/schema-design D because high cardinality means you have more unique values in the collumn. That's a good thing for a hot-spotting issue. E because Spanner specifically has this feature to reduce hot spotting. Basically, it generates unique values https://cloud.google.com/spanner/docs/schema-design#bit_reverse_primary_key

  D. Promote high-cardinality attributes in multi-attribute primary keys. This is a correct answer because promoting high-cardinality attributes in multi-attribute primary keys can help avoid hotspots in Cloud Spanner. High-cardinality attributes are those that have many distinct values, such as UUIDs, email addresses, or timestamps1. By placing high-cardinality attributes first in the primary key, you can ensure that the rows are distributed more evenly across the key space, and avoid having too many requests sent to the same server2.

  E. Use bit-reverse sequential value as the primary key. This is a correct answer because using bit-reverse sequential value as the primary key can help avoid hotspots in Cloud Spanner. Bit-reverse sequential value is a technique that reverses the bits of a monotonically increasing value, such as a timestamp or an auto-incrementing ID1. By reversing the bits, you can create a pseudo-random value that spreads the writes across the key space, and avoid having all the inserts occurring at the end of the table2.

• Question 90:

  Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over.

  What should you do? (Choose two.)

  A. Use an external read replica to migrate the databases to Cloud SQL.
  B. Use a read replica to migrate the databases to Cloud SQL.
  C. Use Database Migration Service to migrate the databases to Cloud SQL.
  D. Use a cross-region read replica to migrate the databases to Cloud SQL.
  E. Use replication from an external server to migrate the databases to Cloud SQL.
  C. Use Database Migration Service to migrate the databases to Cloud SQL.
  E. Use replication from an external server to migrate the databases to Cloud SQL.

  ---

  Explanation/Reference: