Question 250
A Cloud Storage bucket must copy objects to another bucket under a regular managed transfer job. What is the best next step?
- Load data from Cloud Storage into a BigQuery table
- Schedule a Storage Transfer Service job
- Run a single-object gcloud storage cp operation
- Configure a cloud-to-cloud Storage Transfer Service transfer
Explanation
Correct Answer
D:Storage Transfer Service supports transfers between eligible object stores. Its job settings define what and when data is moved.
Incorrect Answers
A:This approach can ingest object files into analytical tables. The requirement is to migrate objects between storage locations, so it controls a different part of the workflow and leaves that result unaddressed.
B:This choice is useful to schedule external object transfers. The stated task is to migrate objects between storage locations, which requires a different mechanism or permission scope.
C:This setting would perform a one-time object copy. That behavior does not establish the requested ability to migrate objects between storage locations; it addresses an adjacent concern instead.
Question 251
An analyst has CSV files already in Cloud Storage and needs them queryable as BigQuery native tables. Which configuration best meets the requirement?
- Configure a cloud-to-cloud Storage Transfer Service transfer
- Load data from Cloud Storage into a BigQuery table
- Enable Cloud Storage Object Versioning on the bucket
- Schedule a Storage Transfer Service job
- Run a single-object gcloud storage cp operation
Explanation
Correct Answer
B:BigQuery load jobs ingest supported formats into table storage. The source bucket holds files, while the destination table enables SQL query execution.
Incorrect Answers
A:This mechanism is intended to automate bucket-to-bucket bulk copy. It does not implement the required action to load CSV data for BigQuery queries, even though both are relevant to the same general service.
C:For the stated need to load CSV data for BigQuery queries, this would instead retain earlier versions of objects; it supports the separate task to recover replaced object generations, not the required configuration.
D:Administrators use it to schedule external object transfers, rather than to load CSV data for BigQuery queries. Applying it would change the wrong component of this deployment.
E:While this can perform a one-time object copy, the present task requires an action to load CSV data for BigQuery queries. This operation does not supply the behavior described in the requirements.
Question 252
A developer needs to copy one local file directly into a bucket during troubleshooting. What should be configured?
- Load data from Cloud Storage into a BigQuery table
- Run a single-object gcloud storage cp operation
- Configure a cloud-to-cloud Storage Transfer Service transfer
- Configure suitable BigQuery table clustering
- Schedule a Storage Transfer Service job
Explanation
Correct Answer
B:The command provides a direct ad hoc object transfer. A managed transfer service is more suitable for recurring large migrations.
Incorrect Answers
A:Using this action would ingest object files into analytical tables, not upload a local diagnostic file. Its function is different from the specific change described in the scenario.
C:The tool can automate bucket-to-bucket bulk copy, but it cannot be substituted for the capability needed to upload a local diagnostic file. Its operational effect is not equivalent.
D:In a workflow for analytical dataset planning, it can cluster BigQuery table data; This question instead asks how to upload a local diagnostic file; substituting the former action would leave that distinct technical requirement unmet.
E:It can schedule external object transfers; however, it does not provide the specific operation to upload a local diagnostic file. The two controls serve different purposes.
Question 253
A new production Cloud SQL instance must support recovery from accidental data deletion, not only recovery from a zonal infrastructure failure. Which TWO safeguards should the team plan? (Choose TWO.)
- Configure supported point-in-time recovery before an incident and understand its recovery window
- Rely solely on a Cloud SQL high-availability standby to undo a DELETE transaction
- Increase the SQL instance's public IP quota instead of retaining backups
- Enable appropriate automated backups and verify the configured retention
Explanation
Correct Answers
A:Point-in-time recovery can restore to a chosen supported point within an available recovery window. It must be appropriately configured and cannot be assumed retroactively available.
D:Backups support restoring a recoverable database state after logical damage. Retention and recovery capabilities must be confirmed for the selected Cloud SQL engine and configuration.
Incorrect Answers
B:High availability addresses infrastructure faults and standby failover. Logical database changes, including unwanted deletes, can be reflected on the standby and require a recovery mechanism.
C:Additional public IP quota affects networking limits rather than the recoverability of database transactions. It does not replace backups or transaction-log-based recovery.
Question 254
A Cloud SQL workload requires automatic failover within a region. Which method addresses the task?
- Configure Cloud SQL high availability with a regional standby where supported
- Configure the Cloud SQL preferred maintenance window
- Enable and configure Cloud SQL automated backups
- Configure Cloud SQL private IP connectivity in the supported network
Explanation
Correct Answer
A:Cloud SQL HA can maintain a standby in another zone for supported engines. This protects against certain infrastructure failures, not every application mistake.
Incorrect Answers
B:Select this when the goal is to schedule database platform maintenance. Here the decisive requirement is to reduce single-zone database outage risk, and that outcome is not achieved by this action.
C:The tool can schedule managed relational backups, but it cannot be substituted for the capability needed to reduce single-zone database outage risk. Its operational effect is not equivalent.
D:This mechanism is intended to connect privately to a Cloud SQL instance. It does not implement the required action to reduce single-zone database outage risk, even though both are relevant to the same general service.
Question 255
A sensitive Cloud SQL instance must be accessible using private VPC addressing. What is the best next step?
- Enable and configure Cloud SQL automated backups
- Configure the Cloud SQL preferred maintenance window
- Configure Cloud SQL private IP connectivity in the supported network
- Configure Cloud SQL high availability with a regional standby where supported
- Configure supported Cloud SQL cross-region replication
Explanation
Correct Answer
C:Private IP provides private connectivity to a Cloud SQL instance subject to networking prerequisites. It avoids relying on a publicly reachable database IP.
Incorrect Answers
A:This approach can schedule managed relational backups. The requirement is to avoid a public database endpoint, so it controls a different part of the workflow and leaves that result unaddressed.
B:Its purpose is to schedule database platform maintenance. That distinction matters: the scenario calls for an action to avoid a public database endpoint, not this separate configuration task.
D:This setting would provide managed relational instance HA. That behavior does not establish the requested ability to avoid a public database endpoint; it addresses an adjacent concern instead.
E:In a workflow for redundancy across data products, it can replicate relational data to another region; This question instead asks how to avoid a public database endpoint; substituting the former action would leave that distinct technical requirement unmet.
Question 256
A database deployment needs a supported maintenance window that limits disruption during business hours. Which configuration best meets the requirement?
- Enable and configure Cloud SQL automated backups
- Configure the Cloud SQL preferred maintenance window
- Configure Cloud SQL private IP connectivity in the supported network
- Choose Cloud SQL for MySQL
- Configure Cloud SQL high availability with a regional standby where supported
Explanation
Correct Answer
B:Managed database maintenance settings influence when eligible updates are scheduled. They are separate from client query timeouts and transaction configuration.
Incorrect Answers
A:Select this when the goal is to schedule managed relational backups. Here the decisive requirement is to avoid planned maintenance during peak periods, and that outcome is not achieved by this action.
C:Administrators use it to connect privately to a Cloud SQL instance, rather than to avoid planned maintenance during peak periods. Applying it would change the wrong component of this deployment.
D:The choice is aimed at a different purpose: to retain MySQL application compatibility; Even if it can operate a managed MySQL database, that would not accomplish the stated requirement to avoid planned maintenance during peak periods.
E:The result of this choice would be to provide managed relational instance HA. The requested outcome, to avoid planned maintenance during peak periods, is handled at a different layer or through another operation.
Question 257
A Java backend already uses the Datastore API and has data in a legacy Datastore database. The team wants Google's managed Firestore platform while preserving compatibility with existing Datastore clients. Which database mode best fits?
- Export all Datastore entities to a BigQuery dataset and use BigQuery as the transactional backing store
- Switch immediately to Firestore in Native mode and assume unmodified Datastore client code works
- Create a Cloud SQL PostgreSQL read replica of the Datastore database
- Use Firestore in Datastore mode, subject to supported migration and compatibility requirements
Explanation
Correct Answer
D:Firestore in Datastore mode supports applications built on Datastore APIs and semantics. Teams should validate their migration path and client feature compatibility before any mode change.
Incorrect Answers
A:BigQuery is an analytics warehouse, not a drop-in low-latency transactional replacement for Datastore client operations.
B:Native mode has different APIs and client behaviors. A direct mode change cannot be assumed compatible with a legacy Datastore application.
C:Cloud SQL read replicas are not replication targets for Datastore databases. The services use different data models and storage systems.
Question 258
An application needs strongly consistent queries against Firestore documents after a write. Which approach should be selected?
- Use Firestore in Native mode where appropriate
- Create the indicated composite index
- Use Firestore's supported strongly consistent query behavior
- Define suitable Firestore Security Rules
- Choose Cloud SQL with a supported relational engine
Explanation
Correct Answer
C:Firestore provides consistent reads and transactional mechanisms in supported modes. Correct index and query design remain necessary for performance.
Incorrect Answers
A:Its purpose is to provide serverless document persistence. That distinction matters: the scenario calls for an action to query updated documents reliably, not this separate configuration task.
B:While this can support compound document queries, the present task requires an action to query updated documents reliably. This operation does not supply the behavior described in the requirements.
D:The result of this choice would be to authorize client document reads and writes. The requested outcome, to query updated documents reliably, is handled at a different layer or through another operation.
E:This mechanism is intended to host supported managed relational database engines. It does not implement the required action to query updated documents reliably, even though both are relevant to the same general service.
Question 259
A Firestore query needs filtering and ordering across multiple fields but reports an index requirement. Which method addresses the task?
- Use Firestore in Native mode where appropriate
- Define suitable Firestore Security Rules
- Use Firestore's supported strongly consistent query behavior
- Create the indicated composite index
Explanation
Correct Answer
D:Firestore requires suitable indexes for certain compound queries. Adding the index enables the query pattern without changing the data model.
Incorrect Answers
A:This choice is useful to provide serverless document persistence. The stated task is to resolve a missing Firestore index, which requires a different mechanism or permission scope.
B:It can authorize client document reads and writes; however, it does not provide the specific operation to resolve a missing Firestore index. The two controls serve different purposes.
C:Select this when the goal is to read committed document changes consistently. Here the decisive requirement is to resolve a missing Firestore index, and that outcome is not achieved by this action.
Question 260
An app should only expose each user's records according to authenticated identity when accessed through client SDKs. What is the best next step?
- Define suitable Firestore Security Rules
- Use Firestore in Native mode where appropriate
- Create the indicated composite index
- Create a partitioned BigQuery table and filter on its partition column
- Use Firestore's supported strongly consistent query behavior
Explanation
Correct Answer
A:Security Rules authorize supported client access using request and identity context. Server-side IAM access and client rules are distinct security paths.
Incorrect Answers
B:This setting would provide serverless document persistence. That behavior does not establish the requested ability to restrict user-level mobile data access; it addresses an adjacent concern instead.
C:Its purpose is to support compound document queries. That distinction matters: the scenario calls for an action to restrict user-level mobile data access, not this separate configuration task.
D:This alternative addresses analytical dataset planning by allowing a team to partition analytical data by date; The incident, however, requires the different action to restrict user-level mobile data access, so its central configuration remains unchanged.
E:This approach can read committed document changes consistently. The requirement is to restrict user-level mobile data access, so it controls a different part of the workflow and leaves that result unaddressed.