Data Warehousing on AWS Training Study Guide 2026
Everything you need to pass the Data Warehousing on AWS Training exam in one place: the exam format, every topic to study, real practice questions with explanations, flashcards, and full-length practice tests. Free, no sign-up needed.
📚 Data Warehousing on AWS Training Topics to Study (45)
✍️ Sample Data Warehousing on AWS Training Questions & Answers
1. What is the effect of setting WLM timeout to 0 for a queue in Amazon Redshift?
A WLM timeout value of 0 means no timeout is enforced, allowing queries in that queue to run indefinitely until they complete or are manually cancelled.
2. A company requires that database administrators cannot view sensitive salary data in Redshift. Which combination of features best achieves this?
Combining column-level access control with dynamic data masking allows you to restrict or obfuscate sensitive columns even from privileged users like DBAs.
3. Which Redshift feature allows you to query data directly in Amazon S3 without loading it into the cluster, representing a key trend toward data lake integration?
Redshift Spectrum extends SQL queries to exabytes of unstructured data in S3, integrating data warehouse and data lake queries in a single statement.
4. Which connection type does AWS Glue use when writing ETL job output directly into Amazon Redshift?
AWS Glue connects to Amazon Redshift using a JDBC connection, which allows ETL jobs to read from and write to Redshift tables.
5. What does high CPUUtilization combined with low DiskReadThroughput on a Redshift cluster suggest?
High CPU with low disk reads suggests queries are being served from the in-memory cache, which is actually a sign of good caching behavior.
6. An administrator needs to rotate the encryption key for an existing Amazon Redshift cluster without downtime. What is the correct procedure?
Amazon Redshift supports in-place encryption key rotation through the console or CLI, which re-encrypts the cluster with a new key while keeping the cluster available.