220-802 · Question #1005
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?
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…
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
How the community answered
(69 responses)- A81% (56)
- B10% (7)
- C3% (2)
- D6% (4)
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.
Topics
Community Discussion
No community discussion yet for this question.