- (Exam Topic 6)
You are collecting loT sensor data from millions of devices across the world and storing the data in BigQuery. Your access pattern is based on recent data tittered by location_id and device_version with the following query:

You want to optimize your queries for cost and performance. How should you structure your data?

1. A. Partition table data by create_date, location_id and device_version
2. B. Partition table data by create_date cluster table data by tocation_id and device_version
3. C. Cluster table data by create_date location_id and device_version
4. D. Cluster table data by create_date, partition by location and device_version

Correct Answer: C

- (Exam Topic 5)
In order to securely transfer web traffic data from your computer's web browser to the Cloud Dataproc cluster you should use a(n) .

1. A. VPN connection
2. B. Special browser
3. C. SSH tunnel
4. D. FTP connection

Correct Answer: C
To connect to the web interfaces, it is recommended to use an SSH tunnel to create a secure connection to the master node.
Reference:
https://cloud.google.com/dataproc/docs/concepts/cluster-web-interfaces#connecting_to_the_web_interfaces

- (Exam Topic 1)
You are building a model to make clothing recommendations. You know a user’s fashion preference is likely to change over time, so you build a data pipeline to stream new data back to the model as it becomes available. How should you use this data to train the model?

1. A. Continuously retrain the model on just the new data.
2. B. Continuously retrain the model on a combination of existing data and the new data.
3. C. Train on the existing data while using the new data as your test set.
4. D. Train on the new data while using the existing data as your test set.

Correct Answer: C
https://cloud.google.com/automl-tables/docs/prepare

- (Exam Topic 5)
What is the general recommendation when designing your row keys for a Cloud Bigtable schema?

1. A. Include multiple time series values within the row key
2. B. Keep the row keep as an 8 bit integer
3. C. Keep your row key reasonably short
4. D. Keep your row key as long as the field permits

Correct Answer: C
A general guide is to, keep your row keys reasonably short. Long row keys take up additional memory and storage and increase the time it takes to get responses from the Cloud Bigtable server.
Reference: https://cloud.google.com/bigtable/docs/schema-design#row-keys

- (Exam Topic 2)
Flowlogistic is rolling out their real-time inventory tracking system. The tracking devices will all send package-tracking messages, which will now go to a single Google Cloud Pub/Sub topic instead of the Apache Kafka cluster. A subscriber application will then process the messages for real-time reporting and store them in Google BigQuery for historical analysis. You want to ensure the package data can be analyzed over time.
Which approach should you take?

1. A. Attach the timestamp on each message in the Cloud Pub/Sub subscriber application as they are received.
2. B. Attach the timestamp and Package ID on the outbound message from each publisher device as they are sent to Clod Pub/Sub.
3. C. Use the NOW () function in BigQuery to record the event’s time.
4. D. Use the automatically generated timestamp from Cloud Pub/Sub to order the data.

Correct Answer: B