AWS Certified Database – Specialty — Question 194

A company is using Amazon DocumentDB (with MongoDB compatibility) to manage its complex documents. Users report that an Amazon DocumentDB cluster takes a long time to return query results. A database specialist must investigate and resolve this issue.

Which of the following can the database specialist use to investigate the query plan and analyze the query performance?

Answer options

• A. AWS X-Ray deep linking
• B. Amazon CloudWatch Logs Insights
• C. MongoDB explain() method
• D. AWS CloudTrail with a custom filter

Correct answer: C

Explanation

The MongoDB explain() method is specifically designed to provide detailed information about how a query is executed, which helps in analyzing its performance. The other options, while useful for different types of monitoring and logging, do not specifically analyze query plans or performance in Amazon DocumentDB.