BigData with Biqquery

Question 1

BigQuery is a ….?

Answer 1

fully managed data warehouse

Question 2

What is a data lake…?

Answer 2

It is just a pool of raw , unorganized, and unclassified data. which does not have any specific purpose.

Question 3

Bigquery is a fully managed serverless solution, meaning…?

Answer 3

tht you use SQL queries to answer your organization’s biggest questions without having to manage the hardware

Question 4

Dataflow is where we…?

Answer 4

ETL - extract transform and load the data.

Question 5

For real time data I would use…?

Answer 5

Pub/Sub

Question 6

for batch data I would use..?

Answer 6

Cload storage

Question 7

What does a typical data pipeline look like?

Answer 7

Question 8

What are the two services that Bigquery provides?

Answer 8

1. Fully managed storage facility for datasets
2. Fast SQL based analytical engine

Question 9

Inconsistency might result from …?

Answer 9

saving and processing data separately

Question 10

What are the three basic patterns to load data into bigquery?

Answer 10

1. Batch-load
2. Streaming
3. Generated Data

Question 11

What are the Analyic features of Bigquery?

Answer 11

1. Ad hoc analysis
2. Geospatial analytics
3. Building machine learning models
4. Building BI dashboards