Share via

Potential Error in Answer Key for Block Predicate Question

Renan Duarte 0 Reputation points
2024-08-12T07:50:36.9733333+00:00

I noticed a potential issue with one of the questions regarding block predicates and row-level security. The question is as follows:

Question: Which block predicate prevents users from updating rows to values that violate its row-level security predicate?

The provided answer marked as correct is "AFTER UPDATE." However, I believe this is misleading. Shouldn't the correct answer be "BEFORE UPDATE"?

Reasoning: A BEFORE UPDATE trigger is designed to enforce conditions before an update operation is executed. If the conditions in the BEFORE UPDATE trigger are not met, the update can be blocked, effectively preventing any violations of security policies. In contrast, an AFTER UPDATE trigger only executes after the update has already occurred, which wouldn't be able to prevent the violation of security policies.

I believe this discrepancy might lead students to misunderstand the concepts being tested. Could you please review this and confirm whether the correct answer should indeed be "BEFORE UPDATE"?

Thank you for your attention to this matter.

This question is related to the following Learning Module

Azure | Azure Training

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-03T08:37:10.6+00:00

    Hi Renan Duarte,

    Thank you for bringing this issue to our attention.

    Our team is aware of the problem and is actively working on a solution.

    In the meantime, we kindly ask that you proceed with the Learning Paths without completing the exercise modules. We will provide updates as soon as we have more information.

    Thank you for your patience and understanding.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.