Exam 70-764 topic 1 question 149 discussion

Actual exam question from Microsoft's 70-764

Question #: 149
Topic #: 1

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.

A. SQL Server 2014 Enterprise
B. SQL Server 2014 Standard
C. SQL Azure
D. SQL Server 2014 Express with Advanced Services

Show Suggested Answer

Suggested Answer: B 🗳️
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.

by Chaudhary at Nov. 28, 2019, 1:13 p.m.

Comments

Submit Cancel

techiebuddhas

Highly Voted 5 years, 4 months ago

For shorter time usage, azure would be the best choice.

upvoted 8 times

...

huzein

Most Recent 4 years, 7 months ago

HA can be also database mirroring. So I think B is correct.

upvoted 1 times

...

TheSwedishGuy

5 years, 4 months ago

Highly available data for me means Synchronous Commit Always On. Standard does not contain AlwaysOn feature. SQL Azure could be a good choice. If you want On-Premise, then you need an Enterprise Edition.

upvoted 2 times

...

Chaudhary

5 years, 6 months ago

I think Azure

upvoted 4 times

...