Examtopics

コメント(17)

• Breaking down the question into key points -

  1. 5-TB AVRO file stored in a Cloud Storage bucket.
  2. Analysts are proficient only in SQL
  3. cost-effective way to complete their request as soon as possible

  A. ....Load data in Cloud Datastore... (Not Correct because Cloud Datastore is not a good option to run SQL Queries)

  B. ...Load data in BigQuery.... (Not Cost Effective because loading the data which is already present in the bucket into BigQuery again is expensive)

  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. (This is the right answer as it meets all the requirements from the question)

  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. (Too roundabout and indirect. Not the right option)

  👍 133

  mohdafiuddin2020/12/28

• C is correct: https://cloud.google.com/bigquery/external-data-sources

  👍 23

  Ciumela2020/06/20
• 正解だと思う選択肢: C

  Answer C is the most cost-effective and efficient way to provide analysts access to the data stored in the 5-TB AVRO file in Cloud Storage.

  Here's why:

  You can create external tables in BigQuery that point to the 5-TB AVRO file stored in Cloud Storage. External tables allow you to query data stored in Cloud Storage without the need to load the data into BigQuery. This is a cost-effective way to provide your analysts' access to the data they need, and it is also an efficient solution since you can run SQL queries on the data directly in BigQuery.

  👍 3

  Buruguduystunstugudunstuy2023/02/22