How should you complete the statement?

DRAG DROPYou use the following statement to create a table. You have the following queries. You need to create an index to minimize the execution time of the queries.How should you complete the statement? To answer, drag the appropriate code elements to the correctlocations. Each code element may be used once, more than once, or […]

Read More

Which isolation level should you identify?

DRAG DROPYou plan to deploy two stored procedures name USP_1 and USP_2 that read data from a database.Your company identifies the following requirements for each stored procedure:USP_1 must allow dirty reads.USP_2 must place range locks on the data to ensure read consistency.You need to identify which isolation level you must set for each stored procedure. […]

Read More

You need to resolve the performance issue

You have the following stored procedure. The stored procedure takes much longer to execute than expected.While reviewing the execution plan of the stored procedure, you discover the following predicate for a ClusteredIndex Scan operator. You need to resolve the performance issue.What should you do? A. Change the @FileName parameter from nvarchar(512) to varchar(512). B. Change […]

Read More

Which storage option should you use?

You are designing a new database table that will be used for reporting.You define the table by using the following statement. You need to store the data in the table by using the least amount of storage space possible.Which storage option should you use? A. a clustered index B. a clustered columnstore index C. a […]

Read More

You need to identify which nonclustered indexes are unused by queries.

DRAG DROPYou need to identify which nonclustered indexes are unused by queries.How should you complete the statement? To answer, drag the appropriate values to the correct locations. Eachvalue may be used once, more than once, or not at all. You may need to drag the split bar between panes orscroll to view content.Select and Place: […]

Read More

You need to perform the following maintenance tasks:

DRAG DROPYou have a database named database1. Each table in database1 has one index per column.Users often report that creating items takes a long time.You need to perform the following maintenance tasks:Identify unused indexes.Identify which indexes should be created.What should you use?To answer, drag the appropriate function to the correct management task in the answer […]

Read More

Which Transact-SQL statement should you run?

You have a database named Inventory. Inventory is stored on Microsoft Azure SQL Database and contains atable named ProductDetails.For a given product, you need to retrieve the ProductID, Manufacturer, Weight, and ListPrice columns for all ofthe items in the ProductDetails table. The solution must ensure that the results can be joined to other tables.Which Transact-SQL […]

Read More