PCDBE practice questions 131–140

1. Question 131 · 170 in bank

   You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

   • ACreate one regional Cloud SQL instance with a read replica in another region.
   • BCreate one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
   • CCreate two read-write Cloud SQL instances in two different zones with a standby instance in another region.
   • DCreate two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

   Show answer

   Answer: B

   Explanation

   B. A is not HA. B would be HA. C doesn’t make sense and neither does D. Cloud SQL is a regional service which means the failover replica is in the same region as the primary - hopefully in a different zone. Read replicas can be in different regions, but they’re read replicas not failover replicas.

   Source: Adapted from community discussion — dynamic_dba

   Next question

2. Question 132 · 170 in bank

   Your company is migrating from an on-premises database to a single-region Spanner instance. The current database supports 40,000 reads each second, and 7,000 writes each second, at 1 KB row sizes at peak. You need to determine the most cost-effective size for the Spanner instance to handle the equivalent current workload. What should you do?

   • ASelect a 4-node Spanner instance.
   • BSelect a 6-node Spanner instance.
   • CSelect a 1-node Spanner instance.
   • DRecommend a multi-region Spanner instance.

   Show answer

   Answer: A

   Next question

3. Question 133 · 170 in bank

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

   Show answer

   Answer: A

   Next question

4. Question 134 · 170 in bank

   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.
   • DDeploy the database using Cloud Spanner.

   Show answer

   Answer: C

   Next question

5. Question 135 · 170 in bank

   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.
   • DUse the Firebase Admin SDK to programmatically schedule and manage exports.

   Show answer

   Answer: C

   Next question

6. Question 136 · 170 in bank

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

   Show answer

   Answer: A

   Next question

7. Question 137 · 170 in bank

   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.
   • DAssign all reporting queries to a single, large read pool to maximize the combined compute resources available for analytics.

   Show answer

   Answer: C

   Next question

8. Question 138 · 170 in bank

   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.

   Show answer

   Answer: D

   Next question

9. Question 139 · 170 in bank

   Select 2

   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.
   • 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.
   • ELeverage Storage Transfer Service with client-side encryption.

   Show answer

   Answer: BD

   Next question

10. Question 140 · 170 in bank

    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.
    • DDisable PITR, then enable PITR.

    Show answer

    Answer: C

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PCDBE practice, question 131. 170 questions available.