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.