PCDBE practice questions 121–130

1. Question 121 · 170 in bank

   You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

   • AConfigure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
   • BCreate your database with one primary node and one read replica in the region.
   • CEnable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
   • DConfigure your Cloud SQL instance with high availability enabled.

   Show answer

   Answer: A

   Explanation

   Since we don't really need HA and we have a window that users are not need our app - A is fine, and D looks like an overkill

   Source: Adapted from community discussion — chelbsik

   Next question

2. Question 122 · 170 in bank

   You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database: Can read tables, views, and DDL - Can write rows to the tables - Can add columns and indexes - Cannot drop the database - What should you do?

   • AAssign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
   • BAssign the Cloud Spanner Database Admin role.
   • CAssign the Cloud Spanner Database User role.
   • DAssign the Cloud Spanner Admin role.

   Show answer

   Answer: C

   Explanation

   Option C is corect spanner.admin God-tier control over everything Full CRUD & DDL for instances, databases, users, policies Manage entire Cloud Spanner environment spanner.databaseAdmin Database master control Full CRUD & DDL for databases, users, policies Create, manage, and secure databases spanner.databaseUser Power user with data rights Full CRUD & DDL for specified databases Read, write, modify data, manage database schema spanner.databaseReader Curious but hands-off observer Read-only access and query execution Analyze data without manipulation spanner.viewer Peeping Tom (metaphorically speaking) View instances, databases, and users Monitor Cloud Spanner metadata, no data access spanner.backupAdmin Backup whiz Create, view, update, delete backups Manage backups without accessing data

   Source: Adapted from community discussion — whoosh

   References

   • Google Cloud documentation

   Next question

3. Question 123 · 170 in bank

   Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this data. What should you do?

   • AUse Identity and Access Management (IAM) for Bigtable access control.
   • BUse VPC Service Controls to create a trusted network for the Bigtable service.
   • CUse customer-managed encryption keys (CMEK).
   • DUse Google Cloud Armor to add IP addresses to an allowlist.

   Show answer

   Answer: B

   Explanation

   B. A is wrong because you might have the right credentials but still access Bigtable across the internet. Same is true for C. Cloud Armor could help, but VPC Service Controls is a classic use case of ensuring access is only from within certain VPC networks. From Google’s documentation, “Users can define a security perimeter around Google Cloud resources such as Cloud Storage buckets, Bigtable instances, and BigQuery datasets to constrain data within a VPC and control the flow of data.” https://cloud.google.com/vpc-service-controls

   Source: Adapted from community discussion — dynamic_dba

   References

   • Google Cloud documentation
   • Google Cloud documentation

   Next question

4. Question 124 · 170 in bank

   Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?

   • ACloud SQL
   • BBigQuery
   • CCloud Spanner
   • DBigtable

   Show answer

   Answer: B

   Explanation

   This question is poorly worded. I interpret it as: you have a ticketing system that needs an analytics and reporting app. Which database for this analytics and reporting app (not the ticketing system)? It should be BQ. However, it could also be read as what database for the ticketing system which also happens to need analytics and reporting. Which means the answer should be Spanner. Very confusing, but I'm leaning towards B for BQ based on my first interpretation.

   Source: Adapted from community discussion — juliorevk

   References

   • Google Cloud documentation
   • Google Cloud documentation

   Next question

5. Question 125 · 170 in bank

   You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

   • APlace the bulk of the read and write workloads closer to the default leader region.
   • BUse staleness of at least 15 seconds.
   • CAdd more read-write replicas.
   • DKeep the total CPU utilization under 45% in each region.

   Show answer

   Answer: A

   Explanation

   https://cloud.google.com/spanner/docs/instance-configurations#multi-region-best-practices Best practices For optimal performance, follow these best practices: Design a schema that prevents hotspots and other performance issues. For optimal write latency, place compute resources for write-heavy workloads within or close to the default leader region. For optimal read performance outside of the default leader region, use staleness of at least 15 seconds. To avoid single-region dependency for your workloads, place critical compute resources in at least two regions. A good option is to place them next to the two different read-write regions so that any single region outage will not impact all of your application. Provision enough compute capacity to keep high priority total CPU utilization under 45% in each region.

   Source: Adapted from community discussion — sp57

   References

   • Google Cloud documentation

   Next question

6. Question 126 · 170 in bank

   Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?

   • AMigrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.
   • BMigrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
   • CMigrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
   • DMigrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.

   Show answer

   Answer: B

   Explanation

   B. A doesn’t make sense. Oracle is neither licensed nor supported in GCE. Eliminate D. Standard storage is more expensive that Nearline storage. Eliminate C. That leaves B as the most cost effective solution.

   Source: Adapted from community discussion — dynamic_dba

   Next question

7. Question 127 · 170 in bank

   You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies: PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios. MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level. You want to set up the environment with minimal administrative effort. What should you do?

   • ASet up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
   • BSet up different organizations for each database type, and apply policy constraints at the organization level.
   • CSet up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
   • DSet up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

   Show answer

   Answer: D

   Explanation

   A and C don't prevent anything, and between B and D I choose D because there is no sense to maintain a separate org just because of the compliance - a separate project is more than enough.

   Source: Adapted from community discussion — chelbsik

   Next question

8. Question 128 · 170 in bank

   You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

   • ABring DB-1 back online.
   • BDelete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
   • CDelete DB-2 so that DB-1 automatically reverts to the primary instance.
   • DCreate DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

   Show answer

   Answer: D

   Explanation

   The Option D describes the correct answer (even though it is only half part as it doesn't prevent split brain situations but It is better answer than B, A or C), The issue with answer B is It doesn't return to pretest configuration. Same Goes for A as DB-2 still the primary in this case. Option C is not recommended in case region is not available and still you end up having only Primary (DB-1) available and Not Replica (DB-2) we want pre test config which is both DB-1 and DB-2 available. PLEASE UPVOTE SO OTHERS CAN BENEFIT.

   Source: Adapted from community discussion — BIGQUERY_ALT_ALT

   References

   • Google Cloud documentation
   • Google Cloud documentation
   • Google Cloud documentation

   Next question

9. Question 129 · 170 in bank

   Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

   • AUse Bigtable.
   • BUse Firestore.
   • CUse Cloud SQL for MySQL
   • DUse Cloud Spanner.

   Show answer

   Answer: D

   Next question

10. Question 130 · 170 in bank

    You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

    • AView Cloud SQL operations to view historical query information.
    • BWhite a Logs Explorer query to identify database queries with high execution times.
    • CReview application logs to identify database calls.
    • DUse the Query Insights dashboard to identify high execution times.

    Show answer

    Answer: D

    Next question

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

PCDBE practice, question 121. 170 questions available.