You Have a Large 5-TB AVRO File Stored in a Cloud

question 31

Multiple Choice

You have a large 5-TB AVRO file stored in a Cloud Storage bucket. Your analysts are proficient only in SQL and need access to the data stored in this file. You want to find a cost-effective way to complete their request as soon as possible. What should you do?

• A) Load data in Cloud Datastore and run a SQL query against it.
• B) Create a BigQuery table and load data in BigQuery. Run a SQL query on this table and drop this table after you complete your request.
• C) Create external tables in BigQuery that point to Cloud Storage buckets and run a SQL query on these external tables to complete your request.
• D) Create a Hadoop cluster and copy the AVRO file to NDFS by compressing it. Load the file in a hive table and provide access to your analysts so that they can run SQL queries.

---

Definitions:

Pools

Agreements between companies in the same industry to fix prices and divide markets among themselves, often to avoid competition and increase profitability.

Interstate Commerce Act

A United States federal law that was designed to regulate the railroad industry and its monopolistic practices by requiring reasonable and just rates with no discrimination.

Sherman Anti-Trust Act

A landmark federal statute in the United States passed in 1890 that prohibits monopolistic business practices and promotes competition in the marketplace.

Restraint of Trade

Legal terminology referring to practices or agreements that restrict competition, often regulated to protect economic fairness.