Correct Answer: A 'Sort Key' on the date column
Sort keys determine the physical order in which data is stored on disk. Using a sort key on columns used in 'WHERE' clauses (like dates) allows Redshift to skip entire blocks of da...
Correct Answer
A 'Sort Key' on the date column
Why This Answer Is Correct
Sort keys determine the physical order in which data is stored on disk. Using a sort key on columns used in 'WHERE' clauses (like dates) allows Redshift to skip entire blocks of data during scans.
This question evaluates your knowledge of Amazon Redshift — a core concept tested in AWS Certified Solutions Architect – Professional (SAP-C02). Understanding Amazon Redshift is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
You are analyzing petabytes of data for business intelligence reports. You need a fully managed, serverless enterprise data warehouse that supports SQL queries. Which service is best suited for this task?
An organization wants to analyze petabytes of historical transaction data stored in S3 using SQL. The analysis must be fast and the costs must be predictable for hundreds of analysts. Which service should they use?
Your organization is running a data warehouse on Amazon Redshift. They want to store their cold data on S3 to reduce costs but still be able to query it using the same SQL interface alongside their hot data. Which feature should they use?
An organization is migrating their 500 TB of data to Amazon Redshift. They want to ensure they don't go over budget and want a deterministic price for their analytical workload. What is the most effective approach?