Data Warehousing on AWS Training Cheat Sheet 2026

The 30 highest-yield Data Warehousing on AWS Training facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. Which AWS service is best suited for orchestrating multi-step ETL workflows that include branching logic, error handling, and retries? → AWS Step Functions
2. A compliance team requires proof that no unauthorized access to Redshift occurred in the last 90 days. Which combination of services provides this evidence? → Redshift audit logs in S3 and AWS CloudTrail API activity logs
3. How does Amazon Redshift audit logging help with troubleshooting and compliance? → It records connection attempts, user activity, and SQL queries to S3 for review
4. Which Redshift WLM parameter controls how many queries can execute simultaneously in a single queue? → Query slots count
5. What is the purpose of enabling 'Enhanced VPC Routing' in Amazon Redshift? → To force all COPY and UNLOAD traffic through the VPC instead of the public internet
6. A Redshift cluster's storage is 85% full but compute utilization is low. Using RA3 nodes, what is the most cost-efficient way to add storage capacity? → Increase the RA3 managed storage quota independently without changing node count
7. Which AWS service is the primary recommended method for bulk-loading data into Amazon Redshift? → COPY command
8. What is the default behavior for queries submitted by superusers in Redshift WLM queue routing? → Superuser queries are automatically routed to the dedicated superuser queue
9. In Redshift SQL, which function pads a string on the left with a specified character to reach a target length? → LPAD()
10. Which feature allows Redshift to automatically scale read capacity to handle unpredictable spikes in concurrent users? → Concurrency scaling
11. What is the result of performing integer division in Redshift SQL, e.g., SELECT 7 / 2? → 3
12. What AWS service is created specifically for extracting, transforming, and loading (ETL) procedures in a data warehouse? → AWS Glue
13. Which aggregate function in Redshift returns the statistical median of a numeric column? → PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY col)
14. Which AWS service should be used to detect and alert on unusual query patterns or potential data exfiltration attempts in Amazon Redshift? → Amazon GuardDuty
15. An OLTP database is made to handle a business's daily requirements. → TRUE
16. Which Redshift query plan operation indicates an expensive cross-node data redistribution that should be minimized? → BROADCAST
17. What classification scheme best fits FADS? → Short Lived
18. Which critical thinking consideration explains why columnar storage is better than row storage for analytical workloads? → Column storage reduces I/O by reading only the columns needed for a query
19. What is the primary benefit of using columnar storage in Amazon Redshift compared to row-based storage? → Better compression and reduced I/O for analytical queries that scan few columns
20. An organization's Redshift cluster is in us-east-1 and they need a disaster recovery copy in us-west-2. Which feature automates this? → Cross-Region Snapshots with automated snapshot copy enabled
21. Which Redshift system table helps diagnose data load failures by showing the specific error for each rejected row? → STL_LOAD_ERRORS
22. It is the most popular social networking site where users may connect and exchange information about themselves. → Facebook
23. In Redshift SQL, what does the COALESCE function return when all its arguments are NULL? → NULL
24. How do you use SQL to retrieve every record where Peter is the first name and Jackson is the last name from the "Persons" table? → SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson
25. Which access control model has non-mandatory labels and allows the resource owner to set privileges to the data they own? → DAC
26. What distribution style should you choose for a large fact table in Redshift to minimize data movement during joins? → KEY distribution
27. the "Ice Bucket Challenge" → Fad
28. A data architect wants to separate storage costs from compute costs in a modern cloud data warehouse. Which Redshift deployment mode best achieves this? → Redshift RA3 nodes with managed storage
29. The data model's information is used to define → Primary and foreign keys
30. Which of the following is the default networking protocol for computers running Windows? → NetBIOS