A company is ingesting log data into Amazon S3. To reduce storage costs and improve query performance, the data should be stored in a columnar format and partitioned by date. Which configuration should be used for the S3 objects?

Store data as Parquet and partition by date

Store data as compressed CSV without partitioning

Store data as CSV and partition by date

Store data as JSON and do not partition

A company needs to run a complex ETL job that processes 10 TB of data daily. The job involves custom transformations that require specific Java libraries not available in AWS Glue's built-in environment. The company wants to minimize cost and management overhead while ensuring the job completes within a 4-hour window. Which solution should the company use?

Use AWS Glue with a custom Python shell job that includes the required Java libraries as dependencies.

Use AWS Lambda with a custom runtime that includes the required Java libraries.

Use AWS Glue with an Apache Spark ETL job and include the Java libraries in the job's Python shell script.

Use Amazon EMR with a transient cluster and a custom bootstrap action to install the required Java libraries.

A company is setting up an ingestion pipeline that sends data to Amazon S3. The security team requires that data be encrypted at rest in S3. Which AWS feature can be used to meet this requirement?

S3 server-side encryption (SSE)

AWS Identity and Access Management (IAM) policies

AWSCertified Solutions Architect - Associate

Domain 3Objective 5

Task 3.5: Determine High-Performing Data Ingestion and Transformation Solutions SAA-C03 Practice Questions (Page 2)

Part of the Design High-Performing Architectures domain, which makes up ~30% of our current practice bank. AWS does not publish an official question count, but from its 130-minute exam (~50–85 total, ~15–26 in this domain), expect 3–5 from this objective — we provide 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

14concepts

14 Concepts in This Objective

Data analytics and visualization services
Data ingestion patterns
Data transfer services
Data transformation services
Secure access to ingestion access points
Sizing and throughput planning
Streaming data services
Building and securing data lakes
Designing data streaming architectures
Designing data transfer solutions
Implementing visualization strategies
Selecting compute options for data processing
Selecting configurations for ingestion
Transforming data between formats

Questions 6–10

6foundation · easy
A company is ingesting log data into Amazon S3. To reduce storage costs and improve query performance, the data should be stored in a columnar format and partitioned by date. Which configuration should be used for the S3 objects?
Select an answer first
7foundation · easy
A data engineering team needs to run a large-scale Apache Spark job that processes 50 TB of data. The job requires fine-grained control over cluster configuration, including instance types and spot instances to reduce cost. Which AWS service is best suited for this workload?
Select an answer first
8foundation · easy
A company expects to ingest 5 TB of data per day, and the ingestion window is 8 hours. What is the required average transfer rate in GB per hour? (1 TB = 1000 GB)
Select an answer first
9expert · hard
A company needs to run a complex ETL job that processes 10 TB of data daily. The job involves custom transformations that require specific Java libraries not available in AWS Glue's built-in environment. The company wants to minimize cost and management overhead while ensuring the job completes within a 4-hour window. Which solution should the company use?
Select an answer first
10foundation · easy
A company is setting up an ingestion pipeline that sends data to Amazon S3. The security team requires that data be encrypted at rest in S3. Which AWS feature can be used to meet this requirement?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SAA-C03

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by AWS. “SAA-C03” is a trademark of its owner, used for identification only.

Task 3.5: Determine High-Performing Data Ingestion and Transformation Solutions SAA-C03 Practice Questions (Page 2)

Questions 6–10

A company is ingesting log data into Amazon S3. To reduce storage costs and improve query performance, the data should be stored in a columnar format and partitioned by date. Which configuration should be used for the S3 objects?

A data engineering team needs to run a large-scale Apache Spark job that processes 50 TB of data. The job requires fine-grained control over cluster configuration, including instance types and spot instances to reduce cost. Which AWS service is best suited for this workload?

A company expects to ingest 5 TB of data per day, and the ingestion window is 8 hours. What is the required average transfer rate in GB per hour? (1 TB = 1000 GB)

A company is setting up an ingestion pipeline that sends data to Amazon S3. The security team requires that data be encrypted at rest in S3. Which AWS feature can be used to meet this requirement?

Keep studying — Design High-Performing Architectures