What is most likely the primary concern of a database administrator experiencing increased response times during peak hours?

• A. Data redundancy
• B. Concurrent connections
• C. Index fragmentation
• D. Backup frequency

Answer: (B)

Increased response times during peak hours are often linked to the load that concurrent connections place on the database system. When multiple users or applications access the database simultaneously, they compete for system resources, such as CPU, memory, and I/O operations. This contention can lead to delays in processing queries and transactions, resulting in longer response times.

A database administrator would prioritize addressing concurrent connections when faced with performance issues during high-traffic periods. Optimizing the database to handle more concurrent connections, implementing connection pooling, or adjusting resource allocation are common strategies that can mitigate the impact of these simultaneous requests.

While data redundancy, index fragmentation, and backup frequency can affect overall database performance and efficiency, they are less directly correlated with immediate response time during peak usage. Addressing these issues would typically be considered part of ongoing database management rather than immediate solutions to response time problems during high demand.