Question 750
A security operations team receives this change request: A report's custom chart needs only the ten most frequent destination domains, but the underlying dataset returns every domain and renders a huge unreadable table. Which statement describes the decisive system dependency?
Explanation
Correct Answer
A top-N visualization depends on ranking and row limitation in its data source or chart configuration. This behavior determines the engineering decision. The appropriate action is: Aggregate, sort, and limit dataset results to the required top categories with explicit inclusion rules. Verify success by checking: The output contains exactly the intended ten ranked test categories with matching counts.
Incorrect Answers
The action “FortiAnalyzer datasets retrieve data from log tables and charts visualize the dataset output; a chart without a valid dataset has no measurements” addresses a separate source case: A compliance analyst wants a report of the ten most active source IPs and inserts a decorative pie chart with no data query attached. Its underlying reason is: FortiAnalyzer datasets retrieve data from log tables and charts visualize the dataset output; a chart without a valid dataset has no measurements. This question instead describes a report's custom chart needs only the ten most frequent destination domains, but the underlying dataset returns every domain and renders a huge unreadable table. The original answer “A top-N visualization depends on ranking and row limitation in its data source or chart configuration” targets that failure because a top-N visualization depends on ranking and row limitation in its data source or chart configuration.
The action “An average duration metric becomes misleading when unresolved records have no valid completion time” addresses a separate source case: A critical chart shows average incident response time, but its dataset counts a still-open incident as if it had a completed resolution timestamp. Its underlying reason is: An average duration metric becomes misleading when unresolved records have no valid completion time. This question instead describes a report's custom chart needs only the ten most frequent destination domains, but the underlying dataset returns every domain and renders a huge unreadable table. The original answer “A top-N visualization depends on ranking and row limitation in its data source or chart configuration” targets that failure because a top-N visualization depends on ranking and row limitation in its data source or chart configuration.
The action “SQL aggregation groups source log rows by the intended dimension rather than preserving each input event” addresses a separate source case: An analyst groups thousands of events by destination, but the SQL query returns repeated rows for every session instead of one total per destination. Its underlying reason is: SQL aggregation groups source log rows by the intended dimension rather than preserving each input event. This question instead describes a report's custom chart needs only the ten most frequent destination domains, but the underlying dataset returns every domain and renders a huge unreadable table. The original answer “A top-N visualization depends on ranking and row limitation in its data source or chart configuration” targets that failure because a top-N visualization depends on ranking and row limitation in its data source or chart configuration.