🔍

PCDBE — questions

Page 7 of 9 · 170 total questions.

PCDBE Question 121

Single page →
Topic 1 · Question 121

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?

  • ARestore the Cloud SQL instance from the automatic backups in region 3.
  • BRestore the Cloud SQL instance from the automatic backups in another zone in region 1.
  • CCheck "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance. (correct answer)
  • DCheck your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting th...

PCDBE Question 122

Single page →
Topic 1 · Question 122

You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?

  • AIssue a rollback, and download your server certificate.
  • BCreate a new client certificate, and download it.
  • CCreate a new server certificate, and download it. (correct answer)
  • DReset your SSL configuration, and download your server certificate.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create a new server certificate, and download it.

PCDBE Question 123

Single page →
Topic 1 · Question 123

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

  • AMigrate the databases to Cloud Spanner.
  • BMigrate the databases to Cloud SQL, and enable a standby database.
  • CMigrate the databases to Compute Engine using regional persistent disks.
  • DMigrate the databases to Bare Metal Solution for Oracle. (correct answer)
Reveal answer & explanation
Correct answer: D

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

Explanation

Bare Metal Solution runs specialized workloads on dedicated hardware next to Google Cloud. By spanning multiple Availability Zones / adding redundancy, this option provides the high availability and resilience required.

PCDBE Question 124

Single page →
Topic 1 · Question 124

Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?

  • ASelect Bare Metal Solution for Oracle.
  • BSelect Cloud SQL.
  • CSelect Bigtable.
  • DSelect Cloud Spanner. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Select Cloud Spanner.

Explanation

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

PCDBE Question 125

Single page →
Topic 1 · Question 125

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?

  • AUse Identity and Access Management (IAM) authentication. (correct answer)
  • BUse Managed Active Directory authentication.
  • CUse Cloud SQL federated queries.
  • DUse PostgreSQL database's built-in authentication.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use Identity and Access Management (IAM) authentication.

Explanation

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

PCDBE Question 126

Single page →
Topic 1 · Question 126

You are migrating your 2 TB on-premises PostgreSQL cluster to Compute Engine. You want to set up your new environment in an Ubuntu virtual machine instance in Google Cloud and seed the data to a new instance. You need to plan your database migration to ensure minimum downtime. What should you do?

  • A1. Take a full export while the database is offline.2. Create a bucket in Cloud Storage.3. Transfer the dump file to the bucket you just created.4. Import the dump file into the Google Cloud primary server.B.1. Take a full export while the database is offline.2. Create a bucket in Cloud Storage.3. Transfer the dump file to the bucket you just created.4. Restore the backup into the Google Cloud primary server.
  • C1. Take a full backup while the database is online.2. Create a bucket in Cloud Storage.3. Transfer the backup to the bucket you just created.4. Restore the backup into the Google Cloud primary server.5. Create a recovery.conf file in the $PG_DATA directory.6. Stop the source database.7. Transfer the write ahead logs to the bucket you created before.8. Start the PostgreSQL service.9. Wait until Google Cloud primary server syncs with the running primary server. (correct answer)
  • D1. Take a full export while the database is online.2. Create a bucket in Cloud Storage.3. Transfer the dump file and write-ahead logs to the bucket you just created.4. Restore the dump file into the Google Cloud primary server.5. Create a recovery.conf file in the $PG_DATA directory.6. Stop the source database.7. Transfer the write-ahead logs to the bucket you created before.8. Start the PostgreSQL service.9. Wait until the Google Cloud primary server syncs with the running primary server.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: 1. Take a full backup while the database is online.2. Create a bucket in Cloud Storage.3. Transfer the backup to the bucket you just created.4. Restore the backup into the Google Cloud primary server.5. Create a recov...

Explanation

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

PCDBE Question 127

Single page →
Topic 1 · Question 127

You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?

  • AUse Cloud SQL instance monitoring.
  • BUse the Cloud Monitoring dashboard with available metrics from Cloud SQL. (correct answer)
  • CUse Cloud SQL logs.
  • DUse the SQL Server Always On Availability Group dashboard.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.

Explanation

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

PCDBE Question 128

Single page →
Topic 1 · Question 128

You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

  • ATake nightly snapshots of the primary database instance, and restore them in a secondary zone.
  • BBuild a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
  • CCreate a read replica in another region, and promote the read replica if a failure occurs.
  • DEnable high availability (HA) for the database to make it regional. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Enable high availability (HA) for the database to make it regional.

