ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 278 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 278
Topic #: 1
[All AWS Certified Database - Specialty Questions]

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?

  • A. AWS X-Ray deep linking
  • B. Amazon CloudWatch Logs Insights
  • C. MongoDB explain() method
  • D. AWS CloudTrail with a custom filter
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Sab at Dec. 1, 2022, 2:39 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Pranava_GCP
1 year, 7 months ago
Selected Answer: C
C. MongoDB explain() method
upvoted 2 times
...
aviathor
1 year, 11 months ago
Selected Answer: C
explain() in order to retrieve the query plan, since that was the question...
upvoted 3 times
...
Sab
2 years, 4 months ago
Selected Answer: C
https://docs.aws.amazon.com/documentdb/latest/developerguide/user_diagnostics.html#user_diagnostics-query_plan
upvoted 4 times
...
Sab
2 years, 4 months ago
C If a query runs slow, it could be because the query execution requires a full scan of the collection to choose the relevant documents. Sometimes creating appropriate indexes enables the query to run faster. To detect this scenario and decide the fields on which to create the indexes, use the explain command. https://docs.aws.amazon.com/documentdb/latest/developerguide/user_diagnostics.html#user_diagnostics-query_plan
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago