Home / SAA-C03 / Objective 3.5

Domain 3: Design High-Performing Architectures · 24% of the exam · Full exam outline

3.5 Determine high-performing data ingestion and transformation solutions

What this objective covers · 5% of the exam

Data analytics and visualization services with appropriate use cases (for example, Amazon Athena, AWS Lake Formation, Amazon Quick); Data ingestion patterns (for example, frequency); Data transfer services with appropriate use cases (for example, AWS DataSync, AWS Storage Gateway); Data transformation services with appropriate use cases (for example, AWS Glue); Secure access to ingestion access points; Sizes and speeds needed to meet business requirements; Streaming data services with appropriate use cases (for example, Amazon Kinesis); Building and securing data lakes; Designing data streaming architectures; Designing data transfer solutions; Implementing visualization strategies; Selecting appropriate compute options for data processing (for example, Amazon EMR); Selecting appropriate configurations for ingestion; Transforming data between formats (for example, .csv to .parquet)

Practice questions

Question 1easy

A retailer keeps three years of sales logs in Amazon S3 as CSV files and queries them with Amazon Athena. The queries read far more data than they need and run slowly. The team wants to rewrite the existing files into a columnar format with SQL statements in the service it already uses, without building a new ingestion pipeline. What should it do?

Included in Master: master every domain.See plans
Question 2easy

Analysts want to run ad hoc SQL against CSV and Parquet files already stored in S3. They want to pay only for the queries they run, with no servers or clusters to set up. Which service fits?

Included in Master: master every domain.See plans