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
Explanation:
Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL) supported by Standard and
Enterpirse editions only.
Reference: Features Supported by the Editions of SQL Server 2014
Most logical for me would be C:
https://azure.microsoft.com/en-us/documentation/articles/sql-database-dotnet-how-to-use/
yes it is sql Azure (No C)
C – SQL Azure Database
C for sure
sure C
Bla bla bla guys…
The right answer is “B – SQL Server 2014 Standard”
SQL Azure (V12)(12/MAY/2016) officially doesn’t support .NET
“Features not supported in SQL Database
…
– .NET Framework
…”
See:
– https://azure.microsoft.com/en-us/documentation/articles/sql-database-transact-sql-information/
The correct answer is still option C. Nobody indicated it has to be the free version (V12) which doesn’t support .net.
Other versions of SQL 2014 (Azure) supports .NET Application & CLR integration.
Ref:
https://msdn.microsoft.com/en-us/library/ms131089(v=sql.120).aspx
@dp: No mention is made of using .NET stored procedures.
“The database will be used by a Microsoft .NET application for a special event that will last for two days.”
Are you suggesting that a .NET app can’t work with SQL Azure Database (SAD)?
C. SQL Azure:
https://msdn.microsoft.com/library/mt718320.aspx:
using System; // C# , ADO.NET
using C = System.Data.SqlClient; // System.Data.dll
namespace ProofOfConcept_SQL_CSharp
{
public class Program
{
static public void Main()
{
using (var connection = new C.SqlConnection(
“Server=tcp:YOUR_SERVER_NAME_HERE.database.windows.net,1433;Database=AdventureWorksLT;User ID=YOUR_LOGIN_NAME_HERE;Password=YOUR_PASSWORD_HERE;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;”
))
{
connection.Open();
Console.WriteLine(“Connected successfully.”);
Console.WriteLine(“Press any key to finish…”);
Console.ReadKey(true);
}
}
}
}
/**** Actual output:
Connected successfully.
Press any key to finish…
****/
B) SQL Server 2014 Standard
First of all, the question says “minimizing costs”, so no Enterprise.
Second, the question says “highly available”, so no Express since it should be used only for small applications like “Small Marketplace”.
Now we are between “Standard” and “Azure”, the question says “will be used by” not “will be using”, which means, will be used by a desktop application connected to it, not a CLR .NET Framework, So the BEST OPTION is “Azure”.