Provisioning SQL Databases — Question 26

You plan to install Microsoft SQL Server 2012 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 provides backup compression, basic data integration features, and a reasonable total cost of ownership, making it suitable for the company's needs. The Express Edition options do not support backup compression, and the Web Edition is designed for hosting services but lacks some of the features required here. Thus, the Standard Edition is the most appropriate choice.