A company runs an Amazon Redshift cluster for its data warehouse. The data engineering team frequently runs the same aggregation queries on the same underlying data. The queries are complex and take several minutes to complete. The team wants to reduce query latency and reduce the load on the Redshift cluster. Which feature should the data engineer implement?

Use Redshift federated queries to query the source data directly

Create Redshift materialized views for the frequent aggregation queries

Use Redshift Spectrum to offload the queries to Amazon S3

Enable Redshift concurrency scaling

AWSCertified Data Engineer - Associate

Domain 2Objective 1

Task 2.1: Choose a Data Store DEA-C01 Practice Questions (Page 4)

Part of the Content Domain 2: Data Store Management domain, which accounts for 26% of the DEA-C01 exam. AWS does not publish an official question count, but from its 130-minute exam (~50–85 total, ~13–22 in this domain), expect 3–6 from this objective — we provide 23 practice questions to prepare you well beyond it. (estimate)

23questions here

5free pages

8concepts

26%of the exam

Questions 16–20

16expert · hard
A company runs an Amazon Redshift cluster for its data warehouse. The data engineering team frequently runs the same aggregation queries on the same underlying data. The queries are complex and take several minutes to complete. The team wants to reduce query latency and reduce the load on the Redshift cluster. Which feature should the data engineer implement?
Select an answer first
17foundation · easy
A data engineer needs to support a high volume of small, frequent read and write transactions for an online application. Which access pattern does this represent, and which AWS service is best suited?
Select an answer first
18foundation · easy
In Amazon Redshift, which type of lock is used to prevent concurrent write operations from conflicting with each other on the same table?
Select an answer first
19foundation · easy
A data engineering team wants to implement a data lakehouse architecture that allows multiple query engines to access the same data with transactional consistency. Which open table format is designed for this purpose?
Select an answer first
20foundation · easy
A data engineer needs to query data that resides in an Amazon S3 data lake directly from an Amazon Redshift cluster without loading the data into Redshift. Which feature enables this?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DEA-C01

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. “DEA-C01” is a trademark of its owner, used for identification only.

Task 2.1: Choose a Data Store DEA-C01 Practice Questions (Page 4)

Questions 16–20

A data engineer needs to support a high volume of small, frequent read and write transactions for an online application. Which access pattern does this represent, and which AWS service is best suited?

In Amazon Redshift, which type of lock is used to prevent concurrent write operations from conflicting with each other on the same table?

A data engineering team wants to implement a data lakehouse architecture that allows multiple query engines to access the same data with transactional consistency. Which open table format is designed for this purpose?

A data engineer needs to query data that resides in an Amazon S3 data lake directly from an Amazon Redshift cluster without loading the data into Redshift. Which feature enables this?

Keep studying — Content Domain 2: Data Store Management