500-425 Exam Dumps : Cisco AppDynamics Associate Administrator (CAAA)

To properly configure a database agent from a zip file, you need to provide the following minimum details:

• Controller Host: This is the hostname or IP address of the machine where the Controller is installed. You need to specify this so that the Database Agent can communicate with the Controller and send the collected data1
• Controller Port: This is the port number that the Controller listens on for incoming connections. You need to specify this so that the Database Agent can connect to the Controller using the correct protocol. The default ports are 8090 for HTTP and 8181 for HTTPS for on-premise Controllers, and 80 for HTTP and 443 for HTTPS for SaaS Controllers1
• Account Access Key: This is the key that authenticates the Database Agent with the Controller. You need to specify this so that the Database Agent can register itself with the Controller and access the license. You can find the account access key in the Controller UI under Settings > License > Account1
• Account Name: This is the name of the account that the Database Agent belongs to. You need to specify this so that the Database Agent can associate itself with the correct application and user permissions. You can find the account name in the Controller UI under Settings > License > Account1

References: 1: Install the Database Agent

Database Visibility provides metrics on the performance of your database and helps troubleshoot performance-related issues. Database Visibility consists of four main components: Database Agent, Collector, Controller, and Events Service (on-premises only). The Database Agent is a standalone Java program that collects performance metrics about your database instances and database servers. The Collector is the process that runs within the Database Agent to collect performance metrics about your database instances and database servers. The Controller is the central interface where you can see all your database instances and database server performance metrics. The Events Service stores high volumes of metric data.

According to the Overview of Database Visibility, the following types of information are sent to the Controller:

• Database-level metrics, such as the number of queries processed and other database statistics
• Names and attributes of all sessions, clients, queries, and other objects on the monitored system

The following types of information are sent to the Events Service:

• Time that each query spends at each wait state
• Individual query statistics for databases that support it
• Information about individual execution plans in databases that support it

Therefore, B (Average Number of Slow Connections) and C (Top Leaked Connections) are two stats that are available in Database Visibility. References:

• Cisco AppDynamics Associate Administrator Certification
• Overview of Database Visibility - AppDynamics
• Database Visibility - AppDynamics

Before creating a new database collector, you need to perform the following actions:

• Verify the database connection details. You need to provide the host, port, database name, and credentials for the database that you want to monitor. You also need to select the database type and the collector type1
• Create a database user and set user permissions. You need to create a database user with the minimum required permissions to access the database and run the queries that the Database Agent needs. You can use the scripts provided by AppDynamics to create the user and grant the permissions2

References: 1: Add Database Collectors 2: Database Permissions