Professional Cloud Database Engineer v1.0 (Professional Cloud Database Engineer)

Page:    1 / 9   
Total 132 questions

You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?

  • A. Create a clone database from a read replica database, and restore the clone in the same region.
  • B. Create a clone database from a read replica database, and restore the clone into a different zone.
  • C. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
  • D. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.


Answer : C

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?

  • A. Create the database with Google-managed encryption keys.
  • B. Create the database with customer-managed encryption keys.
  • C. Create the database persistent disk with Google-managed encryption keys.
  • D. Create the database persistent disk with customer-managed encryption keys.


Answer : D

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

  • A. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
  • B. Edit the instance to change the storage type from HDD to SSD.
  • C. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
  • D. Create a read replica of the instance with SSDs, and perform a failover to the new instance


Answer : C

You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

  • A. Reuse the existing service account that populates this database.
  • B. Create a new service account, and grant it the Cloud Spanner Database Admin role.
  • C. Create a new service account, and grant it the Cloud Spanner Database Reader role.
  • D. Create a new service account, and grant it the spanner.databases.select permission.


Answer : B

Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?

  • A. Watch Query Insights for long running queries.
  • B. Watch the Cloud SQL instance monitor for CPU utilization metrics.
  • C. Watch the Cloud SQL recommenders for overprovisioned instances.
  • D. Watch Cloud Trace for application requests that are failing.


Answer : A

You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?

  • A. Use Bigtable with multi-region clusters.
  • B. Use Memorystore for Redis with multi-zones within a region.
  • C. Use Cloud SQL for PostgreSQL with cross-region replicas.
  • D. Use Cloud Spanner with multi-region configuration.


Answer : C

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?

  • A. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
  • B. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
  • C. Create 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.
  • D. Create 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

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

  • A. Set up all read replicas in a different region using asynchronous replication.
  • B. Set up all read replicas in the same region as the primary instance with synchronous replication.
  • C. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
  • D. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.


Answer : C

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.


Answer : B

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?

  • A. Use linear scaling to implement the Autoscaler-based architecture
  • B. Use direct scaling to implement the Autoscaler-based architecture.
  • C. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
  • 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.


Answer : C

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.


Answer : D

Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

  • A. Isolate the data analysts and operations user groups to use different Bigtable instances.
  • B. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
  • C. Use Key Visualizer for Bigtable.
  • D. Add more nodes to the Bigtable cluster.


Answer : B

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?

  • A. Use Firestore.
  • B. Use Cloud Spanner.
  • C. Use Cloud SQL.
  • D. Use Bigtable.


Answer : C

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


Answer : CE

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.


Answer : C

Page:    1 / 9   
Total 132 questions