NSE 5 – FortiAnalyzer 7.0 — Question 15

Which SQL query is in the correct order to query the database in the FortiAnalyzer?

Answer options

• A. SELECT devid WHERE 'user'='USER1' FROM $log GROUP BY devid
• B. FROM $log WHERE 'user'='USER1' SELECT devid GROUP BY devid
• C. SELECT devid FROM $log WHERE 'user'='USER1' GROUP BY devid
• D. SELECT devid FROM $log GROUP BY devid WHERE 'user'='USER1'

Correct answer: C

Explanation

The correct answer is C because it follows the proper SQL syntax: SELECT statement comes first, followed by the FROM clause, the WHERE condition, and finally the GROUP BY clause. The other options either misplace the clauses or use incorrect SQL syntax, making them invalid queries.