Noos
PT EN
RAN-DBDEA-00172
Ranvier · DBDEA

Exam DBDEA Topics: governance Difficulty: medium

A compliance officer must produce a list of every principal that ran SELECT against the sensitive table main.hr.compensation during the last 30 days, along with timestamps. The list must come directly from a SQL query in the lakehouse: the team may not download access logs from the cloud provider or export CSV files from the query history UI. Which approach meets the requirement?

Options (Reading Mode) Click to filter discussion →
  1. A. Ask the cloud provider for the bucket's access logs and parse the object-level entries that touch the table's files.
  2. B. Query the system.access.audit system table, filtering the event date and the request parameters that name the table.
  3. C. Enable query history for each user and export every user's CSV history for offline consolidation into one report.
  4. D. Ask the account admin to review raw audit events manually, because audit events are visible only to admins and cannot be queried with SQL.
Reveal answer

Correct answer: Query the system.access.audit system table, filtering the event date and the request parameters that name the table.

Reference: https://docs.databricks.com/aws/en/admin/system-tables/audit-logs

Train this exam on Ranvier →

02 — The Myelin Layer · Canonical Discussion

Where the exam tries to trick you — and how those who passed solved it.

0 Passed

contributed to this question

Answer Distractor Matrix Click an option to filter or open its dissection.
✦ Consolidated Synthesis (Wiki) rev. #1 (baseline) · CC BY-SA 4.0
Start synthesis for this question →

No community synthesis consolidated for this question yet. Below is the verifiable official starting point — if you passed the exam, open the option dissection.

Official Answer (B): Query the system.access.audit system table, filtering the event date and the request parameters that name the table.

Ranvier · DBDEA

Contribute to this Question

Your contribution builds your Orbital Sheath

Peer contributions

No public contribution yet. Be the first who passed to explain why the distractors trick candidates — your contribution builds your Orbital Sheath.