DRAG DROP -You have a database named MyDatabase. You must monitor all the execution plans in XML format by using Microsoft SQL Trace. The trace must meet the following requirements:✑ Capture execution plans only for queries that run the MyDatabase database.✑ Filter out plans with event duration of less than or equal to 100 microseconds.✑ Save trace results to a disk on the server.You need to create the trace.In which order should you arrange the Transact-SQL segments to develop the solution? To answer, move all Transact-SQL segments to the answer area and arrange them 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:
HOTSPOT -You are analyzing the performance of a database environment.You need to find all unused indexes in the current database.How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segments in the answer area.Hot Area:
HOTSPOT -You are reviewing the execution plans in the query plan cache. You observe the following:- There are a large number of single use plans.- There are a large number of simple execution plans that use multiple CPU cores.You need to configure the server to optimize query plan execution.Which two setting should you modify on the properties page for the Microsoft SQL Server instance? To answer, select the appropriate settings in the answer area.Hot Area:
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 an application to track customer sales.You need to create a database object that meets the following requirements:- Return a value of 0 if data inserted successfully into the Customers table.- Return a value of 1 if data is not inserted successfully into the Customers table.- Support logic that is written by using managed code.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 an application to track customer sales.You need to create a database object that meets the following requirements:- Return a value of 0 if data inserted successfully into the Customers table.- Return a value of 1 if data is not inserted successfully into the Customers table.- Support TRY"¦CATCH error handling- Be written by using Transact-SQL statements.What should you create?
DRAG DROP -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 is exactly the same in each question in this series.You have a database named Sales that contains the following database tables: Customer, Order, and Products. The Products table and the Order table are shown in the following diagram.The customer table includes a column that stores the data for the last order that the customer placed.You plan to create a table named Leads. The Leads table is expected to contain approximately 20,000 records. Storage requirements for the Leads table must be minimized.Changes to the price of any product must be less a 25 percent increase from the current price. The shipping department must be notified about order and shipping details when an order is entered into the database.You need to implement the appropriate table objects.Which object should you use for each table? To answer, drag the appropriate objects to the correct tables. Each object may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.Select and Place:
