NSE 5 — FortiAnalyzer 7.2 — Question 36

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

Answer options

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

Correct answer: C

Explanation

The correct answer is C because it follows the proper SQL syntax by first selecting the columns, then specifying the source table, applying the WHERE clause for filtering, and finally grouping the results. Options A, B, and D do not follow the correct SQL order, making them invalid for querying the database.