Exam 70-765 topic 3 question 67 discussion

Actual exam question from Microsoft's 70-765

Question #: 67
Topic #: 3

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?

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

Show Suggested Answer

Suggested Answer: B 🗳️
Incorrect Answers:
A, D: Express edition has severe limitations.
C: SQL Server 2012 Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large scale Web properties.
References: https://msdn.microsoft.com/en-us/library/ms144275(v=sql.110).aspx

by MelKr at May 12, 2020, 8:58 a.m.

Comments

Submit Cancel

MelKr

Highly Voted 5 years, 2 months ago

The question would suggest that Web Edition (C) is correct but this does not have backup compression. So this leaves us with Standard

upvoted 5 times

...