Dynatrace-Associate practice question 4 of 10

Your team has to investigate the performance of a database. Assuming all monitoring sources for a database are available, what tools can you use to find database performance information?

Full set: 82 questions
Answer options
A: Through provided dashboards from a database extension Correct answer
B: In the 'Databases' app Correct answer
C: By running synthetic tests against the database
D: Looking at service data for a specific database Correct answer
Correct Answer:
A. Through provided dashboards from a database extension; B. In the 'Databases' app; D. Looking at service data for a specific database
Explanation

Dynatrace provides multiple integrated tools for comprehensive database performance investigation.
1. The 'Databases' app (B) offers a centralized, environment-wide overview of all monitored database services, presenting key performance indicators like response time, failure rate, and throughput.
2. From this app or other service workflows, you can analyze the service data for a specific database (D), which allows for deep-dive analysis into individual SQL statements, response time hotspots, and failure details.
3. Additionally, many database extensions available on the Dynatrace Hub provide pre-configured dashboards (A) that visualize technology-specific metrics (e.g., tablespace usage, lock waits), offering another valuable perspective for performance analysis.

Why Incorrect

C. By running synthetic tests against the database: Synthetic tests are designed to simulate user interactions with application frontends or APIs, not to directly analyze the internal performance of a backend database.

References

1. Dynatrace Documentation, "Databases monitoring": This document describes the primary "Databases" page (the app) as the entry point for analysis. It states, "The Databases page provides an overview of all database services detected in your environment... To view the details of a specific database service, select the database service in the list." This confirms that both the 'Databases' app (B) and viewing the specific service data (D) are core parts of the workflow. (Source: Dynatrace Official Documentation, https://www.dynatrace.com/support/help/observe-and-explore/databases, Section: "Databases monitoring overview").

2. Dynatrace Documentation, "Extensions": The documentation for specific database extensions, such as the "Microsoft SQL Server" extension, explicitly mentions the inclusion of pre-configured dashboards. It notes, "The extension provides a preconfigured dashboard with the most important metrics." This validates that dashboards from extensions (A) are a tool for database performance investigation. (Source: Dynatrace Official Documentation, https://www.dynatrace.com/support/help/extend-dynatrace/extensions/extension-integrations/databases/microsoft-sql-server, Section: "Features").

3. Dynatrace Documentation, "Synthetic Monitoring": This section clarifies the purpose of synthetic tests, stating, "Synthetic Monitoring simulates user journeys... to proactively monitor the availability and performance of your applications." This confirms that its purpose is external application monitoring, not internal database analysis (C). (Source: Dynatrace Official Documentation, https://www.dynatrace.com/support/help/platform-modules/digital-experience/synthetic-monitoring, Section: "What is Synthetic Monitoring?").

Scroll to Top