A user requested upgrades to a company-Issued laptop to increase its performance while working with a large database stored on drive C. Which of the following tasks should a systems administrator comp

The correct answer is D. Increase the RAM. E. Migrate to a SSD.. For a laptop struggling with a large local database, the two most impactful upgrades are: (D) Increasing RAM-more RAM allows the database engine to cache larger portions of data and indexes in memory, reducing disk reads and dramatically speeding up queries; and (E) Migrating to

Hardware

Question

A user requested upgrades to a company-Issued laptop to increase its performance while working with a large database stored on drive C. Which of the following tasks should a systems administrator complete to BEST meet this goal? (Choose two.)

Options

AConfigure RAID 1.
BInstall a hybrid drive.
CUpgrade to 1GB NIC.
DIncrease the RAM.
EMigrate to a SSD.
FUpgrade the power supply.

How the community answered

(24 responses)

A
4% (1)
C
8% (2)
D
75% (18)
F
13% (3)

Explanation

For a laptop struggling with a large local database, the two most impactful upgrades are: (D) Increasing RAM-more RAM allows the database engine to cache larger portions of data and indexes in memory, reducing disk reads and dramatically speeding up queries; and (E) Migrating to an SSD-SSDs offer far lower latency and higher IOPS than HDDs, directly improving database read/write throughput on drive C. Option A (RAID 1) provides redundancy/mirroring, not a performance gain. Option B (hybrid drive) is a partial improvement but inferior to a full SSD. Option C (1GB NIC) improves network throughput, which is irrelevant since the database is stored locally on drive C. Option F (power supply upgrade) has no effect on processing or storage performance.

Topics

#Laptop performance#RAM upgrade#SSD upgrade#Database optimization

Community Discussion

No community discussion yet for this question.

Full 220-1101 Practice