Download PrepIQ SolarWinds Database Performance Analyzer Ultimate Exam and more Exams Technology in PDF only on Docsity!
Performance Analyzer Ultimate Exam
Question 1. Which operating system is NOT officially supported for installing SolarWinds Database Performance Analyzer (DPA) server? A) Windows Server 2019 B) Red Hat Enterprise Linux 8 C) Ubuntu 22.04 LTS D) macOS Catalina Answer: D Explanation: DPA is designed for Windows and major Linux/Unix distributions; macOS is not a supported platform for the DPA server. Question 2. What is the minimum amount of RAM recommended for a DPA server monitoring up to 10 instances? A) 4 GB B) 8 GB C) 16 GB D) 32 GB Answer: B Explanation: For modest environments (≤10 instances), 8 GB RAM provides sufficient headroom for the web UI, repository, and data collection agents. Question 3. Which database engine can be used as the DPA repository on a Linux host? A) Microsoft SQL Server Express B) Oracle Database 19c C) MySQL 8.
Performance Analyzer Ultimate Exam
D) IBM Db Answer: C Explanation: MySQL is a supported repository on Linux; SQL Server Express is Windows-only, Oracle requires Windows or Linux but is less common, and Db2 is not supported. Question 4. Which network port is used by the DPA web client for HTTPS traffic by default? A) 8123 B) 8124 C) 443 D) 8443 Answer: B Explanation: Port 8124 is the default HTTPS port for the DPA web interface, while 8123 is the default HTTP port. Question 5. When deploying DPA in Amazon EC2, which licensing model is most appropriate for a perpetual on-premise-like usage? A) Category 1 license B) Category 2 license C) Azure SQL Database license D) VM option license Answer: A Explanation: Category 1 licenses are perpetual and can be used on any virtual or physical server, including EC2 instances.
Performance Analyzer Ultimate Exam
D) Uninstall the old DPA web client Answer: C Explanation: A full repository backup ensures you can roll back if the upgrade encounters issues. Question 9. Which RBAC role in DPA has permission to create and edit custom alerts but cannot view query text? A) Administrator B) User Manager C) Read-Only D) Custom (Alert-Only) Answer: D Explanation: A custom role can be crafted to allow alert management while restricting access to sensitive SQL statements. Question 10. How does DPA authenticate users when integrated with Active Directory? A) By storing AD passwords locally in the DPA database B) Using Kerberos tickets for single sign-on C) By prompting for a second factor code on every login D) It does not support AD integration Answer: B Explanation: DPA can use Kerberos tickets to provide seamless AD single sign-on.
Performance Analyzer Ultimate Exam
Question 11. Which configuration enables encrypted communication between the DPA web client and the repository database? A) Enabling “Secure Mode” in the web UI B) Configuring SSL/TLS on the database listener and the DPA server C) Setting the “EncryptData” flag in the DPA config file D) Using VPN tunnels only Answer: B Explanation: SSL/TLS must be enabled on both the DB listener and the DPA server to encrypt traffic. Question 12. The “Find SQL” feature in DPA primarily helps users to: A) Locate stored procedures that have not run in the last 30 days B) Search for specific query text across all monitored instances C) Identify deadlocked transactions automatically D) Export the entire query history to Excel Answer: B Explanation: “Find SQL” allows users to enter text strings or regex patterns to locate matching statements. Question 13. When creating a SQL List in DPA, which action prevents a specific query from being collected? A) Adding the query to the “Exclusion” list B) Tagging the query with a “Low-Priority” label C) Setting the “Collect Frequency” to zero seconds D) Renaming the query in the database
Performance Analyzer Ultimate Exam
B Redo log write performance C Buffer cache size D Cursor sharing Answer: B Explanation: “log_file_sync” measures the time a session waits for redo log writes to complete. Question 17. DPA’s anomaly detection feature relies on which technique? A) Rule-based threshold alerts B) Simple moving average calculations C) Machine-learning models trained on historic wait-time data D) Manual tagging by administrators Answer: C Explanation: The feature uses ML to learn normal patterns and flags deviations. Question 18. The Query Tuning Advisor in DPA can suggest which of the following improvements? A) Adding a missing index B) Changing the database collation C) Upgrading the OS kernel version D) Re-installing DPA Answer: A Explanation: The advisor analyzes query execution plans and recommends index creation when beneficial.
Performance Analyzer Ultimate Exam
Question 19. Which metric would you examine to determine if a table’s design is causing high I/O? A) CPU usage per core B) Buffer cache hit ratio C) Page reads per second for that table’s filegroup D) Number of active connections Answer: C Explanation: Elevated page reads for a specific filegroup often indicate table-level I/O inefficiencies. Question 20. In DPA, the “Blocking” tab helps you identify: A) The longest-running queries only B) Sessions that are causing other sessions to wait for locks C) Network packet loss between the DPA server and instances D) Disk fragmentation on the repository server Answer: B Explanation: The Blocking view surfaces lead blocker sessions and the sessions they block. Question 21. Which of the following is NOT a typical source of “deadlock graphs” in DPA? A) Two sessions each holding a lock the other needs B) A single session requesting a lock it already holds C) Cyclic lock dependencies across multiple tables
Performance Analyzer Ultimate Exam
Question 24. To suppress alerts during a planned maintenance window, you would use: A) Alert throttling B) Blackout scheduling C) Alert escalation rules D) Notification muting Answer: B Explanation: Blackouts temporarily disable alert generation for the defined period. Question 25. Which protocol does DPA use to send SNMP traps to third-party monitoring tools? A) SNMPv1 only B) SNMPv2c only C) SNMPv3 only D) Any SNMP version configured in the DPA settings Answer: D Explanation: DPA can be configured to use SNMPv1, v2c, or v3 based on the environment’s security requirements. Question 26. The “Top SQL” standard report primarily displays: A) The queries with the highest CPU consumption over a selected period B) All queries executed in the last 24 hours sorted alphabetically C) Queries that have never been optimized D) The most frequently executed stored procedures only
Performance Analyzer Ultimate Exam
Answer: A Explanation: The Top SQL report ranks statements by resource consumption, typically CPU or wait time. Question 27. When building a custom report for the finance department, which DPA feature allows you to schedule automatic delivery? A) Reporting Groups B) Alert Templates C) API Push D) Data Export Wizard Answer: A Explanation: Reporting Groups let you associate reports with a schedule and recipient list. Question 28. DPAIM (DPA Integration Module) is used to: A) Export DPA data to CSV files automatically B) Push DPA metrics into the SolarWinds Orion Web Console for unified dashboards C) Perform automatic schema migrations for the repository D) Enable remote API access without authentication Answer: B Explanation: DPAIM integrates DPA data into Orion, allowing cross-layer visibility. Question 29. Which SolarWinds product provides full-stack visibility that can consume DPA metrics alongside application performance data?
Performance Analyzer Ultimate Exam
Explanation: DPA issues API tokens that must be supplied in the Authorization header for API access. Question 32. To automate the creation of a new monitored instance via script, which DPA API endpoint would you use? A) /instances/register B) /repositories/create C) /alerts/trigger D) /users/add Answer: A Explanation: The /instances/register endpoint registers a new database instance for monitoring. Question 33. When integrating DPA with VMware, the “noisy neighbor” issue refers to: A) A VM that consumes excessive CPU, memory, or storage I/O, affecting other VMs’ database performance B) A VM that generates too many log files for DPA to ingest C) A VM that runs an unsupported version of the OS D) A VM that blocks SNMP traffic Answer: A Explanation: “Noisy neighbor” describes a VM whose resource consumption degrades the performance of co-located workloads. Question 34. Which of the following is NOT a mandatory permission for the DPA service account to create the repository database?
Performance Analyzer Ultimate Exam
A) CREATE DATABASE
B) ALTER ANY LOGIN
C) SELECT on sys.tables D) INSERT on the repository schema tables Answer: B Explanation: ALTER ANY LOGIN is not required for repository creation; the service account needs CREATE DATABASE and rights on the repository schema. Question 35. What is the purpose of the “Repository Disk Space” administrative alert? A) To notify when the DPA web UI cache exceeds 70 % B) To warn when the underlying storage for the DPA repository is nearing capacity C) To indicate that the DPA instance has reached the maximum number of monitored databases D) To flag excessive CPU usage by the DPA collector service Answer: B Explanation: This alert monitors the physical storage used by the repository database. Question 36. In DPA, the “Wait Time” metric is calculated as: A) Total CPU time spent executing the query B) Time from query submission to the moment the first row is returned, including all wait events C) Duration of the query’s compilation phase only D) Time the query spends in the transaction log buffer
Performance Analyzer Ultimate Exam
Question 39. Which of the following is a valid reason to use a custom role with “Read-Only” privileges for a compliance auditor? A) To allow the auditor to modify alert thresholds B) To let the auditor view query text but not change any configuration C) To enable the auditor to add annotations to charts D) To permit the auditor to delete old performance data Answer: B Explanation: Read-Only roles grant visibility into queries without permitting configuration changes. Question 40. When configuring SSL/TLS for DPA, which file must be placed on the DPA server to enable HTTPS? A) dpa.key.pem B) dpa.crt.pem (or .pfx) C) dpa.config.xml D) dpa.dbbackup.sql Answer: B Explanation: The certificate file (CRT or PFX) is required for the web server to negotiate HTTPS. Question 41. Which DPA feature allows you to view performance trends over the past 30 days for a specific wait type? A) Trend Report B) Live Dashboard C) Blocking Graph
Performance Analyzer Ultimate Exam
D) Annotation Timeline Answer: A Explanation: The Trend Report aggregates historical wait-time data across the selected period. Question 42. If a DPA instance shows “No data collected” for a newly added SQL Server, the most likely cause is: A) The server’s firewall blocks port 8123/ B) The DPA collector service is not running on the target host C) The repository database is out of disk space D) The DPA web UI cache is corrupted Answer: B Explanation: Data collection requires the DPA collector service; if it is stopped, no metrics are gathered. Question 43. When creating a custom alert that triggers on a specific query’s wait time exceeding 5 seconds, which DPA component do you configure? A) Alert Templates → SQL Alert B) Reporting Groups → Custom Report C) User Management → Role Assignment D) Integration → DPAIM Answer: A Explanation: SQL Alerts let you define thresholds based on individual query wait times.
Performance Analyzer Ultimate Exam
D) It provides a “Create Index” script for the DBA. Answer: B Explanation: The advisor only suggests changes; it never applies them automatically. Question 47. To ensure DPA alerts are sent to a Microsoft Teams channel, you must: A) Install a Teams plug-in from the SolarWinds Marketplace B) Configure an SMTP relay that forwards messages to Teams via an incoming webhook C) Use the DPA API to post directly to Teams D) Set the “Teams Notification” toggle in DPA settings Answer: B Explanation: Teams can receive email via its email address; configuring SMTP to forward alerts achieves this. Question 48. Which metric would you examine to determine if a database server is CPU-starved? A) Wait time for LCK_M_X B) CPU usage per core on the host OS C) Disk queue depth D) Number of active sessions Answer: B Explanation: High CPU utilization on the host indicates CPU contention.
Performance Analyzer Ultimate Exam
Question 49. When DPA is deployed on Azure, which licensing option aligns with Azure’s consumption-based billing? A) Category 1 license B) Category 2 license C) Azure SQL Database license (pay-as-you-go) D) VM option license Answer: C Explanation: Azure SQL Database licensing ties directly to Azure’s consumption model. Question 50. Which DPA component is responsible for gathering metrics from the operating system (CPU, memory, I/O) on the monitored host? A) Web UI Engine B) Collector Service (dpaagent) C) Repository Scheduler D) Alert Dispatcher Answer: B Explanation: The collector agent runs on each monitored host and gathers both DB and OS metrics. Question 51. What is the effect of enabling “Query Store” on a SQL Server instance that is already monitored by DPA? A) DPA stops collecting wait-time data for that instance B) DPA can correlate its wait-time data with Query Store’s execution statistics for deeper analysis
