Which of these operations can you perform from the BigQuery Web UI?

• A.Upload a file in SQL format.
• B.Load data with nested and repeated fields.
• C.Upload a 20 MB file.
• D.Upload multiple files using a wildcard.

Comment: *

Name: *

Email: *

Verification: *

When a Cloud Bigtable node fails, ____ is lost.

• A.all data
• B.no data
• C.the last transaction
• D.the time dimension

Comment: *

Name: *

Email: *

Verification: *

You are updating the code for a subscriber to a Put/Sub feed. You are concerned that upon deployment the subscriber may erroneously acknowledge messages, leading to message loss. You subscriber is not set up to retain acknowledged messages. What should you do to ensure that you can recover from errors after deployment?

• A.Set up the Pub/Sub emulator on your local machine Validate the behavior of your new subscriber togs before deploying it to production
• B.Enable dead-lettering on the Pub/Sub topic to capture messages that aren't successful acknowledged if an error occurs after deployment, re-deliver any messages captured by the dead-letter queue
• C.Use Cloud Build for your deployment if an error occurs after deployment, use a Seek operation to locate a tmestamp logged by Cloud Build at the start of the deployment
• D.Create a Pub/Sub snapshot before deploying new subscriber code. Use a Seek operation to re-deliver messages that became available after the snapshot was created

Comment: *

Name: *

Email: *

Verification: *

Your company is performing data preprocessing for a learning algorithm in Google Cloud Dataflow.
Numerous data logs are being are being generated during this step, and the team wants to analyze them. Due to the dynamic nature of the campaign, the data is growing exponentially every hour.
The data scientists have written the following code to read the data for a new key features in the logs.
BigQueryIO.Read
.named("ReadLogData")
.from("clouddataflow-readonly:samples.log_data")
You want to improve the performance of this data read. What should you do?

• A.Specify the TableReference object in the code.
• B.Use of both the Google BigQuery TableSchema and TableFieldSchema classes.
• C.Use .fromQuery operation to read specific fields from the table.
• D.Call a transform that returns TableRow objects, where each element in the PCollexction represents a single row in the table.

Comment: *

Name: *

Email: *

Verification: *

You are selecting services to write and transform JSON messages from Cloud Pub/Sub to BigQuery for a data pipeline on Google Cloud. You want to minimize service costs. You also want to monitor and accommodate input data volume that will vary in size with minimal manual intervention. What should you do?

• A.Use Cloud Dataproc to run your transformations. Use the diagnosecommand to generate an operational output archive. Locate the bottleneck and adjust cluster resources.
• B.Use Cloud Dataflow to run your transformations. Monitor the total execution time for a sampling of jobs.
  Configure the job to use non-default Compute Engine machine types when needed.
• C.Use Cloud Dataflow to run your transformations. Monitor the job system lag with Stackdriver. Use the default autoscaling setting for worker instances.
• D.Use Cloud Dataproc to run your transformations. Monitor CPU utilization for the cluster. Resize the number of worker nodes in your cluster via the command line.

Comment: *

Name: *

Email: *

Verification: *