GCP Data Analysis & Reporting 2

Question 1

Which BigQuery feature allows you to query data directly from Google Sheets without importing it?

Accepted Answer

External tables

Answer

BigQuery external tables let you query data stored in Google Sheets (and other sources like GCS) without loading it into BigQuery storage.

Question 2

In Looker Studio, what is the purpose of a 'calculated field'?

Accepted Answer

To create new metrics derived from existing data source fields

Answer

Calculated fields in Looker Studio let you define custom metrics or dimensions using formulas applied to existing fields in your data source.

Question 3

You need to analyze streaming sensor data with sub-second latency on GCP. Which service is most appropriate?

Accepted Answer

Cloud Dataflow with streaming pipeline

Answer

Cloud Dataflow's streaming pipelines process unbounded data in real time, making it ideal for low-latency sensor data analysis.

Question 4

What does the BigQuery PARTITION BY clause in a DDL statement accomplish?

Accepted Answer

It divides a table into segments based on a column to reduce query costs

Answer

Partitioning divides a BigQuery table into segments (e.g., by date), so queries that filter on the partition column scan only relevant partitions, reducing cost.

Question 5

Which Looker Studio chart type is best suited for showing the composition of a whole across multiple categories?

Accepted Answer

Pie chart

Answer

A pie chart is designed to show part-to-whole relationships, displaying how each category contributes to the total.

GCP Test Practice Test

GCP Test Practice Test

GCP Data Analysis & Reporting 2