PrepAway - Latest Free Exam Questions & Answers

You plan to create a database.

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.

Af

ter 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.

A. SQL Server 2014 Enterprise

B. SQL Server 2014 Standard

C. SQL Azure

D. SQL Server 2014 Express with Advanced Services

Explanation: Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL) supported by Standard

and Enterprise editions only. References: Features Supported by the Editions of SQL Server 2014.


Leave a Reply

PrepAway - Latest Free Exam Questions & Answers

You plan to create a database.

You plan to create a database.

Th

e 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 dat

abase 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.

A. Max Degree of Parallelism

B. Resource Governor

C. Windows

System Resource Manager (WSRM)

D. Processor affinity


Leave a Reply