🔍

PCDBE — questions

Page 3 of 9 · 170 total questions.

PCDBE Question 41

Single page →
Topic 1 · Question 41

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

  • ACreate a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
  • BCreate a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
  • CCreate a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD. (correct answer)
  • DCreate a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.

PCDBE Question 42

Single page →
Topic 1 · Question 42

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

  • ATake no backups, and turn off transaction log retention.
  • BTake one manual backup per day, and turn off transaction log retention.
  • CTurn on automated backup, and turn off transaction log retention. (correct answer)
  • DTurn on automated backup, and turn on transaction log retention.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Turn on automated backup, and turn off transaction log retention.

PCDBE Question 43

Single page →
Topic 1 · Question 43

You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?

  • ASet your production instance's maintenance window to non-business hours. (correct answer)
  • BMigrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
  • CContact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
  • DUse Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Set your production instance's maintenance window to non-business hours.

PCDBE Question 44

Single page →
Topic 1 · Question 44

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

  • ADeploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1. (correct answer)
  • BDeploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
  • CDeploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
  • DDeploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.

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 45

Single page →
Topic 1 · Question 45

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

  • AUse Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
  • BUse Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API. (correct answer)
  • CUse Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
  • DUse Cloud Composer to execute a select * from table(s) query and export results.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

Explanation

Pub/Sub is a serverless, global messaging service that decouples services and ingests high-volume event streams.

PCDBE Question 46

Single page →
Topic 1 · Question 46

You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?

  • AUse Cloud SQL with read replicas for throughput.
  • BUse Firestore, and rely on automatic serverless scaling.
  • CUse Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
  • DUse Bigtable, and add nodes as necessary to achieve the required throughput. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use Bigtable, and add nodes as necessary to achieve the required throughput.

Explanation

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

PCDBE Question 47

Single page →
Topic 1 · Question 47

You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?

  • AUse Cloud Spanner with a customer-managed encryption key (CMEK). (correct answer)
  • BUse Cloud Spanner with default encryption.
  • CUse Cloud SQL with a customer-managed encryption key (CMEK).
  • DUse Bigtable with default encryption.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use Cloud Spanner with a customer-managed encryption key (CMEK).

Explanation

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

PCDBE Question 48

Single page →
Topic 1 · Question 48

You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?

  • AUse the Google Cloud Console or gcloud CLI to manually create a new clone database.
  • BUse the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
  • CVerify that the new replica is created automatically. (correct answer)
  • DStart the original primary instance and resume replication.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Verify that the new replica is created automatically.

PCDBE Question 49

Single page →
Topic 1 · Question 49

You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?

  • ADeploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
  • BDeploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
  • CDeploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery. (correct answer)
  • DMigrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.

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 50

Single page →
Topic 1 · Question 50

Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

  • AUse Cloud SQL serverless exports. (correct answer)
  • BCreate a read replica, and then use the mysqldump utility to export each table.
  • CClone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
  • DUse the mysqldump utility on the primary database instance to export the backup.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use Cloud SQL serverless exports.

Explanation

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

PCDBE Question 51

Single page →
Topic 1 · Question 51

You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?

  • AFor each application code, set up a common shared user account.
  • BFor each application code, set up a dedicated user account.
  • CFor the application server, set up a service account. (correct answer)
  • DFor the application server, set up a common shared user account.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: For the application server, set up a service account.

Explanation

A service account provides an identity for workloads to access Google Cloud APIs securely.

PCDBE Question 52

Single page →
Topic 1 · Question 52

Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?

  • AMigrate to Cloud SQL for SQL Server.
  • BMigrate to Cloud SQL for PostgreSQL.
  • CMigrate to Compute Engine. (correct answer)
  • DMigrate to Google Kubernetes Engine (GKE).
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Migrate to Compute Engine.

Explanation

Compute Engine provides configurable virtual machines when you need full control of the OS. This option meets the real-time / low-latency performance requirement.

