🔍

PCDBE — questions

Page 4 of 9 · 170 total questions.

PCDBE Question 61

Single page →
Topic 1 · Question 61

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?

  • ACreate a clone database from a read replica database, and restore the clone in the same region.
  • BCreate a clone database from a read replica database, and restore the clone into a different zone.
  • CUse the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance. (correct answer)
  • DUse the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.

Explanation

Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover.

PCDBE Question 62

Single page →
Topic 1 · Question 62

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. (correct answer)
  • CCreate the database persistent disk with Google-managed encryption keys.
  • DCreate the database persistent disk with customer-managed encryption keys.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Create the database with customer-managed encryption keys.

PCDBE Question 63

Single page →
Topic 1 · Question 63

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?

  • AExport the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs). (correct answer)
  • BEdit the instance to change the storage type from HDD to SSD.
  • CCreate a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
  • DCreate a read replica of the instance with SSDs, and perform a failover to the new instance
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).

PCDBE Question 64

Single page →
Topic 1 · Question 64

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?

  • AReuse the existing service account that populates this database.
  • BCreate a new service account, and grant it the Cloud Spanner Database Admin role.
  • CCreate a new service account, and grant it the Cloud Spanner Database Reader role. (correct answer)
  • DCreate a new service account, and grant it the spanner.databases.select permission.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create a new service account, and grant it the Cloud Spanner Database Reader role.

Explanation

Cloud Spanner is a horizontally scalable, strongly consistent relational database with global reach. A service account provides an identity for workloads to access Google Cloud APIs securely.

PCDBE Question 65

Single page →
Topic 1 · Question 65

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?

  • AWatch Query Insights for long running queries.
  • BWatch the Cloud SQL instance monitor for CPU utilization metrics.
  • CWatch the Cloud SQL recommenders for overprovisioned instances.
  • DWatch Cloud Trace for application requests that are failing. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Watch Cloud Trace for application requests that are failing.

Explanation

Cloud Trace analyzes request latency across distributed services.

PCDBE Question 66

Single page →
Topic 1 · Question 66

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?

  • AUse Bigtable with multi-region clusters.
  • BUse Memorystore for Redis with multi-zones within a region.
  • CUse Cloud SQL for PostgreSQL with cross-region replicas. (correct answer)
  • DUse Cloud Spanner with multi-region configuration.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Cloud SQL for PostgreSQL with cross-region replicas.

Explanation

Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover.

PCDBE Question 67

Single page →
Topic 1 · Question 67

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. (correct answer)
  • 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.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

Explanation

Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. This option delivers the requirement at the lowest cost.

PCDBE Question 68

Single page →
Topic 1 · Question 68

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?

  • ASet up all read replicas in a different region using asynchronous replication.
  • BSet up all read replicas in the same region as the primary instance with synchronous replication.
  • CSet 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. (correct answer)
  • DSet 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.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option 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. By spanning multiple Availability Zones / adding redundancy, this option provides the high availability and resilience required.

PCDBE Question 69

Single page →
Topic 1 · Question 69

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?

  • AApply a schema data management pattern.
  • BApply an instance data management pattern. (correct answer)
  • CApply a table data management pattern.
  • DApply a database data management pattern.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Apply an instance data management pattern.

PCDBE Question 70

Single page →
Topic 1 · Question 70

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?

  • AUse linear scaling to implement the Autoscaler-based architecture (correct answer)
  • BUse direct scaling to implement the Autoscaler-based architecture.
  • CUpgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
  • DSet up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use linear scaling to implement the Autoscaler-based architecture This option decouples the components so they scale independently and absorb load spikes.

PCDBE Question 71

Single page →
Topic 1 · Question 71

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?

  • ACreate 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.
  • BCreate 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. (correct answer)
  • CEnable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
  • DProvide 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.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option 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

Cloud IAM grants fine-grained, least-privilege access to Google Cloud resources.

PCDBE Question 72

