DRAG DROP This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam.…
DRAG DROP You have a database that contains three encrypted store procedures named dbo.Proc1, dbo.Proc2 and dbo.Proc3. The stored procedures include INSERT, UPDATE, and DELETE statements. You have the following requirements: You must run all the stored procedures within the…
DRAG DROP You create tables by using the following Transact-SQL statements: Each customer may have multiple addresses but only one is the primary address. You must plan a solution that meets the following requirements: Return both customers and address information.…
DRAG DROP You have a memory-optimized table named Customer. The table is accessed by a stored procedure named ManageCustomer. The database was created in Microsoft SQL Server 2014. A backup and restore operation was used to move the database to…
DRAG DROP You must troubleshoot performance issues that users report. You identify the following representative user sessions: You need to configure the appropriate Extended Events. Which target should you use for each session? To answer, drag the appropriate Extended Event…
HOTSPOT This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You…
HOTSPOT This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You…
HOTSPOT This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You…
HOTSPOT This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You…
HOTSPOT You are designing a data warehouse that will be clustered across four servers. Several of the tables in the data warehouse contain transient data that you can rebuild as needed. The schema for the data changes periodically. You must…