SK0-004 · Question #42
Which of the following are required characteristics of database servers in high transaction environments? (Select THREE).
The correct answer is B. High bandwidth C. Higher RPM drives D. Load balancing. High-transaction database servers require hardware and architecture that maximizes throughput, I/O speed, and request distribution.
Question
Which of the following are required characteristics of database servers in high transaction environments? (Select THREE).
Options
- ATwo-factor authentication
- BHigh bandwidth
- CHigher RPM drives
- DLoad balancing
- EHigh latency
- FHotswappable drives
- GEncryption
How the community answered
(42 responses)- A2% (1)
- B76% (32)
- E7% (3)
- F12% (5)
- G2% (1)
Why each option
High-transaction database servers require hardware and architecture that maximizes throughput, I/O speed, and request distribution.
Two-factor authentication is a security control for user access and has no direct impact on database transaction throughput or performance.
High bandwidth ensures the server can move large volumes of data between clients, application servers, and storage quickly, preventing I/O bottlenecks during peak transaction loads.
Higher RPM drives (e.g., 15,000 RPM SAS) deliver faster seek times and data transfer rates, which directly reduces disk I/O latency critical to transaction processing performance.
Load balancing distributes incoming database transactions across multiple servers or nodes, preventing any single server from becoming a bottleneck and improving overall throughput and availability.
High latency is a negative performance characteristic - high-transaction environments require low latency, not high latency, to process requests quickly.
Hot-swappable drives improve hardware availability and reduce downtime during drive replacement but do not directly enhance transaction processing performance.
Encryption adds computational overhead and can reduce performance; it is a security feature, not a required performance characteristic for high-transaction environments.
Concept tested: Hardware requirements for high-transaction database servers
Source: https://learn.microsoft.com/en-us/sql/relational-databases/performance/performance-center-for-sql-server-database-engine-and-azure-sql-database
Topics
Community Discussion
No community discussion yet for this question.