An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics. What should the…

Question

Options

• AAssume role with OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the
• BAssume role with ALL PRIVILEGES including ADD SEARCH OPTIMIZATION in the SECURITY
• CAssume role with OWNERSHIP on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in
• DAssume role with ALL PRIVILEGES on VPN_ACCESS_LOGS and ADD SEARCH

• A
  11% (2)
• C
  84% (16)
• D
  5% (1)

Explanation

To enable the search optimization service on a specific table, a role needs two things: (1) OWNERSHIP privilege on that exact table, and (2) the ADD SEARCH OPTIMIZATION privilege granted on the schema that contains the table. Option C correctly requires both on the specific table (VPN_ACCESS_LOGS) and its containing schema (SECURITY_LOGS). Option A is incorrect because OWNERSHIP on 'future tables' does not grant rights on an already-existing table. Options B and D are incorrect because ALL PRIVILEGES on the table alone is not sufficient-the ADD SEARCH OPTIMIZATION privilege must also be held at the schema level, and ALL PRIVILEGES does not implicitly include schema-level grants.

No community discussion yet for this question.