Which statement about views is true?

Which statement about views is true?

• A. Views can act as a security filter
• B. Views store data physically
• C. Views replace tables in queries
• D. Views cannot be used for filtering

Answer: (A)

Views are virtual tables defined by a query; they don’t hold data themselves. Because you can tailor a view to include only certain rows or columns by filtering with conditions and selecting specific fields, a view can act as a security filter—exposing just what a user should see while hiding the rest. That’s why this statement is the best choice. It’s important to note that regular views don’t store data, though there are materialized views that do physically store data. Also, views aren’t substitutes for base tables in queries; you can query a view just like a table, but they are built on top of tables rather than replacing them. Views can thus provide targeted data exposure through filtering, which is the security-focused behavior described.

Views are virtual tables defined by a query; they don’t hold data themselves. Because you can tailor a view to include only certain rows or columns by filtering with conditions and selecting specific fields, a view can act as a security filter—exposing just what a user should see while hiding the rest.

That’s why this statement is the best choice. It’s important to note that regular views don’t store data, though there are materialized views that do physically store data. Also, views aren’t substitutes for base tables in queries; you can query a view just like a table, but they are built on top of tables rather than replacing them. Views can thus provide targeted data exposure through filtering, which is the security-focused behavior described.