Programming Concepts on the Exam

Task statement 1.4, which readers under-prepare because it looks like a coding question and is not. SQL that the exam expects you to read, infrastructure as code, Git flow and CI/CD for pipelines, the SDK patterns that appear in stems, and optimising a query by reading its plan.

Content current as of 2026-10.

Lessons

1. The SQL the exam puts on screen
2. Infrastructure as code for pipelines
3. Git flow and CI/CD for data
4. SDK and CLI patterns

Sources

• AWS CloudFormation user guide — updating stacks using change sets
• AWS Serverless Application Model developer guide
• AWS SDKs and Tools reference guide — retry behavior
• AWS SDK for Python (Boto3) — paginators
• Amazon Redshift database developer guide — evaluating the query plan