Google Cloud Professional Data Engineer PDE — Topic 1 Question 72

Question

You are designing storage for 20 TB of text files as part of deploying a data pipeline on Google Cloud. Your input data is in CSV format. You want to minimize the cost of querying aggregate values for multiple users who will query the data in Cloud Storage with multiple engines. Which storage service and schema design should you use?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Use Cloud Storage for storage. Link as permanent tables in BigQuery for query. Cloud Storage provides durable, scalable object storage that is fully managed. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage.

Google Cloud Professional Data Engineer PDE — Question 72