220-802 Question #1005: Real Exam Question with Answer & Explanation

The correct answer is A: Install and use a virtual server. A virtual server runs on existing hardware using a hypervisor, so no new physical server needs to be purchased. This is the most cost-efficient option because it leverages already-owned infrastructure. It is also more secure than cloud or leased options because the data remains o

Question

The IT department is concerned with budget cuts and needs to implement a new SQL server to support a project. Which of the following is the MOST cost-efficient and secure way to add a new SQL server?

Options

AInstall and use a virtual server
BLease a web based SQL server from an online hosting service
CBuy a low end server to meet the minimal requirements
DLease a server from another company

Explanation

A virtual server runs on existing hardware using a hypervisor, so no new physical server needs to be purchased. This is the most cost-efficient option because it leverages already-owned infrastructure. It is also more secure than cloud or leased options because the data remains on-premises under the company's direct control. Leasing a web-based or hosted SQL server introduces third-party data security concerns and ongoing costs. Buying a low-end physical server requires upfront capital expenditure and ongoing maintenance. Leasing from another company again creates recurring costs and data sovereignty issues.

Community Discussion

No community discussion yet for this question.

Full 220-802 Practice