Which edition should you choose?

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?
A . Express Edition with Tools
B . Standard Edition
C . Web Edition
D . Express Edition with Advanced Services

View Answer

Answer: B

Explanation:

Backup compression is supported on SQL Server 2016 editions: Enterprise, Standard, and Developer.

References: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016