PCDBE Question 129

Single page →
Topic 1 · Question 129

You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project. What should you do to configure the networks?

  • ACreate a new VPC network in each project, and use VPC Network Peering to connect the two together.
  • BCreate a Shared VPC that both the application VMs and Cloud SQL instances will use. (correct answer)
  • CUse the default networks, and leverage Cloud VPN to connect the two together.
  • DPlace both the application VMs and the Cloud SQL instances in the default network of each project.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Create a Shared VPC that both the application VMs and Cloud SQL instances will use.

Explanation

Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. 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 130

Single page →
Topic 1 · Question 130

Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

  • ASet Terraform deletion_protection to true. (correct answer)
  • BRerun terraform apply.
  • CCreate a read replica.
  • DUse point-in-time-recovery (PITR) to recover the database.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Set Terraform deletion_protection to true.

Explanation

Terraform provisions Google Cloud infrastructure as code repeatably.

PCDBE Question 131

Single page →
Topic 1 · Question 131

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?

  • Aroles/spanner.databaseReader (correct answer)
  • Broles/spanner.databaseUser
  • Croles/spanner.viewer
  • Droles/spanner.backupWriter
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: roles/spanner.databaseReader

Explanation

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

PCDBE Question 132

Single page →
Topic 1 · Question 132

You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises. You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

  • AUse Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.
  • BUse Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database. (correct answer)
  • CUse Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.
  • DCreate extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.

Explanation

BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. Cloud Data Fusion builds ETL/ELT pipelines visually with little code. This option meets the real-time / low-latency performance requirement.

PCDBE Question 133

Single page →
Topic 1 · Question 133

You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?

  • ADeploy the database using Cloud SQL.
  • BUse BigQuery, and load data in batches.
  • CDeploy the database using Bigtable. (correct answer)
  • DDeploy the database using Cloud Spanner.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Deploy the database using Bigtable.

Explanation

Cloud Bigtable is a managed, low-latency NoSQL wide-column store for very high-throughput workloads. This option meets the real-time / low-latency performance requirement.

PCDBE Question 134

Single page →
Topic 1 · Question 134

Your company is launching a gaming application that uses a Firestore database. You need to identify an easy-to-manage and cost-effective solution to automate the scheduling of Firestore data exports. What should you do?

  • ACreate a new Compute Engine, and set up a cron Job to run the gcloud firestore export command.
  • BUse Dataflow to create a custom pipeline to extract data from Firestore, transform it into the desired format, and load it into a Cloud Storage bucket at regular intervals.
  • CUse Cloud Scheduler to trigger a Cloud Function that executes the Firestore export process. (correct answer)
  • DUse the Firebase Admin SDK to programmatically schedule and manage exports.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Cloud Scheduler to trigger a Cloud Function that executes the Firestore export process.

Explanation

Firestore is a serverless, autoscaling NoSQL document database ideal for app and user data. This option delivers the requirement at the lowest cost.

PCDBE Question 135

Single page →
Topic 1 · Question 135

Your company is launching a new globally distributed application with strict requirements for low latency, strong consistency, zero downtime, and high availability (HA). You need to configure a scalable database solution to support anticipated rapid growth and optimal application performance. What should you do?

  • ACreate a Spanner instance across regions for optimal performance. (correct answer)
  • BImplement Bigtable with replication across multiple regions and configure to prioritize data accuracy.
  • CCreate a Cloud SQL instance in HA mode with a cross-region read replica.
  • DCreate an AlloyDB instance in HA mode with a cross-region read replica.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Create a Spanner instance across regions for optimal performance.

Explanation

Cloud Spanner is a horizontally scalable, strongly consistent relational database with global reach. This option meets the real-time / low-latency performance requirement.

PCDBE Question 136

Single page →
Topic 1 · Question 136

Your rapidly growing ecommerce company is migrating their analytics workloads to AlloyDB for PostgreSQL. You anticipate a significant increase in reporting queries as the business scales. You need a read pool strategy to scale your analytics operations in anticipation of future growth while minimizing costs. What should you do?

  • ADirect all complex, long-running analytics queries to the primary instance, and only use read pools for short, frequent reports.
  • BChange the instance sizes of the read nodes in the read pool.
  • CBegin with minimal read pools and iteratively expand or shrink them based on real-time load monitoring to optimize resource allocation. (correct answer)
  • DAssign all reporting queries to a single, large read pool to maximize the combined compute resources available for analytics.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Begin with minimal read pools and iteratively expand or shrink them based on real-time load monitoring to optimize resource allocation.

