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

Question

You have a large table called with columns such as and `event_data' . You want to create a view named that calculates the number of distinct users active each day. This view will be used for reporting purposes. The data engineer responsible for the table has informed you that table has been modified to have a row access policy based on 'user _ id'. What additional considerations are needed when querying this view?

Options

• ANo additional considerations are needed. The row access policy on the base table is automatically
• BYou need to create a separate row access policy and apply it directly to the view, duplicating the
• CThe user querying must have the `APPLY ROW ACCESS POLICY' privilege on the `web_eventS
• DThe view must be created as a secure view to ensure the row access policy on the base table is
• EIf the row access policy is not correctly enforced on the view, you may need to explicitly specify the

Explanation

When a base table has a row access policy, and a view is created on top of it, the row access policy is not automatically inherited unless the view is created as a Secure View. Making it a Secure View guarantees enforcement of the underlying table's row access policy. A standard view might bypass the policy, so a secure view is used to ensure compliance. This approach mitigates the risk of exposing sensitive data. Other options are incorrect because row access policy needs to be explicitly defined by using Secure Views and there is not WITH option for ROW ACCESS Policy.

No community discussion yet for this question.