Which of the following is the best reason to use database views instead of tables?
Which of the following is the best reason to use database views instead of tables?
Views can be used to restrict sensitive information. By defining subsets of data from one or more tables and limiting access to certain columns or rows based on predefined criteria, views allow for better control over sensitive data. This capability is essential for enforcing data security and access control policies, thereby protecting sensitive information from unauthorized access and ensuring data privacy and confidentiality.
Both A and D are valid, it is a guess to which Comptia thinks is BEST.
New answer: A. Views can encapsulate complex joins and queries into a single virtual table-like structure. This means you can define a view once with the necessary joins and filters, and then reuse that view in queries without having to rewrite the complex join logic each time. This simplifies query writing, improves maintainability, and reduces the risk of errors.
D. Views can be used to restrict sensitive information. While all the options have their own merits, option D stands out as a fundamental advantage of using views. Views allow you to control access to sensitive data by defining subsets of data from one or more tables and limiting access to certain columns or rows based on predefined criteria. This capability is crucial for enforcing data security and access control policies without compromising the integrity of the underlying data structure. It helps protect sensitive information from unauthorized access, ensuring data privacy and confidentiality.