DRAG DROP -You are analyzing the performance of a database environment.You suspect there are several missing indexes in the current database.You need to return a prioritized list of the missing indexes on the current database.How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment 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:
DRAG DROP -You are monitoring a Microsoft Azure SQL Database.The database is experiencing high CPU consumption.You need to determine which query uses the most cumulative CPU.How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than one or not at all. You may need to drag the split bar between panes or scroll to view content.Select and Place:
DRAG DROP -You are analyzing the memory usage of a Microsoft SQL Server instance.You need to obtain the information described on the following table.Which performance counter should you use for each requirement? To answer, drag the appropriate performance counters to the correct requirements. Each performance counter may be used once, more than once or not at all. You may need to drag the split bat between panes or scroll to view content.NOTE: Each correct selection is worth one point.Select and Place:
You use Microsoft SQL Server Profile to evaluate a query named Query1. The Profiler report indicates the following issues:✑ At each level of the query plan, a low total number of rows are processed.✑ The query uses many operations. This results in a high overall cost for the query.You need to identify the information that will be useful for the optimizer.What should you do?
You are experiencing performance issues with the database server.You need to evaluate schema locking issues, plan cache memory pressure points, and backup I/O problems.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:
