Exam 70-461 topic 1 question 176 discussion

You develop a Microsoft SQL Server database that contains a table named Products. The Products table has columns named ProductId, CategoryId, Name, and
Price.
Product prices are often updated as follows:
✑ For a single product by a specific value by using the ProductId column
✑ For an entire category by a percentage by using the CategoryId column
You need to log the change price to a new table named PriceChange by using the ProductId' ChangedValue, and ChangedDate columns. You also need to ensure that increases in price are recorded as positive values and decreases in price as negative values.
Which Transact-SQL query should you use?
A.

B.

C.

D.