Performance Analysis of DocumentDB Cluster | AWS Certified DBS-C01 Exam Prep
Question
A DocumentDB database specialist wants to examine the execution time of operations performed on the cluster to investigate slow operations.
What can the specialist use to perform this analysis?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: A.
Option A is CORRECT because the DocumentDB profiler feature can be enabled to log the details (including execution time) of MongoDB operations to CloudWatch Logs.
Then, CloudWatch Logs Insights can be used to analyze the data and investigate slow queries.
Option B is incorrect because AWS X-Ray is used for debugging and tracing requests in microservices applications.
Option C is incorrect because Performance Insights is a service specific to Amazon RDS.
Option D is incorrect because Inspector is a security assessment service, and not a DocumentDB performance analysis service.
Reference:
https://docs.aws.amazon.com/documentdb/latest/developerguide/profiling.htmlThe correct answer is C. Performance Insights.
Performance Insights is a feature offered by Amazon Relational Database Service (RDS) and Amazon Aurora that provides an easy way to detect performance problems with a database instance, such as slow running queries. It helps database administrators and developers identify the source of performance issues, analyze them, and take corrective actions.
Performance Insights provides a dashboard that shows the top SQL statements that consume resources, their associated hosts, and users. It also provides an execution plan that helps identify the bottlenecks in the SQL statement's execution. With this information, database administrators can optimize their database's performance by tuning the SQL statements that consume the most resources.
Performance Insights can be used with both Aurora and RDS, including Aurora with PostgreSQL compatibility, MySQL, MariaDB, Oracle, and SQL Server.
Option A, DocumentDB profiler, is not a valid feature of DocumentDB. Option B, AWS X-Ray, is a service that helps developers analyze and debug distributed applications, such as microservices, and not applicable for the given scenario. Option D, Amazon Inspector, is a security assessment service that helps in identifying security vulnerabilities in applications deployed on AWS, and not relevant for the given scenario.
