Practice Test GeeksCWA - Certified Web Analyst Practice Test
← All CWA Flashcard Decks

Automation & Scripting Flashcards

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

Read the first 7 Automation & Scripting flashcards as text

  1. In the GA4 BigQuery export, which table holds streaming data for the current day?

    Answer: events_intraday_YYYYMMDD

    Intraday tables update continuously while daily tables are finalized after the day ends.

  2. How can you run a BigQuery SQL query on a recurring basis without external tools?

    Answer: Scheduled queries

    BigQuery scheduled queries execute SQL on a defined cadence and can write results to tables.

  3. Which Python library is commonly used to clean and reshape exported analytics data in DataFrames?

    Answer: pandas

    pandas provides DataFrames for filtering, grouping and transforming tabular data.

  4. In GA4 BigQuery data, which function flattens the repeated event_params field so you can read a parameter?

    Answer: UNNEST

    event_params is a repeated record, and UNNEST expands it into rows for filtering.

  5. Which Python package is Google's official client for the GA4 Data API?

    Answer: google-analytics-data

    The google-analytics-data package provides BetaAnalyticsDataClient for the Data API.

  6. How do you limit scanned data (and cost) when querying a date range across sharded GA4 export tables?

    Answer: Filter on _TABLE_SUFFIX in a wildcard table query

    Filtering _TABLE_SUFFIX prunes which daily tables are read, reducing bytes processed.

  7. What does the cron expression '0 6 * * 1' schedule?

    Answer: Every Monday at 06:00

    Fields are minute, hour, day of month, month, day of week; 1 is Monday.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. wpicert.org — Eligibility, passing score, retake policy, test delivery, exam format, score validity · verified Nov 2026