🔍

PCDBE — questions

Page 2 of 9 · 170 total questions.

PCDBE Question 21

Single page →
Topic 1 · Question 21

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?

  • AUse Firestore with Looker.
  • BUse Cloud Spanner with Data Studio.
  • CUse MongoD8 Atlas with Charts.
  • DUse Bigtable with Looker. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use Bigtable with Looker.

Explanation

Cloud Bigtable is a managed, low-latency NoSQL wide-column store for very high-throughput workloads. Looker provides governed business intelligence, dashboards, and data modeling. This option meets the real-time / low-latency performance requirement.

PCDBE Question 22

Single page →
Topic 1 · Question 22

Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?

  • AUse Cloud Spanner instead of Cloud SQL.
  • BIncrease the number of CPUs for your instance.
  • CIncrease the storage size for the instance.
  • DUse many smaller Cloud SQL instances. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use many smaller Cloud SQL instances.

Explanation

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

PCDBE Question 23

Single page →
Topic 1 · Question 23

You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?

  • ACreate and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
  • BCreate two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
  • CCreate a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance. (correct answer)
  • DCreate a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.

Explanation

Cloud Storage provides durable, scalable object storage that is fully managed.

PCDBE Question 24

Single page →
Topic 1 · Question 24

You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?

  • AUse Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
  • BUse PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances. (correct answer)
  • CUse HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
  • DUse the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.

Explanation

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

PCDBE Question 25

Single page →
Topic 1 · Question 25

Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?

  • AOpen the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
  • BReload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.
  • CPerform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted. (correct answer)
  • DFail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.

Explanation

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

PCDBE Question 26

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

You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

  • ADrop or disable all users except database administration users.
  • BDisable all foreign key constraints on the source PostgreSQL database.
  • CEnsure that all PostgreSQL tables have a primary key. (correct answer)
  • DShut down the database before the Data Migration Service task is started.
  • EEnsure that pglogical is installed on the source PostgreSQL database. (correct answer)
Reveal answer & explanation
Correct answer: C, E

The correct answer is C, E. Option C: Ensure that all PostgreSQL tables have a primary key. Option E: Ensure that pglogical is installed on the source PostgreSQL database.

PCDBE Question 27

Single page →
Topic 1 · Question 27

You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

  • AUse external server replication. (correct answer)
  • BUse Data Migration Service.
  • CUse Cloud SQL for MySQL external replica.
  • DUse the mysqldump utility and binary logs.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use external server replication.

PCDBE Question 28

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

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

  • AUse Database Migration Service to migrate the databases to Cloud SQL. (correct answer)
  • BUse a cross-region read replica to migrate the databases to Cloud SQL.
  • CUse replication from an external server to migrate the databases to Cloud SQL. (correct answer)
  • DUse an external read replica to migrate the databases to Cloud SQL.
  • EUse a read replica to migrate the databases to Cloud SQL.
Reveal answer & explanation
Correct answer: A, C

The correct answer is A, C. Option A: Use Database Migration Service to migrate the databases to Cloud SQL. Option C: Use replication from an external server to migrate the databases to Cloud SQL.

Explanation

Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. Database Migration Service migrates databases to Cloud SQL/AlloyDB with minimal downtime.

PCDBE Question 29

Single page →
Topic 1 · Question 29

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

  • A1. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL.2. Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination.3. Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance.
  • B1. Create migration job using Database Migration Service.2. Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode.3. Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete.4. Update your application connections to the new instance. (correct answer)
  • C1. Create migration job using Database Migration Service.2. Set the migration job type to One-time, and perform this migration during a maintenance window.3. Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database.4. Update your application connections to the new instance.
  • D1. Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window.2. Move the files to Cloud Storage, and import each database into your Cloud SQL instance.3. Continue to dump each database until all the databases are migrated.4. Update your application connections to the new instance.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: 1. Create migration job using Database Migration Service.2. Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode.3....

Explanation

Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. Database Migration Service migrates databases to Cloud SQL/AlloyDB with minimal downtime.

PCDBE Question 30

Single page →
Topic 1 · Question 30

Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

  • ANormalize the database to the third normal form.
  • BCompress the data using a different compression algorithm.
  • CManually or automatically increase the storage capacity. (correct answer)
  • DCreate another schema to load older data.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Manually or automatically increase the storage capacity.

PCDBE Question 31

Single page →
Topic 1 · Question 31

You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?

  • ACheck the cloudsql.googleapis.com/postgres.log instance log.
  • BPerform the gcloud sql operations list command. (correct answer)
  • CUse Cloud Audit Logs to verify the status.
  • DUse the Google Cloud Console.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Perform the gcloud sql operations list command.

