Practice Test 1 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
An environment safety facility receives thousands of events every 60 seconds from its sensors assembled in different sectors monitoring air pollution in the region. Scientists want to access and query the data for observation and daily reporting. Due to current funding state, their budget is limited and they seek a cost-effective, highly available and ACID-compliant solution supports SQL querying.
Which approach would you recommend for such scenario?
A. Use BigQuery to store and query the event data. Enable streaming on BigQuery for data to be loaded in real-time.
B. Batch-load data into BigTable with launching 10 nodes to allow high performance.
C. Use Cloud SQL to load events into a relational database and allow access to scientists to query.
D. Use BigQuery to store and query event data. Batch load the data to BigQuery using its API.
Answer: D.
BigQuery supports both batch & streaming data. However, due to mentioned budget restrictions, the solution would choose the cheaper approach, which is batching data to BigQuery. Batching data to BigQuery is free of charge. Streaming data on the other hand is charged by size.
So, answer D is correct.
Answer A is incorrect: Enabling streaming on BigQuery is not free. Since the budget is limited and the scenario seeks cost-effective solution, this approach is not recommended over batching.
Answer B is incorrect: BigTable does not support SQL querying.
Answer C is incorrect: Cloud SQL needs administration and not easily scalable. Cloud SQL does not provide batching tools. BigQuery is a better approach for such scenario.
Source(s):
Bigquery: Streaming data: https://cloud.google.com/bigquery/streaming-data-into-bigquery
Bigquery: Batch data: https://cloud.google.com/bigquery/batch
Bigquery Pricing: https://cloud.google.com/bigquery/pricing
Comments are closed, but trackbacks and pingbacks are open.