AWSCertified Data Engineer - Associate
Domain 2Objective 1
Task 2.1: Choose a Data Store DEA-C01 Practice Questions (Page 5)
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 21–23
- 21
A team of data analysts runs concurrent queries on an Amazon Redshift cluster. Occasionally, one analyst's long-running query blocks other queries from accessing the same table, causing timeouts. The data engineer needs to reduce the impact of long-running queries on other users without changing the query logic. Which configuration should the data engineer implement?
Select an answer first - 22
In Amazon RDS for PostgreSQL, which mechanism is used to prevent concurrent transactions from interfering with each other and ensure data consistency?
Select an answer first - 23
A data engineering team needs to transfer large files from an on-premises SFTP server to Amazon S3 as part of a data processing pipeline. Which AWS service is designed to integrate with SFTP for this purpose?
Select an answer first
Finished these 3 questions?
Review the revealed explanations, or continue through the curriculum.
No more pagesBack 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.