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
Q71: MJTelco Case Study Company Overview MJTelco is
Q72: You're training a model to predict housing
Q73: Your company needs to upload their historic
Q74: You need to migrate a 2TB relational
Q75: You are designing storage for two relational
Q77: You want to automate execution of a
Q78: Your globally distributed auction application allows users
Q79: You want to analyze hundreds of thousands
Q80: You have a data stored in BigQuery.
Q81: You use a dataset in BigQuery for
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents