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

Questions 6–10

1. 6application · medium

   An administrator has just configured a new Database Collector for a SQL Server instance. The collector status shows 'Configuration Error'. What should the administrator do first to troubleshoot the issue?

   • ACheck the database server's firewall logs to see if the connection is being blocked.
   • BRun the 'Test Connection' feature from the Database Collector configuration page.
   • CVerify that the database is running by connecting with a SQL client.
   • DRestart the AppDynamics Machine Agent to force the collector to reload.
   Reveal Solution Discussion Select an answer first
2. 7expert · hard

   A company is monitoring a MongoDB database that is part of a replica set. The administrator wants to collect metrics from the primary node. The Database Agent is installed on a host that can reach all nodes. The collector is configured with the hostname of the primary node. The 'Test Connection' succeeds, but the collector shows an error after a few minutes. What is the most likely cause?

   • AThe primary node has changed due to a failover.
   • BThe collection interval is set too low.
   • CThe database user does not have the correct privileges.
   • DThe JDBC driver is not compatible with MongoDB.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A company uses AppDynamics to monitor an on-premises Oracle database. The DBA team wants to add a Database Collector, but they are concerned about security and want to avoid storing database credentials in plain text. The database is only accessible from within the corporate network. What should the administrator do?

   • ACreate a new database user with full administrative rights and use that for the collector.
   • BConfigure the Database Collector with a read-only account and use the AppDynamics Controller's credential vault to store the password.
   • CUse the database's superuser account and store the password in the collector configuration file.
   • DDisable authentication for the Database Collector to avoid storing any credentials.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A company is monitoring multiple Oracle databases. The administrator wants to use the same credentials for all collectors. What is the best way to manage these credentials in AppDynamics?

   • AStore the credentials in each collector's configuration file.
   • BUse a different set of credentials for each collector.
   • CCreate a single credential entry in the AppDynamics credential vault and reference it in each collector.
   • DHardcode the credentials in the JDBC URL.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A company wants to monitor a MongoDB database that is not directly accessible from the AppDynamics Machine Agent due to network restrictions. What is the recommended way to collect metrics from this database?

   • AEnable MongoDB's REST API and configure the collector to use it.
   • BConfigure a JDBC proxy to forward traffic to MongoDB.
   • CInstall a Database Agent on a host that can reach the MongoDB instance.
   • DUse the AppDynamics Controller to connect directly to MongoDB.
   Reveal Solution Discussion Select an answer first