A data analyst needs to load a large CSV file from an on-premises server into BigQuery. The file is 500 GB. Which transfer method is most appropriate?
Data Preparation And Ingestion
Question · Medium
Which Google Cloud storage service is best suited for storing semi-structured JSON documents that require flexible schemas and real-time mobile application access?
Question · Easy
Introduction & Exam Overview
About the Associate Data Practitioner Exam
Study guide
A pipeline must read streaming events from Pub/Sub and write aggregated results to BigQuery in near real-time. Which service provides a fully managed, serverless option for this use case?
Data Pipeline Orchestration
Tech Exam Prep Podcast
Listen on Spotify
Podcast
What does ELT stand for in the context of data pipelines, and how does it differ from ETL?
A team stores customer data in BigQuery. They want to ensure that personally identifiable information (PII) such as email addresses cannot be read by analysts unless they have explicit permission. Which BigQuery feature enforces this at the column level?
Data Management
Which Dataflow execution model processes each record independently as it arrives, with low latency?
Chapter 1: Data Processing Paradigms & Ingestion Strategies
1.1 ETL, ELT, and ETLT Transformation Paradigms
An analyst wants to explore a dataset interactively using Python, visualize distributions, and run ad-hoc SQL queries against BigQuery from a notebook. Which Google Cloud service supports this workflow?
Data Analysis And Presentation
A BigQuery table contains a TIMESTAMP column. An analyst writes a query using WHERE event_time BETWEEN '2025-01-01' AND '2025-12-31'. What is the most cost-effective BigQuery optimization to reduce bytes scanned?
What is the purpose of Cloud Composer in a data pipeline?
A company encrypts BigQuery data using customer-managed encryption keys (CMEK). An analyst is querying the table but receives an access denied error even though their IAM role allows data reads. What is the most likely cause?
Question · Hard
1.2 Data Transfer and Migration Tools
Looker Studio is best used for which of the following tasks?
A data engineer is building a pipeline using Apache Beam running on Dataflow. The pipeline must group click events by user ID within a 10-minute sliding window. Which Apache Beam concept enables this?
Which storage format is most efficient for analytical queries in BigQuery that read only a subset of columns from wide tables?
What is Dataform used for in the Google Cloud data stack?
1.3 Data Quality, Cleaning, and Validation
A BigQuery dataset contains sales data from 2018 to 2026. Analysts frequently filter by year. The table is currently unpartitioned. What partitioning strategy best reduces query costs?
What is the role of Pub/Sub in a Google Cloud data pipeline?
Which IAM role grants the minimum permissions needed for a user to run BigQuery queries and read query results without managing datasets or tables?
A data engineer needs to move 200 TB of historical data from AWS S3 to Google Cloud Storage on a one-time basis. Which tool is designed for this transfer?
Chapter 2: Data Formats & Storage Solution Selection
2.1 File Formats & Serialization Characteristics
What is the difference between Looker and Looker Studio?
A Dataflow pipeline processing Pub/Sub messages has high latency during peak hours. The team notices the job is not scaling up. What Dataflow feature should they verify is enabled?
What does CMEK stand for in Google Cloud storage security?
A team uses Dataproc to run a daily Spark job that processes 10 TB of log files stored in Cloud Storage. The cluster is idle for 22 hours a day. What is the most cost-efficient configuration?
2.2 Cloud Storage Buckets, Location Types & Storage Classes
Which BigQuery feature allows you to query data in Cloud Storage without loading it into BigQuery tables?
What is the purpose of data lineage in a data governance framework?
An analyst needs to schedule a BigQuery SQL query to run every night at 11 PM to refresh a summary table. What is the simplest approach within BigQuery?
A pipeline writes data to BigQuery using streaming inserts. An analyst queries the table and sees duplicate rows. What BigQuery mechanism helps prevent duplicate streaming inserts?
2.3 Selecting Google Cloud Databases and Storage Services
What is the primary use case for Bigtable compared to BigQuery?
What is Dataplex used for in Google Cloud?
A data engineer wants to trigger a Dataflow pipeline automatically whenever a new file is uploaded to a Cloud Storage bucket. Which service enables this event-driven trigger?
Which Cloud Storage storage class has the highest per-operation cost but no minimum storage duration, suitable for frequently accessed data?
Chapter 3: Loading Data & Modern Ingestion Architectures
3.1 Batch Loading Data into BigQuery
A data quality check reveals that 15% of rows in a BigQuery table have NULL values in a required address field. Which approach best resolves this at ingestion time?
What is the Avro file format most commonly used for in Google Cloud data pipelines?
An analyst wants to visualize month-over-month revenue trends using a line chart in Looker Studio. The data source is a BigQuery table with daily revenue. What transformation is needed before charting?
What is the purpose of a Pub/Sub dead-letter topic?
3.2 Streaming Ingestion & Deduplication Patterns
A company wants to enforce data retention policies so that BigQuery table partitions older than 90 days are automatically deleted. Which BigQuery feature supports this?
What does Cloud Data Fusion provide that distinguishes it from writing custom Dataflow pipelines?
An analyst needs to query a Cloud SQL (PostgreSQL) table from BigQuery without moving the data. Which BigQuery capability enables this?
Which Google Cloud service provides a managed metadata catalog for discovering and understanding datasets across an organization?
Loading more…