How should you complete the table definition to reduce contention on the table structure?

DRAG DROP
You administer a SQL Server 2014 instance.
You have been assigned to determine the cause of frequent long-running transactions that
have been tracked to the dbo.Account table, where there are many cases of blocking and
deadlocks. The dbo.Account table contains more than one million rows.
Users and processes frequently search for and update data by using the AccountId column,
and less frequently the AccountNumber and GovernmentId columns, all of which contain
only unique values. Users frequently get lists of AccountNumber values by searching on Last
Name and then First Name.
You need to modify the structure of the dbo.Account table to alleviate the issues.
How should you complete the table definition to reduce contention on the table structure? To
answer, drag the appropriate code snippets to the correct locations in the CREATE TABLE
statement. Each code snippet 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.

DRAG DROP
You administer a SQL Server 2014 instance.
You have been assigned to determine the cause of frequent long-running transactions that
have been tracked to the dbo.Account table, where there are many cases of blocking and
deadlocks. The dbo.Account table contains more than one million rows.
Users and processes frequently search for and update data by using the AccountId column,
and less frequently the AccountNumber and GovernmentId columns, all of which contain
only unique values. Users frequently get lists of AccountNumber values by searching on Last
Name and then First Name.
You need to modify the structure of the dbo.Account table to alleviate the issues.
How should you complete the table definition to reduce contention on the table structure? To
answer, drag the appropriate code snippets to the correct locations in the CREATE TABLE
statement. Each code snippet 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.

Answer:

Explanation:

Note:
Users and processes frequently search for and update data by using the AccountId column
(Primary Key Clustered) , and less frequently the AccountNumber (Unique Clustered) and
GovernmentId(Unique Clustered) columns, all of which contain only unique values. Users
frequently get lists of AccountNumber values by searching on Last Name and then First
Name (LastName, Firstname) INCLUDE (AccountNumber).



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Jai

Jai

Wrong explanation. You cannot create more than 1 clustered Indx on tab

Pete

Pete

explaination differ from the choosen snippets. you are right only one clustered index on tab. snippets are nonclustered… so everything is great there… just typos