Reinforce GCP-ADP concepts with active-recall study cards covering all 4 blueprint domains. Each card shows the question on the front and the correct answer with a full explanation on the back.
Flashcards work through active recall — the process of retrieving information from memory rather than passively re-reading it. Research consistently shows that active recall produces stronger, longer-lasting memory than re-reading study guides. For GCP-ADP preparation, this means flashcards are one of the highest-return study tools available.
Attempt recall first
Read the GCP-ADP question on each card, pause, and attempt to formulate the answer in your own words before revealing. This retrieval attempt — even if wrong — dramatically strengthens memory compared to immediately reading the answer.
Review wrong cards again
When you get a card wrong, note it and add it back to your review pile. Spaced repetition — seeing difficult cards more frequently — is the mechanism that makes flashcard study far more efficient than linear reading.
Study by domain
Group your GCP-ADP flashcard sessions by domain for the first 3–4 weeks. Master one domain before moving to the next. In the final week, shuffle all cards together to test cross-domain recall — which is what the real GCP-ADP exam requires.
Short sessions beat marathon reviews
20–30 flashcard cards per session, done daily, produces better retention than a single 200-card marathon session. Five short daily sessions per week over 4 weeks gives you over 400 total card reviews — enough to reliably pass GCP-ADP.
Sample cards from the GCP-ADP flashcard bank. Read the question, think of the answer, then read the explanation below.
You need to store sensitive data in GCS. Which feature ensures data is encrypted at rest?
Default Encryption
Google Cloud Storage automatically encrypts all data at rest using AES-256 encryption before it is written to disk, with no configuration required. This default encryption ensures that sensitive data is protected without any additional action from the user. While CMEK and Cloud DLP offer additional control or inspection, the fundamental guarantee of encryption at rest is provided by default encryption.
You are building a Looker dashboard and need to calculate the year-over-year growth rate. Which feature should you use to perform this without modifying the underlying SQL?
Looker Table Calculations.
Looker Table Calculations allow you to create calculations (such as year-over-year growth) directly in the Explore or dashboard using Looker's expression language, without modifying the underlying SQL or LookML. They operate on the query results already returned, so you can compute percent change, offsets, and running totals on the fly. This makes them ideal for ad-hoc metrics like YoY growth.
You are orchestrating a pipeline with Workflows that invokes several Cloud Functions. You need to pass the output of one function as an argument to the next. What is the correct syntax?
Assign the call result to a variable and reference it in the next step.
Workflows uses a YAML/JSON syntax where each step's return value can be assigned to a variable, and subsequent steps reference that variable using ${variableName} syntax. This is the idiomatic way to chain Cloud Functions and pass outputs forward. For example: 'call: http.post' with 'result: fn1Result', then the next step uses '${fn1Result.body}'.
You have sensitive data in Cloud Storage that needs to be deleted after 30 days to comply with regulatory requirements. What is the most efficient way to manage this?
Use Cloud Storage lifecycle management policies
Cloud Storage Object Lifecycle Management lets you define rules directly on a bucket (e.g., Delete objects 30 days after creation) that GCS enforces automatically at no additional cost. This is the native, server-side, most efficient mechanism for time-based deletion and requires no code, scheduler, or external service.
You have a query that processes 500GB of data. You want to reduce the cost of this query. What is the most effective approach?
Add a WHERE clause to filter by the partitioned column.
BigQuery charges based on the amount of data processed by a query. Adding a WHERE clause that filters on a partitioned column allows BigQuery to prune partitions and scan only the relevant data, drastically reducing the bytes processed and thus the cost. This is the most effective and direct cost-reduction technique.
A user is running a query on a BigQuery table with nested data (JSON). How do you access a field named 'city' inside a record field named 'address'?
address.city
BigQuery uses Standard SQL, which accesses nested RECORD fields using dot notation. If 'address' is a RECORD (STRUCT) column containing a 'city' field, you reference it as address.city. This is the canonical syntax for traversing STRUCT types in BigQuery.
Which service should you use to ingest streaming data from mobile devices?
Pub/Sub
Pub/Sub is designed for real-time messaging and ingestion of streaming data from various sources, including mobile devices. It decouples producers from consumers, allowing mobile apps to publish events to topics that downstream services can subscribe to. This makes it ideal for high-throughput, low-latency streaming ingestion. Other options are storage or analytics services, not ingestion services.
Which service allows you to view the schema and metadata of a BigQuery table that has been registered in Dataplex?
Data Catalog
Data Catalog is the metadata management service in Google Cloud that indexes and exposes schema, column names, descriptions, tags, and other metadata for BigQuery tables (and other assets) registered in Dataplex. Once a BigQuery table is registered as a Dataplex asset, its technical metadata is surfaced through Data Catalog, which is the intended UI/API for schema and metadata discovery.
You need to analyze a petabyte-scale dataset in BigQuery. To optimize cost, you must ensure that users only query relevant partitions. How should you enforce this?
Enable the 'Require partition filter' option in the table settings.
BigQuery's 'Require partition filter' table option forces every query against the table to include a WHERE clause that filters on the partitioning column, preventing full-table scans and the associated on-demand costs. This is the native, enforced mechanism for ensuring users only query relevant partitions. It applies to partitioned tables and rejects queries that lack a partition predicate.
How do you restrict access to a specific GCS bucket to only members of a specific team?
Apply an IAM policy to the bucket
Bucket-level IAM policies are the native GCS mechanism for granting access to specific principals. By binding roles such as roles/storage.objectViewer to a Google Group representing the team, only members of that group inherit access to the bucket. This enforces least privilege at the resource boundary without affecting other buckets in the project.
You manage a BigQuery dataset that contains a table with millions of rows. Analysts frequently query only the most recent 30 days of data, but full-table scans are expensive. You need to reduce query costs and improve performance for these time-based queries with minimal changes to the table structure. What should you do?
Partition the table by a DATE or TIMESTAMP column using daily partitioning.
Partitioning a BigQuery table by a date or timestamp column enables partition pruning, so queries that filter on that column scan only the relevant partitions. This directly reduces the bytes processed and improves performance for time-based queries. Other options either do not reduce scanned data for arbitrary filters or add unnecessary complexity without addressing the root cause.
You have a Looker Studio report connected to a BigQuery table that contains millions of rows. The report takes a long time to load and often times out. You need to improve performance without changing the underlying data. What should you do?
Enable BigQuery BI Engine and set up a reservation for the dataset used by the report.
BI Engine provides an in-memory cache that accelerates queries from Looker Studio, reducing latency and preventing timeouts. It integrates seamlessly with BigQuery and requires no data duplication. The other options either do not improve performance or introduce impractical workarounds that fail with large datasets.
A team maintains a Looker dashboard fed by a BigQuery table that receives streaming inserts throughout the day. Users report that totals on the dashboard sometimes disagree with a report generated directly in BigQuery a few minutes later. What is the most likely explanation for the discrepancy?
Streaming inserts land in BigQuery's streaming buffer and are not immediately available to all query paths, so the dashboard and the direct report read slightly different snapshots.
Streaming ingestion does not write directly into fully queryable managed storage; rows first enter a buffer. Some query paths and export operations cannot see buffered rows, so a dashboard query and a report run moments apart can legitimately observe different row sets. The totals converge once the buffer commits, which is why the disagreement is small and transient rather than persistent.
Your team uses Cloud Composer (Airflow) to run a daily ETL DAG. A task occasionally fails due to transient network errors when calling an external API. You want the task to retry automatically up to 3 times with a 5-minute delay between attempts, and you want the DAG to continue running other tasks even if this task ultimately fails. Which combination of Airflow task parameters should you configure?
Set retries=3, retry_delay=timedelta(minutes=5), and set the task's downstream tasks to use trigger_rule='all_done'.
To handle transient failures, configure retries and retry_delay on the task. To allow the DAG to continue despite a task failure, set the downstream tasks' trigger_rule to 'all_done', which triggers them regardless of upstream success or failure. This combination ensures retries occur and subsequent tasks are not blocked, meeting both requirements.
In Dataflow, what is the impact of using a high number of workers for a small dataset?
Increased cost and overhead
Dataflow provisions workers as a fixed pool sized by the number of workers you specify, and each worker incurs per-hour Compute Engine charges plus associated overhead (startup, shuffle, network). For a small dataset, the work is finished quickly regardless of parallelism, so extra workers add no throughput benefit while multiplying cost and adding coordination overhead. The correct answer is therefore increased cost and overhead, not faster processing.
Your team is ingesting streaming clickstream events from Pub/Sub into BigQuery. You need to ensure that the pipeline can handle duplicate message deliveries without creating duplicate rows in the destination table. What should you do?
Enable exactly-once delivery on the Pub/Sub subscription and use a Dataflow pipeline with the BigQuery Storage Write API configured for exactly-once semantics.
End-to-end duplicate elimination for Pub/Sub to BigQuery requires exactly-once delivery on the subscription and a sink that supports exactly-once writes. The BigQuery Storage Write API with exactly-once semantics, combined with Pub/Sub exactly-once delivery, ensures each message is processed and written once. Other options either provide best-effort deduplication or do not prevent duplicates.
When creating a Looker visualization, which chart type is best for showing the relationship between two numerical variables?
Scatter plot.
A scatter plot is specifically designed to display the relationship between two numerical variables by plotting each data point as a dot on a two-dimensional Cartesian plane, with one variable on the x-axis and the other on the y-axis. This allows you to visually assess correlation, clustering, outliers, and patterns such as linear or non-linear relationships. In Looker, the scatter plot chart type automatically maps two measures to the axes, making it the ideal choice for bivariate numerical analysis.
Which service should you use to search for and discover datasets across your entire Google Cloud organization?
Data Catalog
Data Catalog is Google Cloud's fully managed, scalable metadata management service that enables search and discovery of datasets across the organization. It provides a unified inventory of data assets with tagging and search capabilities, making it the correct choice for discovering datasets organization-wide.
A data engineer needs to create a visualization in Looker Studio that shows the relationship between advertising spend and revenue for each marketing campaign. They want to quickly identify which campaigns have high spend but low revenue. Which chart type is most appropriate?
Scatter chart with advertising spend on the X-axis and revenue on the Y-axis, with each point representing a campaign.
To identify campaigns with high spend but low revenue, the analyst needs to see the correlation between the two metrics across campaigns. A scatter chart is designed for this purpose, plotting each campaign as a point based on its spend and revenue values. This visual format makes it easy to spot outliers that fall outside the expected pattern, such as those with high spend and low revenue.
You are creating a Looker report with a 'measure' that calculates the total revenue. You notice it is summing correctly but the format is wrong. Where do you change the format?
In the LookML view file using 'value_format_name'.
In Looker, a measure's display format is defined in the LookML view file using the `value_format_name` parameter (or `value_format` for custom formats). This parameter controls how the numeric value is rendered in the UI without altering the underlying calculation. Since the measure is already summing correctly, only the presentation layer needs adjustment, which is exactly what `value_format_name` does.
A product team uses Looker Studio to visualize metrics from a BigQuery table that is updated by an hourly ETL job. Users report that the dashboard shows data that is several hours stale even though the ETL completes successfully. The data source was configured with a custom query rather than a direct table reference. What is the most likely cause of the staleness?
The BigQuery data source uses a custom query, and Looker Studio caches the query results for the configured freshness interval.
Looker Studio caches results from a custom query data source and refreshes them according to the data source's freshness setting, which defaults to twelve hours. Because the ETL updates BigQuery but the dashboard serves a cached snapshot, users see data that lags by several hours. Lowering the freshness interval, or using a direct table reference where freshness behaves differently, resolves the mismatch.
The GCP-ADP flashcard bank covers all 4 official blueprint domains published by Google Cloud. Cards are distributed proportionally, so domains with higher exam weight have more cards.
Domain Coverage
Data Preparation And Ingestion
Data Analysis And Presentation
Data Pipeline Orchestration
Data Management
Both flashcards and practice questions are evidence-based study tools. The difference is in what they train:
Flashcards — concept retention
Best for memorising definitions, acronyms, protocol behaviours, command syntax, and conceptual distinctions. Use flashcards to build the foundational vocabulary that GCP-ADP questions assume you know.
Best in: weeks 1–3
Practice tests — application
Best for applying concepts to realistic scenarios, eliminating distractors, and building exam stamina.GCP-ADP questions test scenario reasoning — not just recall — so practice tests are essential.
Best in: weeks 3–6
The most effective GCP-ADP study plan combines both: use flashcards for the first 2–3 weeks to build conceptual foundations, then shift to practice tests and mock exams in the final 2–3 weeks to apply and benchmark that knowledge. Most candidates who pass on their first attempt use both tools.
Yes. Courseiva provides free GCP-ADP flashcards across all official exam domains. Every card includes the correct answer and a full explanation of why it is right and why the distractors are wrong. The platform also includes topic-based practice, mock exams, and readiness tracking — no account required.
Courseiva has 272+ original GCP-ADP flashcards across all 4 exam blueprint domains. New cards are added regularly as the question bank grows. All cards are checked against the official Google Cloud exam objectives, with editorial oversight from an experienced network and security engineer.
Courseiva flashcards are purpose-built for IT certification exams. Unlike generic flashcard platforms where content quality varies, every Courseiva card is mapped to the official GCP-ADP exam blueprint, written by engineers who hold the certification, and includes a full explanation of the correct answer and why the distractors are wrong. This explanation quality is what separates genuine learning from rote memorisation.
Courseiva is a web platform — an internet connection is required. For offline study, we recommend creating free Courseiva account, using the platform in your browser, and using your device's offline capabilities if your browser supports offline web apps.
Save your results, see which domains need more work, and get spaced repetition recommendations — all free.
Sign Up FreeFree forever · Every certification included