You have a 5 TB AVRO file in Cloud Storage. Analysts only know SQL and need access ASAP cost-effectively. What should you do?
Choose an answer
Tap an option to check your answer.
Correct answer: Create BigQuery external tables that reference the Cloud Storage AVRO file and run SQL queries against those external tables..
Why this is the answer
Creating BigQuery external tables is the most cost-effective and immediate solution. BigQuery can query data directly from Cloud Storage without needing to ingest it, allowing analysts to use SQL immediately. This avoids the time and cost associated with data loading. Loading into Cloud Datastore is incorrect because Datastore is a NoSQL document database, not suitable for SQL queries. Loading into BigQuery and then dropping the table is less efficient and more costly than external tables, as it involves data ingestion. Creating a Hadoop cluster is overly complex, time-consuming, and expensive for this specific requirement.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed