You create a view based on the following statement.

You grant the Select permission to User1. You need to change the view so that it displays only the
records that were processed in the month prior to the current month. You need to ensure that after

the changes, the view functions correctly for User1. Which Transact-SQL statement should you
use?

A.
Option A

B.
Option B

C.
Option C

D.
Option D