You plan to create a custom aggregation function named Median. You plan to deploy Median to a SQL Server 2014 server named Server1. You need to ensure that Median can access a web service named WebApp1. The solution must minimize…
You administer a SQL Server 2014 instance. You have been assigned to determine the cause of frequent long-running transactions that have been tracked to the dbo.Account table, where there are many cases of blocking and deadlocks. The dbo.Account table contains…
You create a disk-based table that contains the following script: You need to prevent duplicate values in the SKU field. Which five code segments should you use? To answer, move the appropriate code segments from the list of code segments…
You administer a SQL Server 2014 instance. The server is capable of 10000 IO/second (IOPS). During the time period when the second process executes, the disk IO can reach 7000 IOPS, and CPU use can average 30% over the eight…
You have a table named Table1 that contains 1 million rows. Table1 contains a column named Column1 that stores sensitive information. Column1 uses the nvarchar(16) data type. You have a certificate named Cert1. You need to replace Column1 with a…
You have a SQL Server 2014 database. You plan to create a stored procedure that will retrieve the following information: The XML content of the query plans that is stored in memory The number of times each query plan is…
You are a SQL Server 2014 Developer. A database that you work on contains two tables that are defined as follows: Product is an important table that has sensitive audit requirements. You need to create a trigger that supports the…
Your network contains a server named Server1 that runs SQL Server 2012. Server1 contains an instance named Instance1. Instance1 contains a database named ContentDatabase. ContentDatabase uses transaction log backups. The recovery model of ContentDatabase is set to FULL. You need…
You have two existing tables, one named COUNTRY and the other named STATES. The tables are defined as follows: You need to set up a rule that every STATE.Country_Abbr must match an existing record in the COUNTRY table. Develop the…
You plan to deploy two stored procedures name USP_1 and USP_2 that read data from a database. Your company identifies the following requirements for each stored procedure: USP_1 cannot allow dirty reads. USP_2 must place range locks on the data…