Exam 70-461 topic 1 question 242 discussion

Actual exam question from Microsoft's 70-461

Question #: 242
Topic #: 1

You administer a Microsoft SQL Server database that includes a table named Products. The Products table has columns named ProductId, ProductName, and
CreatedDateTime.
The table contains a unique constraint on the combination of ProductName and CreatedDateTime.
You need to modify the Products table to meet the following requirements:
✑ Remove all duplicates of the Products table based on the ProductName column.
✑ Retain only the oldest Products row.
Which Transact-SQL query should you run?
A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: B
You use the WHERE clause to delete a set of rows
Incorrect Answers:
A: Instead use the cte.CreatedDateTime > p.CreateDateTime condition.
C: Need to have a AND cte.CreatedDateTime > p.CreateDateTime condition.
D: Use MAX not MIN, and we need to have a AND cte.CreatedDateTime > p.CreateDateTime condition.
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/delete-transact-sql

by lilupv at Sept. 4, 2020, 7:43 a.m.

Comments

Submit Cancel

lilupv

4 years, 11 months ago

Why not A? We have to delete all the products which have date > then minimum

upvoted 1 times

...