A data engineer is troubleshooting a performance issue in an Amazon RDS for PostgreSQL database. A large batch job is running during the day and is causing application queries to time out. The engineer discovers that the batch job is holding locks on several tables that the application needs to access. Which action should the data engineer take to minimize the impact of the batch job on the application?

Set the lock_timeout parameter to a lower value for the batch job

Increase the number of database instances

Use the pg_terminate_backend function to kill the batch job

Move the batch job to run during off-peak hours

Which vector index type is known for its hierarchical graph-based structure that provides efficient approximate nearest neighbor search?

HNSW (Hierarchical Navigable Small World)

A data engineering team needs to run complex queries that aggregate large volumes of data for business intelligence reports. Which storage configuration is best suited for this analytical access pattern?

Amazon Redshift with columnar storage

Amazon S3 with lifecycle policies

Amazon RDS with provisioned IOPS

Amazon DynamoDB with on-demand capacity

A data engineer needs to implement a vector search feature in an application that uses Aurora PostgreSQL. Which indexing method is specifically supported by Aurora PostgreSQL for efficient vector similarity search?

HNSW (Hierarchical Navigable Small World)

GIN (Generalized Inverted Index)

AWSCertified Data Engineer - Associate

Domain 2Objective 1

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

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 6–10

6foundation · easy
Which vector index type partitions the vector space into clusters to speed up similarity search by only searching a subset of vectors?
Select an answer first
7application · medium
A data engineer is troubleshooting a performance issue in an Amazon RDS for PostgreSQL database. A large batch job is running during the day and is causing application queries to time out. The engineer discovers that the batch job is holding locks on several tables that the application needs to access. Which action should the data engineer take to minimize the impact of the batch job on the application?
Select an answer first
8foundation · easy
Which vector index type is known for its hierarchical graph-based structure that provides efficient approximate nearest neighbor search?
Select an answer first
9foundation · easy
A data engineering team needs to run complex queries that aggregate large volumes of data for business intelligence reports. Which storage configuration is best suited for this analytical access pattern?
Select an answer first
10foundation · easy
A data engineer needs to implement a vector search feature in an application that uses Aurora PostgreSQL. Which indexing method is specifically supported by Aurora PostgreSQL for efficient vector similarity search?
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 2)

Questions 6–10

Which vector index type partitions the vector space into clusters to speed up similarity search by only searching a subset of vectors?

Which vector index type is known for its hierarchical graph-based structure that provides efficient approximate nearest neighbor search?

A data engineering team needs to run complex queries that aggregate large volumes of data for business intelligence reports. Which storage configuration is best suited for this analytical access pattern?

A data engineer needs to implement a vector search feature in an application that uses Aurora PostgreSQL. Which indexing method is specifically supported by Aurora PostgreSQL for efficient vector similarity search?

Keep studying — Content Domain 2: Data Store Management