HOTSPOT A company plans to deploy Microsoft SQL Server databases in Azure. The following requirements must be met: Resources must be shared across 200 databases. Total pool storage must support at least two terabytes (TB) You need to configure the…
You have a single-server on-premises Microsoft SQL Server deployment. You must migrate the environment to an Azure virtual machine (VM). You must minimize costs while maintaining the same level of performance as the onpremises SQL environment. You need to evaluate…
DRAG DROP You have a Microsoft Azure SQL Database instance named Marketing. The instance is hosted on an Azure SQL Server named mycompanyazure. The server uses a storage account named mycompanyblob. You attempt to connect to the Azure SQL Database…
HOTSPOT You have an on-premises database. You plan to migrate the database to Microsoft SQL Server on a Microsoft Azure virtual machine. You move the database files to Azure. You need to attach the database files to the SQL Server…
DRAG DROP You have a Microsoft SQL Server instance which hosts all of your corporate databases. A database named Sales stores information about customers and their contact information. You use the following processes for backing up the database: All databases…
HOTSPOT You are migrating an on-premises Microsoft SQL Server virtual machine (VM) to an Azure IaaS VM. The following chart shows current peak IOPS per hour over the course of a day: The number of IOPS per hour is expected…
HOTSPOT You are database administrator for an international sales application on a Microsoft SQL Server instance. A large amount of legacy data has been collected in the application database, as shown in the following table. You need to choose the…
HOTSPOT Background You are managing a multi-tenant environment hosted within Windows Azure. All changes to the database are pushed to a template database which is stored as a Microsoft Azure SQL database named ContosoTemplate which is stored on the virtual…
HOTSPOT A company has an on-premises Microsoft SQL Server environment with a SQL Server named SQL01. You need to create a local sysadmin account on SQL01 NAMED Admin1. How should you complete the Transact-SQL statements? To answer, select the appropriate…
HOTSPOT A company has a Microsoft Azure SQL Database instance that uses dynamic data masking. You observe that numeric fields contain whole integers as masked data. You need to display a zero value for numeric fields. What is the current…