DBS-C01 Monitoring and Troubleshooting Practice Question
A database specialist is troubleshooting a slow-running query on an Amazon Aurora MySQL DB cluster. The query performs a large table scan. Which THREE actions would likely improve query performance?
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
✓
Increase the size of the DB instance to provide more memory and CPU.
Creating appropriate indexes can speed up queries by avoiding table scans. Increasing the instance size provides more memory and CPU for query execution. Enabling query caching can store results of repeated queries. Changing isolation level and enabling parallel query may not help in all cases and may have side effects.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Increase the size of the DB instance to provide more memory and CPU.
Why this is correct
More resources can speed up query execution.
- ✗
Change the transaction isolation level to SERIALIZABLE.
Why it's wrong here
SERIALIZABLE adds overhead and does not improve performance.
- ✓
Enable the query cache feature to cache the results of the query.
Why this is correct
Query caching can improve performance for repeated identical queries.
- ✗
Enable Aurora Parallel Query to parallelize the table scan.
Why it's wrong here
Parallel Query is not automatically beneficial and may require specific conditions.
- ✓
Create an index on columns used in WHERE and JOIN clauses.
Why this is correct
Indexes reduce the need for full table scans.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DBS-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 DBS-C01 exam.