Fortinet
NSE5_FAZ-6.0 · Question #56
NSE5_FAZ-6.0 Question #56: Real Exam Question with Answer & Explanation
Sign in or unlock NSE5_FAZ-6.0 to reveal the answer and full explanation for question #56. The question stem and answer options stay visible for context.
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.
Unlock NSE5_FAZ-6.0 to see the answer
You've previewed enough free NSE5_FAZ-6.0 questions. Unlock NSE5_FAZ-6.0 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.