PCDBE Question 137

Single page →
Topic 1 · Question 137

You are deploying a Cloud SQL for MySQL database to serve a non-critical application. The database size is 10 GB and will be updated every night with data stored in a Cloud Storage bucket. The database serves read-only traffic from the application during the day. The data locality requirement of this application mandates that data must reside in a single region. You want to minimize the cost of running this database while maintaining an RTO of 1 day. What should you do?

  • ACreate a Cloud SQL for MySQL instance with high availability (HA) enabled. Configure automated backups of the Cloud SQL instance, and use the default backup location.
  • BCreate a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in the same zone.
  • CCreate a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in a second region.
  • DCreate a Cloud SQL for MySQL instance with high availability (HA) disabled. Configure automated backups of the Cloud SQL instance, and use a custom backup location to store backups in a Cloud Storage bucket in the same region. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Configure automated backups of the Cloud SQL instance, and use a custom backup location to store backups in a Cloud Storage bucket in the sam...

Explanation

Cloud Storage provides durable, scalable object storage that is fully managed. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover.

PCDBE Question 138

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

You are planning to migrate a 10 TB relational database from an on-premises environment to Cloud SQL for PostgreSQL. The database contains sensitive customer information. You want to follow Google-recommended practices to keep data secure during the migration. What should you do? (Choose two.)

  • AConfigure Cloud SQL for automatic patching, and enable binary logging.
  • BEstablish a Private Service Connect connection between your on-premises environment and the Cloud SQL instance. (correct answer)
  • CUse an external IP address for the Cloud SQL instance, and configure firewall rules.
  • DSet up Identity and Access Management (IAM) roles to restrict access with Cloud SQL with an internal IP address. (correct answer)
  • ELeverage Storage Transfer Service with client-side encryption.
Reveal answer & explanation
Correct answer: B, D

The correct answer is B, D. Option B: Establish a Private Service Connect connection between your on-premises environment and the Cloud SQL instance. Option D: Set up Identity and Access Management (IAM) roles to restrict access with Cloud SQL with an internal IP address.

Explanation

Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. Private Service Connect exposes and consumes services privately within VPCs without internet exposure. Cloud IAM grants fine-grained, least-privilege access to Google Cloud resources.

PCDBE Question 139

Single page →
Topic 1 · Question 139

You are running a Cloud SQL for PostgreSQL 13 Enterprise Edition instance. During an audit, you discovered that the write-ahead logs used for point-in-time recovery (PITR) are stored on disk. You need to store PITR logs in a Cloud Storage bucket going forward. How should you do this without compromising recoverability or losing the current PITR logs?

  • AClone the instance. Create a new instance with PITR retention set to 30 days.
  • BChange the transaction logs (WAL) retention period.
  • CUpgrade to Enterprise Plus Edition. (correct answer)
  • DDisable PITR, then enable PITR.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Upgrade to Enterprise Plus Edition.

PCDBE Question 140

Single page →
Topic 1 · Question 140

You are the DBA working at a large bank in Europe. Your business-critical banking application runs on Oracle 12.2 in your on-premises data center. You decided to modernize your on-premises Oracle database by migrating to AlloyDB. You must meet the following requirements: • Remain on-premises and maintain open-source portability. • Meet regulatory requirements for data residency. • Support both OLTP and OLAP workloads. • Maintain high availability (HA) mode and automatic failover. What should you do?

  • ADeploy AlloyDB Omni in a standalone VM on-premises, and set up disaster recovery (DR) in AlloyDB for PostgreSQL.
  • BMigrate to AlloyDB for PostgreSQL by using Database Migration Service.
  • CDeploy Kubernetes-based AlloyDB Omni database cluster on-premises. Enable HA by using the AlloyDB Omni Kubernetes operator, and migrate your Oracle database to Omni. (correct answer)
  • DDeploy AlloyDB Omni as a docker-based container in your on-premises VM, enable HA for it, and migrate your Oracle database to the Omni container.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Deploy Kubernetes-based AlloyDB Omni database cluster on-premises. Enable HA by using the AlloyDB Omni Kubernetes operator, and migrate your Oracle database to Omni.

Explanation

AlloyDB is a managed PostgreSQL-compatible database for demanding transactional and analytical workloads.

Showing questions 121–140 of 170 · Page 7 of 9