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

The correct answer is D. SELECT devid FROM $log WHERE 'user'='USER1' GROUP BY devid. The main clauses FortiAnalyzer reports use are as follows: Accordingly, following the SELECT keyword, the statement must be followed by one or more clauses in the order in which they appear in the table shown on this slide.

Logging and Monitoring

Question

Options

ASELECT devid FROM $log GROUP BY devid WHERE 'user'='USER1'
BSELECT FROM $log WHERE devid 'user'='USER1' GROUP BY devid
CSELECT devid WHERE 'user'='USER1' FROM $log GROUP BY devid
DSELECT devid FROM $log WHERE 'user'='USER1' GROUP BY devid

How the community answered

(42 responses)

A
5% (2)
B
2% (1)
C
14% (6)
D
79% (33)

Explanation

The main clauses FortiAnalyzer reports use are as follows: Accordingly, following the SELECT keyword, the statement must be followed by one or more clauses in the order in which they appear in the table shown on this slide.

Topics

#SQL query#SELECT statement#log database#query syntax

Community Discussion

No community discussion yet for this question.

Full FCP_FAZ_AN-7.4 Practice