nerdexam
Microsoft

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.

Submitted by viktor_hu· Mar 5, 2026Design and implement database solutions for SQL Server

Question

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 event, the database will be deleted. You need to recommend a solution to implement the database while minimizing costs. The solution must not affect any existing applications. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

Options

  • ASQL Server 2014 Enterprise
  • BSQL Server 2014 Standard
  • CSQL Azure
  • DSQL Server 2014 Express with Advanced Services

How the community answered

(16 responses)
  • A
    6% (1)
  • B
    75% (12)
  • C
    6% (1)
  • D
    13% (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.

ASQL Server 2014 Enterprise

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.

BSQL Server 2014 StandardCorrect

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.

CSQL Azure

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.

DSQL Server 2014 Express with Advanced Services

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

#high availability#cost optimization#SQL Server editions

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice