Practice Test 1 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You design a pipeline for your company. You want to find a solution to store event data generated in CSV format. The goal is to query data using SQL over time window.
Which storage and schema design should you use recommended by Google?
A. Use Google Storage to store event data and use BigQuery to create external tables referencing event data and partitioned by time window.
B. Use Google Storage to store event data and use DataPrep jobs to partition data by time windows.
C. Use BigTable for storage and design tall and narrow tables adding each event as single row.
D. Use BigTable for storage and design short and wide tables adding each event as single row.
Answer: A.
The scenario states the goal is to query data using SQL. From the available answers, BigQuery is the best service to meet this requirement. Data can be stored in Google Storage, partitioned by time.
BigQuery can read directly from Google Storage creating external tables partitioned by time.
Answer B is incorrect: Dataprep does not support SQL queries.
Answer C & D are incorrect: BigTable is a NoSQL database by nature. Nonetheless, it supports SQL to query data. However, Bigtable is used if scaling is a critical issue. For this scenario, data is in CSV format and BigQuery is better structured to handle importing CSV data. While Bigtable requires extra prerequisites.
Source(s):
BigQuery – Introduction to external data sources: https://cloud.google.com/bigquery/external-data- sources
Comments are closed, but trackbacks and pingbacks are open.