Quibank app: now on the App Store — free, works offline. Get the app ↗

Chapters0/41 ▾
  1. 1.Cloud Concepts: Benefits & Economics0/4
    1. The six advantages of cloud computing
    2. Elasticity, scalability, agility, high availability and global reach
    3. Cloud economics: fixed versus variable cost and total cost of ownership
    4. Licensing, rightsizing and automation
  2. 2.Cloud Concepts: Well-Architected & Migration0/5
    1. The six pillars of the Well-Architected Framework
    2. Pillar trade-offs and the AWS Well-Architected Tool
    3. The AWS Cloud Adoption Framework: outcomes, perspectives and phases
    4. Migration strategies: the 7 Rs
    5. AWS migration services and tools
  3. 3.Security: Shared Responsibility & Compliance0/4
    1. Security of the cloud and security in the cloud
    2. How responsibility shifts with the service you choose
    3. Compliance reports, programs and where data lives
    4. Encryption, keys and audit records
  4. 4.Security: IAM & Access Management0/4
    1. The root user and sign-in credentials
    2. IAM users, user groups and roles
    3. Policies, deny rules and least privilege
    4. Federation, IAM Identity Center, Amazon Cognito and secrets
  5. 5.Security: Services & Resources0/4
    1. Blocking web attacks and DDoS: AWS WAF, AWS Shield and AWS Firewall Manager
    2. Detecting threats, flaws and sensitive data: GuardDuty, Inspector and Macie
    3. Collecting, investigating and advising: Security Hub, Detective and Trusted Advisor
    4. AWS Marketplace and where to find security help
  6. 6.Technology: Deployment & Global Infrastructure0/4
    1. Ways to access AWS: console, CLI, SDKs and APIs
    2. Deployment tools and cloud deployment models
    3. Regions, Availability Zones and high availability
    4. Multiple Regions, data residency and edge services
  7. 7.Technology: Compute & Networking0/4
    1. Amazon EC2 instance types, auto scaling and load balancers
    2. Containers, serverless compute, Lightsail and AWS Batch
    3. Inside a VPC: subnets, gateways, security groups and network ACLs
    4. Route 53 and connecting networks to AWS
  8. 8.Technology: Databases & Storage0/4
    1. Relational databases: Amazon RDS, Aurora and databases on EC2
    2. NoSQL, in-memory and graph databases, plus database migration
    3. Amazon S3 object storage, storage classes and lifecycle policies
    4. Block and file storage, Storage Gateway, AWS Backup and disaster recovery
  9. 9.Technology: AI, Analytics & Other Services0/4
    1. AI and machine learning services: pre-trained services and SageMaker AI
    2. Analytics services: Glue, Athena, Redshift, EMR, OpenSearch, Kinesis and Amazon Quick
    3. Messaging and workflows: SQS, SNS, EventBridge, Step Functions, Amazon Connect and SES
    4. Developer tools, cloud desktops, AWS Amplify and AWS IoT Core
  10. 10.Billing, Pricing & Support0/4
    1. EC2 purchasing options: On-Demand, Spot, Savings Plans, Reserved Instances and dedicated hardware
    2. Data transfer costs, consolidated billing and cost allocation tags
    3. Cost management tools: Pricing Calculator, Cost Explorer, Budgets, Cost and Usage Reports and Compute Optimizer
    4. AWS Support plans, Trusted Advisor, AWS Health and where to get help
Saved in this browser. Move it to another device →
← Technology: AI, Analytics & Other Services

Chapter 9 · Lesson 2 of 4

Analytics services: Glue, Athena, Redshift, EMR, OpenSearch, Kinesis and Amazon Quick

1 min read

Analytics questions follow data from arrival to a chart. Find the stage the scenario describes, then pick the service built for that stage. Many distractors are real analytics services placed at the wrong stage.

  • Amazon Kinesis collects and processes real-time streaming data such as clickstreams.
  • AWS Glue is serverless: it discovers, prepares and catalogs data.
  • Amazon Athena runs interactive SQL on files in Amazon S3 where they sit, with no loading and no infrastructure.
  • Amazon Redshift is the managed, petabyte-scale data warehouse for structured data and repeated reports.
  • Amazon EMR runs big data frameworks such as Apache Spark and Hadoop on managed clusters.
  • Amazon OpenSearch Service powers keyword search, log analytics and real-time application monitoring.
  • Amazon Quick provides interactive dashboards and business intelligence; it visualizes data but is not a warehouse.

Example: an analyst wants to run a SQL query twice a month on log files already in S3. Glue catalogs the files and Athena queries them in place; building a warehouse in Redshift would be more than this occasional job needs.

Check yourself

1. An analytics team has raw log files in Amazon S3. It wants one serverless service to discover and catalog the data, and another to run occasional SQL queries on the files where they sit, with no data loading. Which pair of services does each job, in order?

2. A retailer wants one central, managed data warehouse that holds years of structured sales data at petabyte scale and supports the same business reports every week. Which service fits best?

Facts checked 2026-11-15 · Sources: AWS Certified Cloud Practitioner (CLF-C02) exam guide, Domain 3, Amazon SageMaker AI Developer Guide: What is Amazon SageMaker AI

AWS Cloud Practitioner cheat sheet: every key fact on one page →