Redshift must query files in S3 without loading them. What do you use?
Why A is the answer
Redshift Spectrum
Spectrum queries external tables in S3.
In detail
- Redshift Spectrum queries S3 files with no loading.
- External tables use a catalog.
Use case
An illustrative scenario, not a real incident.
Old logs stay in S3, and Spectrum joins them with Redshift tables, with no load.
See it in different ways
flowchart LR A["Data in S3"] --> B["Glue crawler"] B --> C["Glue Data Catalog"] C --> D["Athena"] C --> E["Redshift Spectrum"]
mindmap
root((Stores))
Redshift
Complex analytics
DynamoDB
Fast key lookups
S3
Data lake
Athena
SQL on S3sequenceDiagram participant P0 as Analyst participant P1 as Amazon Redshift participant P2 as S3 external table P0->>P1: Query P1->>P2: Scan P2-->>P0: Result
Key point: Spectrum queries S3 from Redshift.
Why the other options are wrong
- B. S3 Object Lock
- Object Lock prevents deletion.
- C. AWS Backup
- AWS Backup protects data.
- D. Amazon SQS
- SQS is a queue.