PCDBE Question 53

Single page →
Topic 1 · Question 53

An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?

  • Aroles/cloudsql.viewer and roles/spanner.databaseUser
  • Broles/cloudsql.editor and roles/spanner.admin
  • Croles/cloudsql.client and roles/spanner.databaseReader
  • Droles/cloudsql.instanceUser and roles/spanner.databaseUser (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: roles/cloudsql.instanceUser and roles/spanner.databaseUser

Explanation

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

PCDBE Question 54

Single page →
Topic 1 · Question 54

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to: Work with transactions and offer strong consistency. Work with structured and semi-structured (JSON) data. Scale transparently to multiple regions globally as the operation grows. You need a Google Cloud database that meets all the requirements of the application. What should you do?

  • AUse Cloud SQL for PostgreSQL with both cross-region read replicas.
  • BUse Cloud Spanner in a multi-region configuration. (correct answer)
  • CUse Firestore in Datastore mode.
  • DUse a Bigtable instance with clusters in multiple regions.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use Cloud Spanner in a multi-region configuration.

Explanation

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

PCDBE Question 55

Single page →
Topic 1 · Question 55

You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?

  • A1. Create your instance with a specified external (public) IP address.2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.3. Use Cloud SQL Auth proxy to connect to the instance.
  • B1. Create your instance with a specified external (public) IP address.2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.3. Connect to the instance using a connection pool to best manage connections to the instance.
  • C1. Create your instance with a specified internal (private) IP address.2. Choose the VPC with private service connection configured.3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.4. Use Cloud SQL Auth proxy to connect to the instance.
  • D1. Create your instance with a specified internal (private) IP address.2. Choose the VPC with private service connection configured.3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.4. Connect to the instance using a connection pool to best manage connections to the instance. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: 1. Create your instance with a specified internal (private) IP address.2. Choose the VPC with private service connection configured.3. Configure the Serverless VPC Access connector in the same VPC network as your Clou...

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. A VPC provides a global, software-defined private network for your Google Cloud resources.

PCDBE Question 56

Single page →
Topic 1 · Question 56

You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?

  • ACheck the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
  • BCheck whether your service account has cloudsql.instances.connect permission.
  • CEnable the Cloud SQL Admin API. (correct answer)
  • DEnsure that you are using an external (public) IP address interface.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Enable the Cloud SQL Admin API.

Explanation

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

PCDBE Question 57

Single page →
Topic 1 · Question 57

You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of data. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?

  • AUse Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
  • BUse sharded Cloud SQL instances with one or more stores per database instance.
  • CUse a Biglable cluster with autoscaling.
  • DUse Cloud Spanner with a custom autoscaling solution. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Use Cloud Spanner with a custom autoscaling solution.

Explanation

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

PCDBE Question 58

Single page →
Topic 1 · Question 58

Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?

  • AUse replication to roll out changes to higher environments.
  • BUse backup and restore to roll out changes to higher environments.
  • CUse Liquibase to roll out changes to higher environments. (correct answer)
  • DManually capture detailed DBA audit logs when changes are rolled out to higher environments.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Liquibase to roll out changes to higher environments.

PCDBE Question 59

Single page →
Topic 1 · Question 59

Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?

  • AIssue a gcloud sql instances patch command to increase the number of vCPUs. (correct answer)
  • BUpdate a MySQL database flag to increase the number of vCPUs.
  • CIssue a gcloud compute instances update command to increase the number of vCPUs.
  • DBack up the database, create an instance with additional vCPUs, and restore the database.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Issue a gcloud sql instances patch command to increase the number of vCPUs.

Explanation

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

PCDBE Question 60

Single page →
Topic 1 · Question 60

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

  • AConfigure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region. (correct answer)
  • BConfigure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
  • CConfigure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
  • DConfigure the primary, standby, and read replica instances in zone A, all in the same region.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.

Showing questions 41–60 of 170 · Page 3 of 9