01. During a regional outage, an operator promotes a Cloud SQL cross-region replica so the application can resume writing.
What is true of the deployment immediately afterwards?
a) The promoted instance continues to replicate from the original primary once that region recovers
b) The original primary automatically becomes a replica of the promoted instance
c) The promoted instance is now a standalone primary and no longer receives replication from the original
d) The deployment retains the same level of regional redundancy it had before
02. After a nightly load, an analyst wants a repeatable check that no records were silently lost between the source extract and the destination table.
Which check addresses this directly?
a) Compare the record count and a summed control total between the source extract and the destination table
b) Confirm that the load job reported a successful exit status, and treat that as proof of delivery
c) Query the destination table for rows containing null values in required columns
d) Check that the destination table's schema matches the column list declared in the source extract's header row
03. What characterizes customer-supplied encryption keys?
a) The customer creates the key in Cloud KMS and grants the service permission to use it
b) The customer stores the key outside Google Cloud and provides it with each request
c) Google creates and rotates the key without customer involvement
d) The key protects data only while it moves between services
04. Which stage of a standard machine learning project immediately follows model training?
a) Data collection
b) Feature selection
c) Prediction on new data
d) Model evaluation
05. An operator is watching a streaming Dataflow job in the job monitoring interface. Throughput is steady but one step's reported system lag keeps climbing while the steps around it stay flat.
What does this most likely indicate?
a) The job has finished processing and is preparing to drain
b) That step is a bottleneck and work is accumulating ahead of it
c) The source has stopped producing new elements
d) The output table has reached its column limit
06. Which characteristic of a source environment most clearly indicates that Transfer Appliance is the appropriate choice over a network transfer?
a) The available bandwidth cannot move the dataset within the required timeframe
b) The dataset contains sensitive records that must be encrypted before they leave the site
c) The source files are stored in many small objects, which slows a network transfer
d) The transfer must repeat on a nightly schedule
07. An application written in Python must append rows to a BigQuery table as its users complete transactions, using the same credentials and error handling as the rest of the application.
Which loading approach fits?
a) Upload each row to Cloud Storage and load the objects on a schedule
b) Shell out to the bq command-line tool from the application process
c) Configure a BigQuery Data Transfer Service run against the application's database
d) Call BigQuery through its client library from within the application
08. Before running a large query, an analyst wants to know roughly how much data it will read.
What should they consult?
a) The row count of the largest table the query references
b) The number of columns listed in the query's select clause
c) The query validator's estimate of bytes processed, shown before the query runs
d) The elapsed time of the last query the analyst ran
09. How are keys organized in Cloud Key Management Service?
a) Keys are stored as objects inside a Cloud Storage bucket that the customer nominates and controls
b) Keys are grouped into key rings, and a key holds successive versions over its life
c) Keys are held in the project's metadata server and issued on each request
d) Keys are attributes of the dataset or bucket they protect and have no separate identity
10. An engineer is preparing JSON records for a BigQuery load and finds that a single file containing one large JSON array is rejected.
What form does the load expect instead?
a) One JSON array per line, with each array holding a complete record
b) A single JSON array, with the records indented one level inside it
c) A single JSON object whose keys are the row numbers of the records
d) One complete JSON object per line, with no enclosing array