Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some questio…

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solut…

You plan to deploy an on-premises SQL Server 2014 database to Azure SQL Database. You have the following requirements:

You are the database administrator for your…

You manage an on-premises, multi-tier application that has the following configuration:

You are the database administrator in your company. You plan to create…

You have a server named Serverl that is hosted in an Azure virtual machine. Server1 con…

You are designing a Windows Azure SQL Database for an order fulfillment system. You create a table named Sales.Orders with the following script.

You are using dynamic management views to monitor an SQL Server server named SQL1.

You are the administrator for a SQL Server 2016 instance that stores the data for an online transaction processing sales system. The company takes full backups every week; differential backups on the days with no full backups; and hourly transaction backups.