You are developing an application that connects to a database The application runs the following jobs: The READ_COMMITTED_SNAPSHOT database option is set to OFF, and auto-content is set to ON. Within the stored procedures, no explicit transactions are defined. If…
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario…
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario…
You have a database that is experiencing deadlock issues when users run queries. You need to ensure that all deadlocks are recorded in XML format. What should you do? A. Create a Microsoft SQL Server Integration Services package that uses…
DRAG DROP You are analyzing the performance of a database environment. Applications that access the database are experiencing locks that are held for a large amount of time. You are experiencing isolation phenomena such as dirty, nonrepeatable and phantom reads.…
DRAG DROP You are evaluating the performance of a database environment You must avoid unnecessary locks and ensure that lost updates do not occur. You need to choose the transaction isolation level for each data scenario. Which isolation level should…
DRAG DROP You have two database tables. Table1 is a partioned table and Table 2 is a nonpartioned table. Users report that queries take a long time to complete. You monitor queries by using Microsoft SQL Server Profiler. You observe…
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, DELETE and BACKUP DATABASE statements. You have the following requirements: -You must run all the stored procedures…
HOTSPOT You are profiling a frequently used database table named UserEvents. The READ_COMMITED_SNAPSHOT database option is set to OFF. In the trace results, you observe that lock escalation occurred for one stored procedure even though the number of locks in…
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario…