What should you recommend?

Your network contains an Active Directory domain that has two groups named Group1 and
Group2.
The domain contains two SQL Server instances named SQLDev and SQLProd. Each SQL
Server instance has access to various storage media.
The SQL Server instances have a database that contains a table named Table1.
Table1 contains a column named Column1. The value for Column1 can be either Value1 or
Value2.
You need to recommend a solution to ensure that users in Group1 can retrieve only rows
from Column1 that contain the value of Value1.
What should you recommend?

A.
A dynamic management view

B.
Filegroups

C.
Snapshot isolation

D.
User-defined views

Explanation:

A view is a virtual table whose contents are defined by a query. Like a table, a view consists
of a set of named columns and rows of data. Unless indexed, a view does not exist as a
stored set of data values in a database. The rows and columns of data come from tables
referenced in the query defining the view and are produced dynamically when the view is
referenced.
A view acts as a filter on the underlying tables referenced in the view.
Incorrect:
Not A: Dynamic management views and functions return server state information that can be
used to monitor the health of a server instance, diagnose problems, and tune performance.