nerdexam
CompTIA

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.

Server hardware installation and management

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)
  • A
    2% (1)
  • B
    76% (32)
  • E
    7% (3)
  • F
    12% (5)
  • G
    2% (1)

Why each option

High-transaction database servers require hardware and architecture that maximizes throughput, I/O speed, and request distribution.

ATwo-factor authentication

Two-factor authentication is a security control for user access and has no direct impact on database transaction throughput or performance.

BHigh bandwidthCorrect

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.

CHigher RPM drivesCorrect

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.

DLoad balancingCorrect

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.

EHigh latency

High latency is a negative performance characteristic - high-transaction environments require low latency, not high latency, to process requests quickly.

FHotswappable drives

Hot-swappable drives improve hardware availability and reduce downtime during drive replacement but do not directly enhance transaction processing performance.

GEncryption

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

#database servers#high transaction#RPM drives#load balancing

Community Discussion

No community discussion yet for this question.

Full SK0-004 Practice