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 is independent of the other
questions in the series. Information and details provided in a question apply only to that question.
You are developing and application to track customer sales.
You need to return the sum of orders that have been finalized, given a specified order identifier. This value will
be used in other Transact-SQL statements.
You need to create a database object.
What should you create?

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 is independent of the other
questions in the series. Information and details provided in a question apply only to that question.
You are developing and application to track customer sales.
You need to create an object that meet the following requirements:
– Run managed code packaged in an assembly that was created in the Microsoft.NET Framework and
uploaded in Microsoft SQL Server.
– Run written a transaction and roll back if a future occurs.
– Run when a table is created or modified.
What should you create?

You have a view that includes an aggregate.
You must be able to change the values of columns in the view. The changes must be reflected in the tables that
the view uses.
You need to ensure that you can update the view.
What should you create?

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 must monitor and optimize the SQL Server to maximize throughput, response time, and overall SQL
performance.
You need to identify previous situations where a modification has prevented queries from selecting data in
tables.
What should you do?

DRAG DROP
You are creating a stored procedure which will insert data into the table shown in the Database schema exhibit.
(Click the exhibit button.)

You need to insert a new customer record into the tables as a single unit of work.
Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate
Transact-SQL segments to the answer area and arrange the, in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders
you select.
Select and Place:

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?

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 must monitor the SQL Server instances in real time and optimize the server to maximize throughput,
response time, and overall SQL performance.
What should you do?

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 must monitor the SQL Server instances in real time and optimize the server to maximize throughput,
response time, and overall SQL performance.
You need to ensure that the performance of each instance is consistent for the same queried and query plans.
What should you do?

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 must monitor the SQL Server instances in real time and optimize the server to maximize throughput,
response time, and overall SQL performance.
You need to collect query performance data while minimizing the performance impact on the SQL Server.
What should you do?

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 must monitor the SQL Server instances in real time and optimize the server to maximize throughput,
response time, and overall SQL performance.
You need to create a baseline set of metrics to report how the computer running SQL Server operates under
normal load. The baseline must include the resource usage associated with the server processes.
What should you do?