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.

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

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

Explanation:

Detailed explanation-1: -The correct answer is 1-Additional database filegroups can be added via Transact-SQL statements.

Detailed explanation-2: -Azure SQL allows you to benefit from almost unlimited cloud scalability and has high availability out of the box. If you also need full control over the operating system or compatibility with on-premises workloads such as SQL Server Reporting Services you can run SQL Server on an Azure VM.

Detailed explanation-3: -The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.

Detailed explanation-4: -SQL Database serverless is currently only supported in the General Purpose tier on Generation 5 hardware in the vCore purchasing model.

There is 1 question to complete.

MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL