Question 460
An application expects a multi-document update to be all-or-nothing. Which approach should be selected?
- Create the required Firestore composite index
- Update Firestore Security Rules to enforce the authenticated user's ownership
- Configure AlloyDB backup and recovery operations for the cluster
- Use an appropriate Firestore transaction or batched write based on read needs
- Use a supported Firestore managed export or backup operation
Explanation
Correct Answer
D:Firestore supports atomic operations across supported documents. Transactions support read-modify-write patterns with retry semantics.
Incorrect Answers
A:Select this when the goal is to resolve a Firestore missing-index error. Here the decisive requirement is to preserve consistency across document updates, and that outcome is not achieved by this action.
B:This mechanism is intended to apply per-user Firestore data access. It does not implement the required action to preserve consistency across document updates, even though both are relevant to the same general service.
C:Choosing this would protect AlloyDB with managed backups, an appropriate action for spanner and alloydb management operations; It cannot take the place of the separate step needed to preserve consistency across document updates in this specific situation.
E:The result of this choice would be to back up Firestore document data. The requested outcome, to preserve consistency across document updates, is handled at a different layer or through another operation.
Question 461
A Spanner administrator needs a strongly consistent SQL query over distributed transactional tables. What is the most direct solution?
- Use supported AlloyDB performance and query diagnostic views
- Run the query using an authorized Spanner client or SQL interface
- Create a Spanner backup using the service's supported backup feature
- Configure AlloyDB backup and recovery operations for the cluster
Explanation
Correct Answer
B:Spanner provides relational query capabilities backed by a distributed transactional database. It is not accessed through BigQuery's ordinary dataset query engine.
Incorrect Answers
A:This choice is useful to inspect AlloyDB query performance. The stated task is to read globally consistent Spanner data, which requires a different mechanism or permission scope.
C:This setting would back up a Spanner database. That behavior does not establish the requested ability to read globally consistent Spanner data; it addresses an adjacent concern instead.
D:It can protect AlloyDB with managed backups; however, it does not provide the specific operation to read globally consistent Spanner data. The two controls serve different purposes.
Question 462
A Spanner instance requires managed backup data for recovery. Which implementation matches this requirement?
- Configure AlloyDB backup and recovery operations for the cluster
- Use supported AlloyDB performance and query diagnostic views
- Connect with an authorized SQL client or Cloud SQL connector
- Run the query using an authorized Spanner client or SQL interface
- Create a Spanner backup using the service's supported backup feature
Explanation
Correct Answer
E:Spanner backups preserve database state for later restore according to retention and location rules. A Cloud SQL backup does not restore a Spanner database.
Incorrect Answers
A:While this can protect AlloyDB with managed backups, the present task requires an action to protect distributed SQL data. This operation does not supply the behavior described in the requirements.
B:The result of this choice would be to inspect AlloyDB query performance. The requested outcome, to protect distributed SQL data, is handled at a different layer or through another operation.
C:The technical effect is to execute SQL against Cloud SQL, not to protect distributed SQL data; That distinction matters here because the first operation serves query an operational relational database, rather than the scenario's required result.
D:Its purpose is to query a distributed relational database. That distinction matters: the scenario calls for an action to protect distributed SQL data, not this separate configuration task.
Question 463
An AlloyDB cluster's recovery plan needs a suitable managed backup. What should the administrator do?
- Restore the Cloud SQL backup to an appropriate target instance
- Use supported AlloyDB performance and query diagnostic views
- Run the query using an authorized Spanner client or SQL interface
- Create a Spanner backup using the service's supported backup feature
- Configure AlloyDB backup and recovery operations for the cluster
Explanation
Correct Answer
E:AlloyDB manages PostgreSQL-compatible database infrastructure and supports service-specific backup workflows. Recovery targets and retention must match the business RPO.
Incorrect Answers
A:Choosing this would restore a managed database backup, an appropriate action for cloud sql database maintenance operations; It cannot take the place of the separate step needed to recover a PostgreSQL-compatible cluster in this specific situation.
B:This choice is useful to inspect AlloyDB query performance. The stated task is to recover a PostgreSQL-compatible cluster, which requires a different mechanism or permission scope.
C:The tool can query a distributed relational database, but it cannot be substituted for the capability needed to recover a PostgreSQL-compatible cluster. Its operational effect is not equivalent.
D:Select this when the goal is to back up a Spanner database. Here the decisive requirement is to recover a PostgreSQL-compatible cluster, and that outcome is not achieved by this action.
Question 464
A PostgreSQL-heavy team wants to inspect query performance on its managed AlloyDB workload. Which choice provides the required behavior?
- Use a supported Cloud SQL read replica for read traffic
- Use supported AlloyDB performance and query diagnostic views
- Run the query using an authorized Spanner client or SQL interface
- Configure AlloyDB backup and recovery operations for the cluster
- Create a Spanner backup using the service's supported backup feature
Explanation
Correct Answer
B:Database-level query diagnostics help identify expensive statements and resource pressure. A generic VM CPU chart does not expose all relational query details.
Incorrect Answers
A:This proposal can scale relational database reads, but the failure or goal described here calls for a way to diagnose slow database statements; It changes the wrong control or scope for the requested outcome.
C:Its purpose is to query a distributed relational database. That distinction matters: the scenario calls for an action to diagnose slow database statements, not this separate configuration task.
D:While this can protect AlloyDB with managed backups, the present task requires an action to diagnose slow database statements. This operation does not supply the behavior described in the requirements.
E:This setting would back up a Spanner database. That behavior does not establish the requested ability to diagnose slow database statements; it addresses an adjacent concern instead.
Question 465
An application must retrieve a Bigtable row by its exact row key. How should the team proceed?
- Use Bigtable's supported table backup feature
- Review row key ordering and hotspot patterns
- Grant a suitable Storage Object Viewer role on the specific bucket
- Use a supported Bigtable client to read the keyed row
- Use Database Center for supported database inventory and management insights
Explanation
Correct Answer
D:Bigtable's primary access model is row-key-oriented. A relational JOIN over multiple tables is not its native query pattern.
Incorrect Answers
A:The result of this choice would be to back up a Bigtable table. The requested outcome, to retrieve wide-column data efficiently, is handled at a different layer or through another operation.
B:It can optimize wide-column row key distribution; however, it does not provide the specific operation to retrieve wide-column data efficiently. The two controls serve different purposes.
C:This mechanism is intended to grant read access to objects in one bucket. It does not implement the required action to retrieve wide-column data efficiently, even though both are relevant to the same general service.
E:The tool can monitor a managed database fleet centrally, but it cannot be substituted for the capability needed to retrieve wide-column data efficiently. Its operational effect is not equivalent.
Question 466
A Bigtable workload has uneven access and requires review of row key design. What is the most direct solution?
- Use Database Center for supported database inventory and management insights
- Use Bigtable's supported table backup feature
- Use a supported Bigtable client to read the keyed row
- Review row key ordering and hotspot patterns
Explanation
Correct Answer
D:Bigtable stores rows ordered by key and partitions load across tablets. Poorly distributed sequential keys can produce hotspots.
Incorrect Answers
A:This choice is useful to monitor a managed database fleet centrally. The stated task is to reduce concentrated Bigtable traffic, which requires a different mechanism or permission scope.
B:This setting would back up a Bigtable table. That behavior does not establish the requested ability to reduce concentrated Bigtable traffic; it addresses an adjacent concern instead.
C:Using this action would read a Bigtable row by key, not reduce concentrated Bigtable traffic. Its function is different from the specific change described in the scenario.
Question 467
An organization needs to create recoverable Bigtable backups for key operational tables. Which implementation matches this requirement?
- Review row key ordering and hotspot patterns
- Enable supported regional HA for the database service
- Use a supported Bigtable client to read the keyed row
- Use Database Center for supported database inventory and management insights
- Use Bigtable's supported table backup feature
Explanation
Correct Answer
E:Bigtable backups preserve table data for supported restore scenarios. Backup storage and retention differ from ordinary object storage versioning.
Incorrect Answers
A:This mechanism is intended to optimize wide-column row key distribution. It does not implement the required action to recover wide-column data, even though both are relevant to the same general service.
B:This proposal can provide automated database zone failover, but the failure or goal described here calls for a way to recover wide-column data; It changes the wrong control or scope for the requested outcome.
C:While this can read a Bigtable row by key, the present task requires an action to recover wide-column data. This operation does not supply the behavior described in the requirements.
D:Administrators use it to monitor a managed database fleet centrally, rather than to recover wide-column data. Applying it would change the wrong component of this deployment.
Question 468
A database operations team needs a cross-service overview of managed database estate health. What should the administrator do?
- Use a valid point-in-time backup or recovery mechanism
- Use Bigtable's supported table backup feature
- Review row key ordering and hotspot patterns
- Use a supported Bigtable client to read the keyed row
- Use Database Center for supported database inventory and management insights
Explanation
Correct Answer
E:Database Center surfaces fleet information across supported Google Cloud database products. It is a management view, not a replacement for each database engine's query interface.
Incorrect Answers
A:An operator would use this action to recover pre-corruption database state, chiefly when trying to undo replicated data loss; The current requirement is to review database estate status, which remains unresolved by that operation.
B:This choice is useful to back up a Bigtable table. The stated task is to review database estate status, which requires a different mechanism or permission scope.
C:Using this action would optimize wide-column row key distribution, not review database estate status. Its function is different from the specific change described in the scenario.
D:The tool can read a Bigtable row by key, but it cannot be substituted for the capability needed to review database estate status. Its operational effect is not equivalent.
Question 469
A Cloud SQL instance regularly approaches its provisioned disk capacity during unpredictable growth. The team wants the supported service to enlarge storage before the database exhausts it. Which setting should be considered?
- Create a read replica and assume its disk is added to the primary's writable capacity
- Move a Cloud SQL backup file into a larger Cloud Storage bucket
- Enable Cloud SQL automatic storage increases for the eligible instance
- Configure point-in-time recovery to increase available free disk automatically
Explanation
Correct Answer
C:Automatic storage increases can grow Cloud SQL storage as needed on supported instance configurations. The operator must still monitor storage limits, cost, and engine-specific behavior.
Incorrect Answers
A:A read replica receives a copy of the primary's data and serves suitable read traffic. Its separate storage is not pooled into the primary database's writable filesystem.
B:Backup storage capacity is distinct from the primary database's provisioned disk. Enlarging a bucket would not change the instance's usable database volume.
D:Point-in-time recovery supports recovering historical database states. It does not increase an instance's provisioned disk space when capacity is low.
Question 470
A transactional service must fail over automatically when a zone hosting its primary database becomes unavailable. How should the team proceed?
- Enable supported regional HA for the database service
- Use a supported Cloud SQL read replica for read traffic
- Design supported cross-region replication and backup schedules to match the RPO
- Use a valid point-in-time backup or recovery mechanism
Explanation
Correct Answer
A:Regional HA distributes critical database components across zones for certain failure scenarios. It does not provide a blanket guarantee against accidental deletes.
Incorrect Answers
B:This mechanism is intended to scale relational database reads. It does not implement the required action to maintain service through a zonal outage, even though both are relevant to the same general service.
C:The tool can meet a regional database recovery point target, but it cannot be substituted for the capability needed to maintain service through a zonal outage. Its operational effect is not equivalent.
D:Select this when the goal is to recover pre-corruption database state. Here the decisive requirement is to maintain service through a zonal outage, and that outcome is not achieved by this action.