GCP Data Analysis & Reporting 4

Question 1

You need to run a machine learning model directly on data stored in BigQuery without exporting it. Which feature enables this?

Accepted Answer

BigQuery ML (BQML)

Answer

BigQuery ML allows you to create and execute machine learning models using SQL directly within BigQuery, eliminating the need to move data.

Question 2

What does the UNNEST() function do in BigQuery SQL?

Accepted Answer

Flattens an array column into individual rows

Answer

UNNEST() converts an ARRAY into a set of rows, allowing you to query individual elements of array-type columns in BigQuery.

Question 3

Which GCP service would you use to orchestrate a multi-step data pipeline that includes BigQuery jobs, Dataflow jobs, and Cloud Storage operations?

Accepted Answer

Cloud Composer (Apache Airflow)

Answer

Cloud Composer is a managed Apache Airflow service that orchestrates complex workflows across multiple GCP services with dependency management.

Question 4

In BigQuery, what is the difference between a clustered table and a partitioned table?

Accepted Answer

Partitioning divides data by a column value; clustering sorts data within partitions by specified columns

Answer

Partitioning splits a table into segments (e.g., by date), while clustering sorts the data within each partition by one or more columns to further optimize query performance.

Question 5

Which Looker Studio feature lets you restrict what data a specific user or group can see within a shared report?

Accepted Answer

Row-level security via data source credentials

Answer

Row-level security in Looker Studio is enforced at the data source level (e.g., BigQuery row-level access policies), controlling which rows each viewer can access.

GCP Test Practice Test

GCP Test Practice Test

GCP Data Analysis & Reporting 4