Note: This question is part of a series of questions that use the same 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 this series. Information and details provided in a question apply only to that question.You are developing an application to track customer sales. You create tables to support the application. You need to create a database object that meets the following data entry requirements:What should you create?
DRAG DROP -You have a Microsoft Azure SQL Database named MyDb that uses server version V12.You plan to use Query Performance Insight to troubleshoot performance problems. The database query store is not enabled.You need to enable the database query store to meet the following requirements for the database:✑ Statistics must be aggregated every 15 minutes.✑ Query stores must use no more than 1,024 megabytes (MB) of storage.✑ Query information must be retained for at least 15 days.✑ Queries must be captured based on resource consumption.You connect to the database by using SQL Server Managements Studio.How should you complete the Transact-SQL statements? 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.NOTE: More than one combination of answer choices is correct. You will receive credit for any of the correct combinations you select. Each correct selection is worth one point.Select and Place:
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?
HOTSPOT -You create a database table named FactSales by running the following Transact-SQL statements:You must optimize the indexes without making changes to the ix_FactSales_EmployeeKey index.You need to implement a columnstore index for the table.How should you complete the Transact-SQL code? To answer, select the appropriate Transact-SQL segments in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
DRAG DROP -You have a trigger named CheckTriggerCreation that runs when a user attempts to create a trigger. The CheckTriggerCreation trigger was created with theENCRYPTION option and additional proprietary business logic.You need to prevent users from running the ALTER and DROP statements or the sp_tableoption stored procedure.Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.Select and Place:
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:
