Question 100
A regional SOC analyst is asked to resolve this problem: An audit team needs a searchable table of raw selected fields, but the monthly report sends only a graphical PDF summary. What should the analyst or engineer change first to address this condition?
Explanation
Correct Answer
The underlying cause is: A presentation-oriented report layout is not equivalent to a record-level export needed for data reconciliation. The correct response is: Provide a supported structured dataset or filtered log export alongside the report with approved source and field scope. Confirm by checking: The auditors receive field-level evidence they can reconcile with the report's aggregate totals.
Incorrect Answers
That intervention addresses confidential information in report columns, where A technically valid report can expose sensitive log attributes when output fields and recipients exceed authorized need. Here, the relevant failure is instead: A presentation-oriented report layout is not equivalent to a record-level export needed for data reconciliation.
That intervention addresses report cover page displays old dates, where Static layout text and dynamically computed report period fields are different sources of metadata. In this question the necessary remedy is “Provide a supported structured dataset or filtered log export alongside the report with approved source and field scope”, which this alternative does not provide.
That intervention addresses macro references missing field alias, where A macro expects a defined dataset field, and alias changes can break the reference even when the SQL returns data. The observed condition is an audit team needs a searchable table of raw selected fields, but the monthly report sends only a graphical PDF summary; this mechanism addresses another problem.