HOTSPOT
HOTSPOT A company plans to use a Microsoft Azure Resource Manager template to deploy a SQL Server in Azure. A partition of the Azure Resource Manager template is displayed. Use the drop-down menus to select the answer choice that answers…
70-765
How should you complete the Transact-SQL statement?
HOTSPOT You have a Microsoft SQL server that manages all of your databases. You must create a database named MarketingData. The database will initially consume 400 megabytes (MB) of storage and will grow by one percent per year. The database…
Which argument in sp_addmessage should you configure?
A Microsoft SQL Server instance has a database named Employees. The database contains information about employees including their salary. You must create a custom system message as an alert when an error is raised. You need to create the custom…
Which statements should you execute?
You have an on-premises SQL Server database named DB1 that contains a table named TB1. TB1 is stretched to Microsoft Azure. A catastrophic hardware failure occurs on the on-premises SQL server. You deploy a new on-premises server and restore all…
Which resource value should you populate?
You are developing customized Microsoft Azure Resource Group templates to automate the process of deploying Microsoft SQL Server in Azure to enforce consistency during future deployments. You need to deploy the customized templates to the Azure environment and to external…
Which three actions should you perform?
You have just completed a new Microsoft SQL Server installation. You need to configure a new SQL Server Agent alert to send an email to the DBA team for severity 20 errors. Which three actions should you perform? Each correct…
Which two columns should use randomized encryption?
You are configuring a table to use the Always Encrypted feature. The table will have the columns configured as shown in the following table. All the columns will be encrypted by using the AEAD_AES_256_CBC_HMAC_SHA_256 algorithm. Values will be stored in…
Which uses the database was written using an object relationship mapping (ORM) tool which maps tables as objects within the application code. There are 30 stored procedures that are regularly used by the application.
HOTSPOT Background You manage the Microsoft SQL Server environment for a company that manufactures and sells automobile parts. The environment includes the following servers: SRV1 and SRV2. SRV1 has 16 logical cores and hosts a SQL Server instance that supports…
Which PowerShell cmdlets should you run?
HOTSPOT A company uses several Microsoft Azure elastic pools with Azure SQL Database instances. You have two pools named Pool1 and Pool2. Pool2 is near maximum capacity and cannot accommodate the database move. You need to move the database from…
How should you complete the Transact-SQL statement?
DRAG DROP 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…