When configuring a Database Collector for a MySQL database, which of the following must be specified?

The database server's hostname and port

The operating system of the database server

An administrator is configuring a Database Collector for a SQL Server database. The 'Test Connection' succeeds, but the collector fails to collect data, and the logs show an error about 'permission denied' on a specific system view. What is the most likely cause?

The database is not in a supported compatibility level.

The JDBC driver is not compatible with SQL Server 2019.

The database user does not have the VIEW SERVER STATE permission.

The collection interval is set too low.

Which of the following best describes how a Database Collector is configured in AppDynamics?

By installing an agent on the database server

By defining connection details, credentials, and collection intervals in the Controller

By editing a configuration file on the database server

By enabling a built-in feature in the database management system

A company is monitoring a critical Oracle database that is only accessible from a specific subnet. The AppDynamics Database Agent is installed on a host in that subnet. The administrator has configured the collector with the correct hostname, port, and credentials. The 'Test Connection' fails with 'IO Error: The Network Adapter could not establish the connection'. What is the most likely cause?

The collection interval is set too low.

The JDBC driver is not compatible with the Oracle version.

The database user's password is incorrect.

The database is configured to listen on a different port than the one specified.

What is the primary purpose of a Database Collector in AppDynamics?

To store database backups and manage recovery procedures

To automatically fix performance issues in the database

To collect and report metrics from a database server for performance monitoring

To replace the database's native monitoring tools

CiscoAppDynamics Associate Administrator

Domain 3Objective 5

3.5 Define, Configure, and Test Database Collectors APPDYNAMICS-ASSOCIATE-ADMINISTRATOR Practice Questions (Page 1)

Part of the Data Collectors domain, which accounts for 20% of the APPDYNAMICS-ASSOCIATE-ADMINISTRATOR exam. Cisco does not publish an official question count, but from its 90-minute exam (~35–60 total, ~7–12 in this domain), expect 1–2 from this objective — we provide 16 practice questions to prepare you well beyond it. (estimate)

16questions here

4free pages

3concepts

20%of the exam

Questions 1–5

1foundation · easy
When configuring a Database Collector for a MySQL database, which of the following must be specified?
Select an answer first
2expert · hard
An administrator is configuring a Database Collector for a SQL Server database. The 'Test Connection' succeeds, but the collector fails to collect data, and the logs show an error about 'permission denied' on a specific system view. What is the most likely cause?
Select an answer first
3foundation · easy
Which of the following best describes how a Database Collector is configured in AppDynamics?
Select an answer first
4expert · hard
A company is monitoring a critical Oracle database that is only accessible from a specific subnet. The AppDynamics Database Agent is installed on a host in that subnet. The administrator has configured the collector with the correct hostname, port, and credentials. The 'Test Connection' fails with 'IO Error: The Network Adapter could not establish the connection'. What is the most likely cause?
Select an answer first
5foundation · easy
What is the primary purpose of a Database Collector in AppDynamics?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to APPDYNAMICS-ASSOCIATE-ADMINISTRATOR

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Cisco. “APPDYNAMICS-ASSOCIATE-ADMINISTRATOR” is a trademark of its owner, used for identification only.