Multiple Choice
You are designing storage for very large text files for a data pipeline on Google Cloud. You want to support ANSI SQL queries. You also want to support compression and parallel load from the input locations using Google recommended practices. What should you do?
A) Transform text files to compressed Avro using Cloud Dataflow. Use BigQuery for storage and query.
B) Transform text files to compressed Avro using Cloud Dataflow. Use Cloud Storage and BigQuery permanent linked tables for query.
C) Compress text files to gzip using the Grid Computing Tools. Use BigQuery for storage and query.
D) Compress text files to gzip using the Grid Computing Tools. Use Cloud Storage, and then import into Cloud Bigtable for query.
Correct Answer:

Verified
Correct Answer:
Verified
Q17: What are two methods that can be
Q18: You want to process payment transactions in
Q19: You need to create a near real-time
Q20: You need to choose a database for
Q21: Which of these numbers are adjusted by
Q23: You are building a model to make
Q24: You are implementing security best practices on
Q25: You have a requirement to insert minute-resolution
Q26: You have a data stored in BigQuery.
Q27: Your company is currently setting up data