Question 360
An incident response engineer inspects the following evidence: A report called Top Threats lists low-count signatures first because a customized dataset sorts ascending rather than descending. What is the most appropriate response to the reported operational problem?
Explanation
Correct Answer
The underlying cause is: The sort order determines the displayed ranking, and an inverse ORDER BY can misrepresent a top-N claim. The correct response is: Correct the dataset's grouping and descending count sort while checking its limit and tie handling. Confirm by checking: Known high-count signatures appear before lower-count detections in the report table.
Incorrect Answers
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. Here, the relevant failure is instead: The sort order determines the displayed ranking, and an inverse ORDER BY can misrepresent a top-N claim.
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. In this question the necessary remedy is “Correct the dataset's grouping and descending count sort while checking its limit and tie handling”, which this alternative does not provide.
That intervention addresses output pdf versus csv recipient need, where A presentation-oriented report layout is not equivalent to a record-level export needed for data reconciliation. The observed condition is a report called Top Threats lists low-count signatures first because a customized dataset sorts ascending rather than descending; this mechanism addresses another problem.