Home » Microsoft » 70-473 v.2 » Which database solution should you use for each database?
HOTSPOT
Your company’s data center contains three Microsoft SQL Server databases named DB1, DB2, and DB3. You plan to migrate the databases to Microsoft Azure.
You need to provision the resources in Azure to meet the following requirements:
DB1 must be able to execute CLR assemblies.
DB2 must be able to run SQL Server Agent jobs.
Which database solution should you use for each database? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Explanation/Reference:
Explanation:
Box 1: Azure SQL Database
Azure SQL Database supports the CLR assembly feature.
Box 2: An Azure virtual machine that has SQL server installed.
Incorrect Answers:
Not Azure SQL Database. Azure SQL Databases do not include the SQL Server agent.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-overview?view=sql-server-2017 https://www.linkedin.com/pulse/migrating-azure-sql-database-missing-agent-see-how-functions-campo