A company is using Amazon Kinesis Data Firehose to deliver data to S3. To reduce the number of small files in S3 and improve query performance, which configuration should be set?

Increase the buffer size and buffer interval

Decrease the buffer size and buffer interval

A company needs to continuously replicate file changes from an on-premises file server to Amazon S3 for backup and disaster recovery. The solution should automate the transfer and handle incremental changes. Which AWS service is best suited for this continuous replication use case?

Amazon S3 Transfer Acceleration

AWS Storage Gateway (File Gateway)

A company stores IoT sensor data in Amazon S3 as JSON files. The data is queried frequently by a business intelligence team using Amazon Athena. The queries are slow and the team wants to improve query performance and reduce query costs. The data is append-only and does not need to be updated. Which solution should the company implement?

Use Amazon Redshift Spectrum to query the JSON files directly, and rely on Redshift's caching to improve performance.

Use Amazon EMR to convert the JSON files to CSV format and store the converted data in the same S3 bucket.

Use AWS Glue to convert the JSON files to Parquet format, partition the data by date, and store the converted data in a separate S3 bucket.

Use Amazon Athena to create a view that transforms the JSON data into a tabular format for queries.

A business analyst wants to create a dashboard in Amazon QuickSight that visualizes data from an Amazon Redshift cluster. What is the first step the analyst must take to connect QuickSight to Redshift?

Create a new Redshift cluster for QuickSight

Create an S3 bucket and upload the Redshift data

Create a data source in QuickSight and provide the Redshift connection details

Enable QuickSight in the Redshift console

AWSCertified Solutions Architect - Associate

Domain 3Objective 5

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

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 21–25

21foundation · easy
A company wants to ingest streaming data and automatically load it into Amazon S3 in near-real-time, with minimal setup and no need for consumers to manage the stream. Which AWS service is best suited for this?
Select an answer first
22foundation · easy
A company is using Amazon Kinesis Data Firehose to deliver data to S3. To reduce the number of small files in S3 and improve query performance, which configuration should be set?
Select an answer first
23foundation · easy
A company needs to continuously replicate file changes from an on-premises file server to Amazon S3 for backup and disaster recovery. The solution should automate the transfer and handle incremental changes. Which AWS service is best suited for this continuous replication use case?
Select an answer first
24application · medium
A company stores IoT sensor data in Amazon S3 as JSON files. The data is queried frequently by a business intelligence team using Amazon Athena. The queries are slow and the team wants to improve query performance and reduce query costs. The data is append-only and does not need to be updated. Which solution should the company implement?
Select an answer first
25foundation · easy
A business analyst wants to create a dashboard in Amazon QuickSight that visualizes data from an Amazon Redshift cluster. What is the first step the analyst must take to connect QuickSight to Redshift?
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 5)

Questions 21–25

A company wants to ingest streaming data and automatically load it into Amazon S3 in near-real-time, with minimal setup and no need for consumers to manage the stream. Which AWS service is best suited for this?

A company is using Amazon Kinesis Data Firehose to deliver data to S3. To reduce the number of small files in S3 and improve query performance, which configuration should be set?

A company needs to continuously replicate file changes from an on-premises file server to Amazon S3 for backup and disaster recovery. The solution should automate the transfer and handle incremental changes. Which AWS service is best suited for this continuous replication use case?

A business analyst wants to create a dashboard in Amazon QuickSight that visualizes data from an Amazon Redshift cluster. What is the first step the analyst must take to connect QuickSight to Redshift?

Keep studying — Design High-Performing Architectures