DEA-C01 Data Operations and Support Practice Question
A company runs an Amazon Redshift cluster for data warehousing. The data engineering team notices that the 'Amazon Redshift Data API' is timing out when executing long-running queries. The queries typically take more than 10 minutes to complete. The team wants to ensure that the queries can complete without timeout and that the results are retrievable. Which TWO steps should the team take? (Choose TWO.)
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use the 'GetStatementResult' operation to retrieve results after the query completes.
Options C and E are correct. The Amazon Redshift Data API has a default timeout of 10 minutes for a single API call. To handle queries that take longer, you can run the query asynchronously by using the StatementName parameter (option E). This allows the query to continue running even if the initial API call times out, and you can poll for completion using the DescribeStatement operation. Once the query completes, you can retrieve the results using the GetStatementResult operation (option C). Option A is incorrect because QueryExecutionTimeout is not a valid parameter for the Data API. Option B is incorrect because increasing the timeout parameter in the Redshift cluster configuration does not affect the Data API timeout. Option D is incorrect because there is no max_execution_time parameter in Redshift; the relevant parameter is statement_timeout, which controls how long a query can run before being canceled, but it does not address the Data API timeout.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Set the 'QueryExecutionTimeout' parameter in the Data API call to 30 minutes.
Why it's wrong here
The Data API does not have a 'QueryExecutionTimeout' parameter.
- ✗
Increase the 'timeout' parameter in the Redshift cluster configuration.
Why it's wrong here
The cluster parameter 'timeout' does not affect the Data API timeout.
- ✓
Use the 'GetStatementResult' operation to retrieve results after the query completes.
Why this is correct
This is the correct way to get results after the statement finishes.
- ✗
Set the 'max_execution_time' parameter in the Redshift parameter group to 30 minutes.
Why it's wrong here
Redshift uses 'statement_timeout', not 'max_execution_time'.
- ✓
Use the 'StatementName' parameter to run the query asynchronously and poll for completion.
Why this is correct
This allows the query to run beyond the 10-minute API timeout.
Go deeper
Related to this question
About these practice questions
This DEA-C01 question is part of Courseiva's 1,711-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DEA-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DEA-C01 exam.