Exam 70-461 topic 1 question 245 discussion

Actual exam question from Microsoft's 70-461

Question #: 245
Topic #: 1

You are designing a Microsoft SQL Server database named Orders.
You create a table by running the following Transact-SQL statement:

You create a stored procedure to be used by an ASP.NET application that runs the following statement:

You need to ensure that the query runs as efficiently as possible.
Which Transact-SQL statement should you run?
A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: B
Creating a primary key automatically creates a corresponding unique clustered index, or a nonclustered index if specified as such.
Example: To create a primary key in an existing table
The following example creates a primary key on the column TransactionID in the AdventureWorks database.
ALTER TABLE Production.TransactionHistoryArchive
ADD CONSTRAINT PK_TransactionHistoryArchive_TransactionID PRIMARY KEY CLUSTERED (TransactionID);
References:
https://docs.microsoft.com/en-us/sql/relational-databases/tables/create-primary-keys

by lilupv at Sept. 4, 2020, 8:18 a.m.

Comments

Submit Cancel

lilupv

4 years, 11 months ago

I think it is A or D. We have to optimize the stored procedure. UserName is in the WHERE clause

upvoted 1 times

...