Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You need to create a stored procedure that updates the Customer, CustomerInfo, OrderHeader, and OrderDetails tables in order.
You need to ensure that the stored procedure:
- Runs within a single transaction.
- Commits updates to the Customer and CustomerInfo tables regardless of the status of updates to the OrderHeader and OrderDetail tables.
- Commits changes to all four tables when updates to all four tables are successful.
Solution: You create a stored procedure that includes the following Transact-SQL segment:

Does the solution meet the goal?

• A. No
• B. Yes

You are designing a stored procedure for a database named obi.
The following requirements must be met during the entire execution of the stored procedure:
*The stored procedure must only read changes that are persisted to the database.
*select statements within the stored procedure should only show changes to the data that are made by the stored procedure You need to configure the transaction isolation level for the stored procedure.
Which Transact-SQL statement or statements should you run?
A)

B)

C)

D)

• A. Option A
• B. Option C
• C. Option B
• D. Option D

You need to create a view that can be indexed. You write the following statement.

What should you add at line 02?

• A. with check_option
• B. with schenabinding
• C. with recompile
• D. with view metadata

Note: This question is part of a series of questions that use the same or similar answer choices. An Answer choice may be correct for more than one question in the series. Each question independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are a database developer for a company. The company has a server that has multiple physical disks. The disks are not part of a RAID array. The server hosts three Microsoft SQL Server instances. There are many SQL jobs that run during off-peak hours.
You observe that many deadlocks appear to be happening during specific times of the day.
You need to monitor the SQL environment and capture the information about the processes that are causing the deadlocks.
What should you do?

• A. Create a sys.dm_os_memory_objects query.
• B. Create a sys.dm_exec_sessions query.
• C. Create a SQL Profiler trace.
• D. Create a sys.dm_os_waiting_tasks query.
• E. Create a sys.dm_os_wait_stats query.
• F. Create a sp_configure 'max server memory' query.
• G. Create a PerformanceMonitor Data Collector Set.
• H. Create an Extended Event.

Background
You have a database named HR1 that includes a table named Employee.
You have several read-only, historical reports that contain regularly changing totals. The reports use multiple queries to estimate payroll expenses. The queries run concurrently. Users report that the payroll estimate reports do not always run. You must monitor the database to identify issues that prevent the reports from running.
You plan to deploy the application to a database server that supports other applications. You must minimize the amount of storage that the database requires.
Employee Table
You use the following Transact-SQL statements to create, configure, and populate the Employee table:

Application
You have an application that updates the Employees table. The application calls the following stored procedures simultaneously and asynchronously:
- UspA: This stored procedure updates only the EmployeeStatus column.
- UspB: This stored procedure updates only the EmployeePayRate column.
The application uses views to control access to data. Views must meet the following requirements:
- Allow user access to all columns in the tables that the view accesses.
- Restrict updates to only the rows that the view returns.
Exhibit

You view the Deadlock Graph as shown in the exhibit. (Click the Exhibit button.) Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.