Single page →
Topic 1 · Question 72

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?

  • AIsolate the data analysts and operations user groups to use different Bigtable instances.
  • BCheck the Cloud Monitoring table/bytes_used metric from Bigtable.
  • CUse Key Visualizer for Bigtable. (correct answer)
  • DAdd more nodes to the Bigtable cluster.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Key Visualizer for Bigtable.

Explanation

Cloud Bigtable is a managed, low-latency NoSQL wide-column store for very high-throughput workloads.

PCDBE Question 73

Single page →
Topic 1 · Question 73

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?

  • AUse Firestore.
  • BUse Cloud Spanner. (correct answer)
  • CUse Cloud SQL.
  • DUse Bigtable.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use Cloud Spanner.

Explanation

Cloud Spanner is a horizontally scalable, strongly consistent relational database with global reach.

PCDBE Question 74

Single page →
Topic 1 · Question 74 · Select all that apply

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

  • AIdentify whether the database has over 512 tables.
  • BIdentify all tables that do not have a primary key. (correct answer)
  • CIdentity all tables that do not have at least one foreign key.
  • DIdentify whether the source database is encrypted using pgcrypto extension.
  • EIdentify whether the source database uses customer-managed encryption keys (CMEK). (correct answer)
Reveal answer & explanation
Correct answer: B, E

The correct answer is B, E. Option B: Identify all tables that do not have a primary key. Option E: Identify whether the source database uses customer-managed encryption keys (CMEK).

PCDBE Question 75

Single page →
Topic 1 · Question 75

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?

  • AEnable serializable isolation in the Firebase app.
  • BDeploy a US multi-region Firestore location.
  • CBuild a Firestore bundle, and deploy bundles to Cloud CDN. (correct answer)
  • DCreate a Firestore index on the news story date.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Build a Firestore bundle, and deploy bundles to Cloud CDN.

Explanation

Firestore is a serverless, autoscaling NoSQL document database ideal for app and user data. Cloud CDN caches content at Google edge locations to reduce latency and offload origins.

PCDBE Question 76

Single page →
Topic 1 · Question 76

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

  • AExport the data from the existing database, and load the data into a new Cloud SQL database.
  • BUse Migrate for Compute Engine to complete the migration.
  • CUse Datastream to complete the migration.
  • DUse Database Migration Service to complete the migration. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use Database Migration Service to complete the migration.

Explanation

Database Migration Service migrates databases to Cloud SQL/AlloyDB with minimal downtime.

PCDBE Question 77

Single page →
Topic 1 · Question 77

You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

  • ASet the automated backups to occur every other day to lower the frequency of backups.
  • BChange the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
  • CSelect a different region to store your backups.
  • DReduce the number of automated backups that are retained to two (2). (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Reduce the number of automated backups that are retained to two (2).

PCDBE Question 78

Single page →
Topic 1 · Question 78

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?

  • AShut down and restart each application.
  • BWrite a utility to scan database query logs.
  • CWrite a utility to scan application logs.
  • DUse query tags to add application-centric database monitoring. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use query tags to add application-centric database monitoring.

PCDBE Question 79

Single page →
Topic 1 · Question 79

You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

  • AUse Cloud Spanner in a regional configuration. (correct answer)
  • BUse Cloud Spanner in a multi-region configuration.
  • CUse Cloud SQL with cross-region replicas.
  • DUse highly available Cloud SQL with multiple zones.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use Cloud Spanner in a regional configuration.

Explanation

Cloud Spanner is a horizontally scalable, strongly consistent relational database with global reach.

PCDBE Question 80

Single page →
Topic 1 · Question 80

Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?

  • AMigrate the Oracle databases to Cloud Spanner.
  • BMigrate the Oracle databases to Compute Engine.
  • CMigrate the Oracle databases to Cloud SQL.
  • DMigrate the Oracle databases to Bare Metal Solution for Oracle. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Migrate the Oracle databases to Bare Metal Solution for Oracle.

Explanation

Bare Metal Solution runs specialized workloads on dedicated hardware next to Google Cloud.

Showing questions 61–80 of 170 · Page 4 of 9