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

By:
In: DBS-C01
Tagged:
With: 2 Comments
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?

AWS X-Ray deep linking

Amazon CloudWatch Logs Insights

MongoDB explain() method

AWS CloudTrail with a custom filter

Explanations:

AWS X-Ray deep linking is used to trace and analyze requests across AWS services, but it is not specifically designed to investigate query performance in Amazon DocumentDB.

Amazon CloudWatch Logs Insights allows querying logs data, but it is not intended for analyzing query plans or performance directly in DocumentDB or MongoDB.

The MongoDBexplain()method is used to retrieve the query plan and performance details of MongoDB queries, which is also applicable to Amazon DocumentDB since it is MongoDB compatible.

AWS CloudTrail records API calls, which is useful for auditing, but it does not provide specific insights into query plans or performance of database queries.

2026-04-05

2 Comments

  1. Lauren
    Author

    I suspect that the answer is:
    MongoDB explain() method

  2. Ethan
    Author

    I outline that the answer is:
    MongoDB explain() method

Leave a Reply

Your email address will not be published. Required fields are marked *

three × 2 =