DB2 10 for z/OS Database Administrator — Question 37

Which of the following statements about audit policies is TRUE?

Answer options

• A. Audit policy changes are applied instantly and affect all inflight transactions.
• B. Multiple audit policies can be associated with the same table at the same time.
• C. The audit policy applied to a table is automatically applied to any view based on that table.
• D. If a user is switched within a trusted connection, the applicable audit policies are re-evaluated for the new user without regard to audit policies for the original

Correct answer: D

Explanation

Answer D is correct because it highlights that upon switching users within a trusted connection, the system reassesses the applicable audit policies for the new user independently. Option A is incorrect as audit policy changes do not affect ongoing transactions immediately. Option B is also wrong because only one audit policy can be active for a table at a time. Lastly, option C is incorrect since views do not automatically inherit audit policies from their underlying tables.