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 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 to the answer area and…
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…
You are designing a database for a university. The database will contain two tables named Classes and StudentGrades that have the following specifications: Classes will store brochures in the XPS format. The brochures must be structured in folders and must…
You have a SQL Azure database named Database1. You need to design the schema for a table named table1. Table1 will have less than one million rows. Table1 will contain the following information for each row: The solution must minimize…
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…