GCP Data Analysis & Reporting 3

Question 1

What is the primary advantage of using BigQuery's BI Engine?

Accepted Answer

It provides in-memory analysis for sub-second query response times in BI tools

Answer

BI Engine is an in-memory analysis service that accelerates BigQuery queries for BI tools like Looker Studio, delivering sub-second response times.

Question 2

You want to identify the top 5 products by revenue in a BigQuery query. Which SQL clause should you use?

Accepted Answer

ORDER BY revenue DESC LIMIT 5

Answer

ORDER BY revenue DESC sorts results from highest to lowest revenue, and LIMIT 5 returns only the top 5 rows.

Question 3

In Cloud Dataflow, what is a 'PCollection'?

Accepted Answer

An immutable distributed dataset that represents pipeline data

Answer

A PCollection is the fundamental data abstraction in Apache Beam/Dataflow — an immutable, distributed collection of elements processed by the pipeline.

Question 4

Which BigQuery function would you use to calculate a 7-day moving average of daily sales?

Accepted Answer

AVG() OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW)

Answer

Window functions with AVG() and a frame clause (ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) compute a rolling average over the specified window.

Question 5

What is the role of Cloud Pub/Sub in a data analytics pipeline?

Accepted Answer

It acts as a message queue to ingest and buffer streaming data

Answer

Pub/Sub is a messaging service that decouples data producers from consumers, buffering streaming events before downstream processing by Dataflow or other services.

GCP Test Practice Test

GCP Test Practice Test

GCP Data Analysis & Reporting 3