Explanation

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

PCDBE Question 32

Single page →
Topic 1 · Question 32

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. (correct answer)
  • BModify the database schema, and add additional indexes.
  • CShard data required by the application into multiple instances.
  • DDecrease the number of processing units.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Increase the number of processing units.

PCDBE Question 33

Single page →
Topic 1 · Question 33

Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?

  • ARecommend solid-state drives (SSD). (correct answer)
  • BRecommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
  • CRecommend hard disk drives (HDD).
  • DRecommend mixed storage types.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Recommend solid-state drives (SSD). This option meets the real-time / low-latency performance requirement.

PCDBE Question 34

Single page →
Topic 1 · Question 34

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

  • A1. Provision a Cloud SQL for MySQL instance in us-central1-a.2. Create a multiple-zone instance in us-west1-b.3. Create a read replica in us-east1-c.
  • B1. Provision a Cloud SQL for MySQL instance in us-central1-a.2. Create a multiple-zone instance in us-central1-b.3. Create a read replica in us-east1-b. (correct answer)
  • C1. Provision a Cloud SQL for MySQL instance in us-central1-a.2. Create a multiple-zone instance in us-east-b.3. Create a read replica in us-east1-c.
  • D1. Provision a Cloud SQL for MySQL instance in us-central1-a.2. Create a multiple-zone instance in us-east1-b.3. Create a read replica in us-central1-b.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: 1. Provision a Cloud SQL for MySQL instance in us-central1-a.2. Create a multiple-zone instance in us-central1-b.3. Create a read replica in us-east1-b.

Explanation

Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. By spanning multiple Availability Zones / adding redundancy, this option provides the high availability and resilience required.

PCDBE Question 35

Single page →
Topic 1 · Question 35

You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?

  • AUse Firestore. (correct answer)
  • BUse Cloud SQL with an external (public) IP address.
  • CUse an in-app embedded database.
  • DUse Cloud Spanner.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use Firestore.

Explanation

Firestore is a serverless, autoscaling NoSQL document database ideal for app and user data.

PCDBE Question 36

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

You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

  • AIf the corruption is significant, use backup and restore, and specify a recovery timestamp. (correct answer)
  • BIf the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
  • CIf the corruption is significant, use import and export.
  • DIf the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
  • EIf the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back. (correct answer)
Reveal answer & explanation
Correct answer: A, E

The correct answer is A, E. Option A: If the corruption is significant, use backup and restore, and specify a recovery timestamp. Option E: If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.

PCDBE Question 37

Single page →
Topic 1 · Question 37

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?

  • AClose idle connections or restart the instance before beginning the import operation. (correct answer)
  • BIncrease the amount of memory allocated to your instance.
  • CEnsure that the service account has the Storage Admin role.
  • DIncrease the number of CPUs for the instance to ensure that it can handle the additional import operation.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Close idle connections or restart the instance before beginning the import operation.

PCDBE Question 38

Single page →
Topic 1 · Question 38

You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?

  • ASet up a Shared VPC, configure multiple service projects, and create firewall rules. (correct answer)
  • BSet up Serverless VPC Access.
  • CSet up Private Service Connect.
  • DSet up Traffic Director.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Set up a Shared VPC, configure multiple service projects, and create firewall rules.

Explanation

Shared VPC centralizes network administration by sharing one VPC across multiple projects. A VPC provides a global, software-defined private network for your Google Cloud resources.

PCDBE Question 39

Single page →
Topic 1 · Question 39

You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?

  • AUse Cloud Functions to run the export in Avro format.
  • BUse Cloud Functions to run the export in text format.
  • CUse Dataflow to run the export in Avro format. (correct answer)
  • DUse Dataflow to run the export in text format.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Dataflow to run the export in Avro format.

Explanation

Dataflow runs serverless Apache Beam pipelines for stream and batch data processing with autoscaling.

PCDBE Question 40

Single page →
Topic 1 · Question 40

You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

  • AConfigure Firestore, and modify your application to offload queries.
  • BConfigure Bigtable, and modify your application to offload queries.
  • CConfigure Cloud SQL for PostgreSQL read replicas to offload queries.
  • DConfigure Memorystore, and modify your application to offload queries. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Configure Memorystore, and modify your application to offload queries.

Explanation

Memorystore provides managed in-memory Redis/Memcached caching to reduce latency and offload databases.

Showing questions 21–40 of 170 · Page 2 of 9