Google Cloud Professional Cloud Database Engineer - Full Practice Exam 1

1. A Bigtable table uses monotonically increasing timestamps at the beginning of every row key and writes concentrate on one key range. Which approach best fits?
2. A Bigtable workload requires replicated serving capacity in more than one cluster with deliberate routing and consistency tradeoffs. Which approach best fits?
3. A capacity change should preserve headroom during seasonal peaks without assuming one benchmark reflects all production traffic. Which approach best fits?
4. A Cloud SQL production database must automatically recover from a supported zonal infrastructure failure. Which approach best fits?
5. A company needs to move existing large object collections from a supported source to Cloud Storage on a repeatable managed schedule. Which approach best fits?
6. A data platform must discover likely personal-information fields before analysts receive access. Which approach best fits?
7. A data team needs to ingest new business events as they occur, with producers and consumers decoupled. Which approach best fits?
8. A database application uses relational joins and transactions but an engineer proposes moving it unchanged to a wide-column store. Which approach best fits?
9. A database contains highly sensitive fields that only a limited reviewer group should read, while other users may query ordinary columns. Which approach best fits?
10. A database design needs predictable low-latency access to data that can be reconstructed from an authoritative persistent store. Which approach best fits?
11. A database disaster-recovery requirement covers regional failure rather than only one zone's loss. Which approach best fits?
12. A database fleet needs tested restoration, but operations currently checks only whether backup jobs report success. Which approach best fits?
13. A database migration must minimize write downtime. The source and target pair is supported by continuous migration. Which approach best fits?
14. A database migration runs through a private network path, but the migration service cannot connect although the source is healthy. Which approach best fits?
15. A database must continuously replicate supported source changes into an analytical pipeline after an initial snapshot, with limited source downtime. Which approach best fits?
16. A database replica is intended to offload read traffic, but the application still sends every read to the primary endpoint. Which approach best fits?
17. A database replication setup copied an accidental delete to every replica. The team needs recovery to a time before the mistake. Which approach best fits?
18. A database selection must satisfy a 5-minute recovery point objective and a 30-minute recovery time objective, not just an attractive benchmark. Which approach best fits?
19. A database uses customer-managed keys and requires recovery in a separate environment. Which approach best fits?
20. A database's primary bottleneck is repeated identical read traffic, and a bounded staleness policy is acceptable. Which approach best fits?
21. A dataset needs an identifiable steward, documented meaning, provenance, and quality expectations. Which approach best fits?
22. A deployment must avoid running its only database copy on an ephemeral compute disk. Which approach best fits?
23. A distributed relational database must maintain service through a failure covered by its selected multi-region configuration. Which approach best fits?
24. A financial system requires relational transactions, strong consistency, and horizontal database scaling across regions. Which approach best fits?
25. A Firestore deployment needs the resilience and placement characteristics of a multi-region location before data is created. Which approach best fits?
26. A global database architecture must survive a specified regional outage with an approved data-loss bound. Which approach best fits?
27. A legacy application requires an NFS-mounted shared file system that several Compute Engine VMs can access concurrently. Which approach best fits?
28. A migration needs a rollback option if application validation fails after connection switching. Which approach best fits?
29. A migration target must use stricter data access permissions than the legacy source while retaining necessary application access. Which approach best fits?
30. A migration team plans to move a database without checking extensions, data types, or application SQL compatibility. Which approach best fits?
31. A mobile application needs a document data model, client SDK integration, and real-time listeners for application records. Which approach best fits?
32. A policy requires encryption keys to remain under an approved external key-management system for a supported Google Cloud integration. Which approach best fits?
33. A PostgreSQL-compatible application needs a managed database optimized for demanding PostgreSQL workloads, including supported analytical acceleration features. Which approach best fits?
34. A PostgreSQL-compatible database must run in the customer's own infrastructure or another supported environment rather than only as a Google-managed cloud instance. Which approach best fits?
35. A privacy request requires removal of eligible personal records, but some records are subject to a lawful retention requirement. Which approach best fits?
36. A read replica falls behind during a write surge. The application serves stale data from the replica. Which approach best fits?
37. A recovery plan needs a maximum acceptable amount of lost data expressed as elapsed time before an incident. Which approach best fits?
38. A regionally deployed application needs database access with low network latency and approved residency. Which approach best fits?
39. A relational workload frequently looks up selective records through the same nonindexed predicate. Which approach best fits?
40. A rolling application rollout increases connection concurrency enough to threaten database limits. Which approach best fits?
41. A source database includes confidential information that should not appear in a developer migration test environment. Which approach best fits?
42. A SQL query becomes slow after data grows. The team must identify whether an inefficient access path or missing index is responsible. Which approach best fits?
43. A supported database migration must minimize cutover downtime and verify business-data correctness before serving traffic from the target. Which two actions are appropriate? Select 2 answers.
44. A supported encrypted data service becomes unavailable after its customer-managed encryption key is disabled. What should the incident team check first?
45. A team chooses a cross-engine migration and discovers unsupported source-specific stored procedures. Which approach best fits?
46. A telemetry service performs enormous volumes of low-latency key-based reads and writes. Its wide-column data model does not require relational joins. Which approach best fits?
47. A transactional service needs low-latency reads near users, but some read paths require the latest committed write. Which approach best fits?
48. A VM needs a bootable block device for its operating system and an application that expects a local filesystem on attached storage. Which approach best fits?
49. An analyst receives an occasional small supported CSV file and needs to append it to a BigQuery table without building a permanent streaming pipeline. Which approach best fits?
50. An application expects each customer order and payment record to update atomically within the chosen database's supported transaction model. Which approach best fits?
51. An application must tolerate a database primary's zonal failure with managed failover and minimal manual intervention. Which approach best fits?
52. An application stores images and exported files accessed by object name over APIs. It does not require a mounted file system. Which approach best fits?
53. An existing PostgreSQL transactional application needs a managed database with minimal engine changes. It does not need worldwide horizontal relational scaling. Which approach best fits?
54. An initial database copy completes, but the team needs proof that business data is complete and consistent before switching clients. Which approach best fits?
55. Analysts need consistent joinable replacements for customer identifiers without access to the original values. Which approach best fits?
56. Analysts need managed SQL scans over a large historical dataset, with minimal warehouse infrastructure management. Which approach best fits?
57. Analysts should query approved datasets without permission to change production ingestion configuration. Which approach best fits?
58. Cloud SQL reaches its connection limit after application instances scale rapidly. CPU remains moderate. Which approach best fits?
59. Compliance requires cryptographic operations using keys backed by hardware security modules in the managed key service. Which approach best fits?
60. The application should switch from the source database to the target only after ongoing replication has caught up within the approved loss window. Which approach best fits?

Comments — 0