SOL-C01 Question #21: Real Exam Question with Answer & Explanation

Question

You have a base table called `customer data' which contains sensitive information like credit card numbers. You need to create a view called that exposes only non-sensitive columns (e.g., customer_id, customer_name, city) and hides the logic of the underlying table's structure. Additionally, you want to ensure that no user can directly query the 'customer_data' table. Which of the following steps are necessary to achieve this?

Options

• ACreate a standard view `customer_summary' selecting only the desired columns from
• BCreate a materialized view `customer_summary' selecting only the desired columns from
• CCreate a secure view `customer_summary' selecting only the desired columns from
• DCreate a standard view `customer_summary' selecting only the desired columns from
• ECreate a secure view `customer_summary' selecting all columns from `customer_data'. Grant

Explanation

Option C provides the correct solution. Creating a secure view 'customer_summary' hides the base table structure from users and ensures that they can only access the data through the view. Revoking SELECT privileges on the `customer_data' table prevents direct access to the sensitive data, making it accessible only through the view, and only to those with privilege on the view. Materialized views are not appropriate here because their data is physically stored, and the need is to hide the base table not improving the performance. Option D is incorrect because without revoking the base table privilege, users can query the base table directly. Option E will display all

No community discussion yet for this question.