Practice Test GeeksGCP Test Practice Test
← All GCP Flashcard Decks

Data Analysis & Reporting Flashcards

7 cards from real GCP practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Analysis & Reporting flashcards as text

  1. Which BigQuery feature allows you to share datasets with other Google Cloud projects without copying data?

    Answer: Analytics Hub

    Analytics Hub enables organizations to publish and subscribe to shared datasets (data exchanges) across projects without duplicating the underlying data.

  2. In a Dataflow streaming pipeline, what does 'windowing' accomplish?

    Answer: It groups unbounded streaming data into finite chunks for aggregation

    Windowing divides an unbounded data stream into finite time-based or count-based buckets so aggregations (sums, averages) can be computed over streaming data.

  3. You notice a BigQuery query scanning 500GB but only returning 100 rows. What is the most effective optimization?

    Answer: Add a WHERE clause filtering on a partitioned or clustered column

    Filtering on a partition or cluster column prunes the data scanned at the storage layer, dramatically reducing bytes processed and query cost.

  4. Which BigQuery ML model type would you use to predict a continuous numerical value, such as next month's sales revenue?

    Answer: Linear regression

    Linear regression in BigQuery ML predicts a continuous output variable based on input features, making it appropriate for numerical forecasting tasks.

  5. What is the purpose of the INFORMATION_SCHEMA views in BigQuery?

    Answer: To provide metadata about datasets, tables, jobs, and schema definitions

    INFORMATION_SCHEMA is a set of system views that expose metadata about BigQuery resources including table schemas, column details, job history, and storage statistics.

  6. In Looker Studio, which dimension type enables users to dynamically filter a report by selecting values from a dropdown?

    Answer: Control filter (dropdown list)

    A dropdown list control in Looker Studio creates an interactive filter widget that lets viewers select dimension values to dynamically filter all charts on the page.

  7. Which GCP service should you use to detect anomalies and trends in time-series metrics collected from your data pipelines?

    Answer: Cloud Monitoring with alerting policies

    Cloud Monitoring collects time-series metrics and supports alerting policies that can trigger on anomalies, thresholds, or trend deviations in pipeline metrics.