DRAG DROP You are a database developer for a company that delivers produce and other refrigerated goods to grocery stores. You capture the food storage temperature for delivery vehicles by using Internet of Things (IoT) devices. You store the temperature…

HOTSPOT You have a database named Database1. Users report that they experience deadlock issues. You run the sp_readerlog stored procedure. You view the output from the Process List section as shown in the Process List exhibit. (Click the Process List…

You have multiple queries that take a long time to complete. You need to identify the cause by using detailed information about the Transact-SQL statements in the queries. The Transact-SQL statements must not run as part of the analysis. Which…

You are experiencing performance issues with the database server. You need to evaluate schema locking issues, plan cache memory pressure points, and backup IO problems. What should you create A. a System Monitor report B. a sys.dm_tran_database_transaction dynamic management view…

Database users report that SELECT statements take a long time to return results. You run the following Transact-SQL statement You need to create one nonclustered covering index that contains all of the columns in the above table. You must minimize…

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…

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…

You have a table that stores transactions partitioned by year. Users occasionally experience performance issues when they access the table. The table is locked exclusively when the records are updated. You need to prevent exclusive locks on the table and…