Data World 5 · Warehouse and Scale · Stage 4

Query in Place

Query the lake, the operational database, the analysts' view and the stream without loading, copying or waiting.

  • Redshift Spectrum
  • Zero-ETL integrations
  • Federated query
  • Views and materialized views
  • Streaming ingestion
  • Serverless or provisioned
Domain
Data engineering
World
Data World 5: Warehouse and Scale (Associate)
Game type
Solution board: Drop services into each row's slots, then run records through them.
Time
About 25 minutes on a first attempt (estimated)
Exam guides
  • DEA-C01Skill 2.1.5: Implement data migration or remote access methods (for example, Amazon Redshift federated queries, Amazon Redshift materialized views, Amazon Redshift Spectrum); Skill 3.2.3: Use SQL in Amazon Redshift and Athena to query data or to create views; Skill 3.2.5: Describe tradeoffs between provisioned services and serverless services; Skill 1.2.3: Integrate data from multiple sources; Skill 1.1.1: Read data from streaming sources (for example, Amazon Kinesis, Amazon Managed Streaming for Apache Kafka [Amazon MSK], Amazon DynamoDB Streams, AWS DMS, AWS Glue, Amazon Redshift); Skill 3.2.1: Visualize data by using AWS services and tools (for example, DataBrew, Amazon QuickSight); Skill 3.2.4: Use Athena notebooks that use Apache Spark to explore data; Skill 3.2.6: Define data aggregation, rolling average, grouping, and pivoting; Skill 1.2.8: Create data APIs to make data available to other systems by using AWS services