Practice Test 3 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
A system receives water temperature details per minute from 500 sensors installed in the different water sources of the region such as lakes, rivers, streams, and natural springs. As a data engineer, you are asked to find a solution to store data to a data warehouse for further analytics and reporting.
Data analytics team recommends using the SQL-like query based on their expertise. Management seeks a solution which could save storage and loading costs. What would you do if you are informed that real-time data reporting is not crucial and update rate for dashboards can be up to 15 minutes?
A. Use BigQuery to store and query event data. Batch load the data to BigQuery directly using its API.
B. Batch-load data into Google Storage. Launch BigTable with 10 nodes to allow high performance and import data from Google Storage to BigTable.
C. Store data in Google Storage. Use Cloud SQL as the main data warehouse and create users with required permissions for data analysts.
D. Enable streaming data to BigQuery and create users for analysts to use BigQuery for reporting.
Correct Answer: A
BigQuery supports both batch & streaming data. However, due to mentioned budget restrictions by management, Choosing the cheaper approach which is batching data is best. Batching data to BigQuery is free of charge. Streaming data, on the other hand, is charged by size.
Option B is incorrect: BigTable does not support SQL querying.
Option C is incorrect: This approach is valid, except, it may cost more since you pay for both storage and transfer costs in Google Storage as well as Cloud SQL instance which in return needs administration and scaling up compared to BigQuery which is serverless.
Option D is incorrect: Streaming data to BigQuery is not free. This will add to the costs of building a data warehouse solution and streaming is unnecessary here because
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:
Comments are closed, but trackbacks and pingbacks are open.