Fortinet
NSE5_FAZ-5.4 · Question #9
NSE5_FAZ-5.4 Question #9: Real Exam Question with Answer & Explanation
Sign in or unlock NSE5_FAZ-5.4 to reveal the answer and full explanation for question #9. The question stem and answer options stay visible for context.
Question
Consider the following scenario: The FortiAnalyzer administrator creates a custom dataset. The Log type is set to Traffic and the Time Period is set to Last 30 days. The following query is entered: SELECT root_domain(hostname) as website, count(*) as totalnum, dstcountry FROM $log WHERE $filter and hostname is not null GROUP BY hostname, dstcountry ORDER BY session desc LIMIT 25. 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 contain the data to make the SQL query work.
- CThe database columns identified in the SELECT clause belong to the Virus log type, not the
- DThe database column in the ORDER BY clause ("session") is not in the SELECT clause, and
Unlock NSE5_FAZ-5.4 to see the answer
You've previewed enough free NSE5_FAZ-5.4 questions. Unlock NSE5_FAZ-5.4 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.