70-465 · Question #18
You plan to create a database. The database will be used by a Microsoft .NET application for a special event that will last for two days. During the event, data must be highly available. After the eve
The correct answer is B. SQL Server 2014 Standard. This question tests your ability to select the most cost-effective SQL Server edition that supports high availability for a temporary, short-lived workload without impacting existing systems.
Question
Options
- ASQL Server 2014 Enterprise
- BSQL Server 2014 Standard
- CSQL Azure
- DSQL Server 2014 Express with Advanced Services
How the community answered
(16 responses)- A6% (1)
- B75% (12)
- C6% (1)
- D13% (2)
Why each option
This question tests your ability to select the most cost-effective SQL Server edition that supports high availability for a temporary, short-lived workload without impacting existing systems.
SQL Server 2014 Enterprise includes all high availability features but is the most expensive edition, making it unnecessarily costly for a temporary two-day event database.
SQL Server 2014 Standard supports high availability features such as Basic Availability Groups and database mirroring, satisfying the high availability requirement for the two-day event. It is a one-time licensed on-premises option that can host an isolated database without affecting existing applications, and it is significantly less expensive than Enterprise edition, making it the best balance of cost and capability for this scenario.
SQL Azure (Azure SQL Database) is a cloud-based PaaS service billed on a consumption or DTU model; while it could work technically, for a two-day isolated event it may introduce ongoing subscription costs and connectivity dependencies that are less cost-effective than a locally licensed Standard edition.
SQL Server 2014 Express with Advanced Services has a 10 GB database size limit and does not support enterprise-grade high availability features such as Always On Availability Groups or failover clustering, failing the high availability requirement.
Concept tested: SQL Server edition selection for cost and high availability
Source: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2014
Topics
Community Discussion
No community discussion yet for this question.