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 newest Products row.

Which Transact-SQL query should you use?

A.

B.

C.

D.

A. Option A

B. Option B

C. Option C

D. Option D

Explanation: