CompTIA Data+ (DA0-001) — Question 97

Which of the following is the best reason to use database views instead of tables?

Answer options

• A. Views reduce the need for repetitive, complex data joins.
• B. Views allow for the storage of temporary data, whereas tables do not.
• C. Views allow for the joining of multiple data sources, whereas tables do not.
• D. Views can be used to restrict sensitive information.

Correct answer: D

Explanation

The correct answer, D, highlights that views can be used to restrict access to sensitive data, which is a common use case. Option A is incorrect because while views can simplify joins, it's not their primary purpose. Option B is wrong as views do not store data; they present data from tables. Option C is misleading because tables can also join data from multiple sources.