Administering a SQL Database Infrastructure — Question 118

You plan to install Microsoft SQL Server 2016 for a web hosting company.
The company plans to host multiple web sites, each supported by a SQL Server database.
You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership.
Which edition should you choose?

Answer options

• A. Express Edition with Tools
• B. Standard Edition
• C. Web Edition
• D. Express Edition with Advanced Services

Correct answer: B

Explanation

The Standard Edition is the correct choice because it offers backup compression and basic data integration features, making it suitable for multiple databases at a reasonable cost. The Express Edition versions lack these features, and the Web Edition is typically more expensive and tailored for specific web hosting scenarios.