Fortinet
NSE5_FAZ-6.0 · Question #56
Consider the following scenario: The FortiAnalyzer administrator creates a custom dataset. SELECT sum (vps) as total_vps, website, count(*) as totalnum, detcountry FROM $log WHERE $filter and…
The correct answer is B. The database does not recognize the sum() outside the SQL query work. See the full explanation below for the reasoning.
Question
Consider the following scenario: The FortiAnalyzer administrator creates a custom dataset.
SELECT sum (vps) as total_vps, website, count(*) as totalnum, detcountry FROM $log WHERE $filter and hostname is not null GROUP BY hostname, detcountry ORDER BY session desc LIMIT 25.
The query is entered.
When the administrator tests the custom dataset, an error message is returned. Why?
Options
- AThe clauses are not coded in the correct sequence.
- BThe database does not recognize the sum() outside the SQL query work.
- CThe database columns identified in the SELECT clause belong to the Virus log type, not the Traffic log type.
- DThe database column in the ORDER BY clause ("session") is not in the SELECT clause, and it has to be in order for the query to work.
How the community answered
(50 responses)- A4% (2)
- B74% (37)
- C8% (4)
- D14% (7)
Community Discussion
No community discussion yet for this question.