Free CLF-C02 practice questions: AWS analytics services

Athena, Redshift, Kinesis, Glue and QuickSight — matching each analytics job to its service. Seven questions, CLF-C02, 2026 edition.

Try 7 free AWS analytics questions in the exam's own style — every answer explained, no sign-up.

Straight to the 7 free questions ↓

The AWS analytics services trip people up because there are five of them and they sound similar. The exam does not ask you to build a pipeline — it asks you to match one analytics job to the right service. Learn the one verb that defines each, and this becomes reliable scoring in the biggest domain.

One job each

Amazon Athena — run ad-hoc SQL directly on data in S3, serverless, no loading step. Query in place.
Amazon Redshift — a data warehouse for complex analytics over large, structured datasets you load into it. Warehouse.
Amazon Kinesis — ingest and process streaming data in real time (clickstreams, logs, IoT). Real-time stream.
AWS Glue — managed ETL: extract, transform and load data between stores. Prepare and move.
Amazon QuickSight — business-intelligence dashboards and visualisations. Dashboards.

Query, warehouse, stream, ETL, dashboard. Almost every analytics question is deciding which of those five verbs a scenario describes.

The distinction the exam plants: Athena vs Redshift

The two that get confused are Athena and Redshift, because both answer analytical questions with SQL:

Athena is serverless and queries data in place in S3 — perfect for occasional, ad-hoc questions with nothing to manage.
Redshift is a provisioned warehouse you load data into — perfect for repeated, high-performance analytics over structured data.

Ad-hoc and serverless on S3 → Athena. A loaded warehouse for heavy, repeated analytics → Redshift.

How they fit together

The five are not rivals; they form a pipeline. Kinesis ingests a live stream, Glue transforms it, Redshift (or Athena over S3) analyses it, and QuickSight puts it on a dashboard. The exam may lay out exactly that chain and ask you to place each service — which is really just the one-verb-each table read left to right. For where these sit among AWS’s data stores, see the databases overview.

How to use the questions below

Answer each one before you reveal the explanation, and when you miss, read past the correct letter to why the other three fail. The distractors are always another analytics service offered for the wrong verb — QuickSight where ingest belongs, Athena where streaming belongs. Matching the verb in the question to the service is the whole skill, and the reasoning below drills it across all seven.

The AWS analytics services matched to jobs: Amazon Athena runs ad-hoc SQL queries directly on data in S3, Amazon Redshift is a data warehouse for large-scale analytics, Amazon Kinesis ingests and processes real-time streaming data, AWS Glue is a managed ETL service that prepares and moves data, and Amazon QuickSight is a business-intelligence service for dashboards and visualisations.

7 free CLF-C02 practice questions

Answers and explanations — no email wall

CLF-C02 Question 1 of 7

Which service lets you run ad-hoc SQL queries directly against data stored in Amazon S3, without loading it into a database first?

Answer: A — Amazon Athena

Amazon Athena is a serverless, interactive query service that runs standard SQL straight against data in S3 — no servers, no loading step. Why not the others: Redshift is a data warehouse you load data into, Glue is an ETL service that prepares data, and QuickSight is for dashboards. Query S3 in place with SQL is Athena.

CLF-C02 Question 2 of 7

A company needs a data warehouse to run complex analytical queries over very large, structured datasets. Which service fits?

Answer: A — Amazon Redshift

Amazon Redshift is AWS's data-warehouse service, built for fast complex analytics over large structured datasets you load into it. Why not the others: Athena queries S3 ad-hoc rather than being a warehouse, Kinesis handles real-time streams, and Glue prepares data. A data warehouse is Redshift.

CLF-C02 Question 3 of 7

Which service is designed to ingest and process streaming data in real time, such as clickstreams or IoT sensor data?

Answer: A — Amazon Kinesis

Amazon Kinesis collects, processes and analyses streaming data in real time — logs, clickstreams, sensor feeds. Why not the others: Redshift and Athena work on data at rest, not live streams, and QuickSight visualises results rather than ingesting streams. Real-time streaming is Kinesis.

CLF-C02 Question 4 of 7

A team needs to extract data from several sources, transform it, and load it for analysis. Which managed service is built for this ETL work?

Answer: A — AWS Glue

AWS Glue is a managed extract-transform-load (ETL) service that discovers, prepares and moves data between stores. Why not the others: QuickSight is for dashboards, Kinesis is for real-time streams, and Athena queries data rather than transforming and loading it. Managed ETL is Glue.

CLF-C02 Question 5 of 7

Which service creates interactive business-intelligence dashboards and visualisations from your data?

Answer: A — Amazon QuickSight

Amazon QuickSight is AWS's business-intelligence (BI) service, turning data into interactive dashboards and charts. Why not the others: Athena queries data, Glue prepares it, and Kinesis streams it — none of them build the visual dashboards. Dashboards and BI are QuickSight.

CLF-C02 Question 6 of 7

How does Amazon Athena differ from Amazon Redshift?

Answer: A — Athena runs serverless SQL directly on data in S3; Redshift is a provisioned data warehouse you load data into

Athena is serverless and queries S3 in place, ideal for ad-hoc questions; Redshift is a warehouse you load data into for repeated, high-performance analytics. Why not the others: they are distinct, the descriptions are not reversed, and neither is a streaming service. Query-in-place versus loaded warehouse is the difference.

CLF-C02 Question 7 of 7

A pipeline collects streaming events, prepares the data, stores it for analysis, and shows it on a dashboard. Which mapping of services is correct?

Answer: A — Kinesis ingests the stream, Glue transforms it, Redshift or S3+Athena analyses it, and QuickSight visualises it

Each service does one job in the chain: Kinesis for real-time ingest, Glue for ETL, Redshift (or Athena over S3) for analysis, QuickSight for dashboards. Why not the others: they swap the roles — QuickSight does not ingest streams, Athena does not stream, and Redshift is not a streaming ingester. Matching each service to its stage is the skill.

That is exactly how every question in the course works — answer, explanation, why-not. The real set continues in the practice player: 10 free questions, no sign-up.

Continue with the 10 free questions →

Those 7 questions were the start.

The exam does not test whether you recognise a term — it tests whether you can rule out three plausible answers under time pressure. That is what the explanations above are for, and there are 390 more questions built exactly like them.

Collecting questions yourself

Scattered across forums, of unknown age
Answer keys without reasoning
No idea which domain you are weak in

Practising with a system

390 questions in 6 full tests, CLF-C02 (2026)
Every option explained — including the wrong ones
Readiness per exam domain, and drills for your weakest

Start free — 10 questions

Straight into the player. No account, no email.

Frequently asked questions

Is this the current CLF-C02 format?

Yes — these questions follow the CLF-C02 exam guide (2026 edition). The analytics services sit in the Cloud Technology and Services domain, the largest on the exam at 34%, and matching a service to an analytics job is a common question shape.

Are these real exam questions?

No. They are our own questions, written in the style and difficulty of the exam. Reproducing real exam items violates the AWS certification agreement and can get your certification revoked, and a memorised item teaches you nothing about the one you have not seen.

Do I need to build an analytics pipeline for the exam?

No. CLF-C02 tests what each analytics service is for — query, warehouse, stream, ETL, dashboard — not how to configure them. You will recognise the right service for a described need, not build the pipeline.

What is the one-line way to keep them straight?

Athena queries S3 with SQL, Redshift is the data warehouse, Kinesis handles real-time streams, Glue does ETL, and QuickSight builds dashboards. One job each — match the verb in the question to the service.

Updated for CLF-C02 (July 2026). The sample questions above are our own work in the style of the exam — not real exam items. The exam itself is set and marked by the certification body.