ExamTopics Logo
Mail Us[email protected]
Menu
Fortinet Discussions
exam questions

Exam NSE5_FAZ-7.2 All Questions

View all questions & answers for the NSE5_FAZ-7.2 exam
Go to Exam

Exam NSE5_FAZ-7.2 topic 1 question 38 discussion

Actual exam question from Fortinet's NSE5_FAZ-7.2
Question #: 38
Topic #: 1
[All NSE5_FAZ-7.2 Questions]

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

  • 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
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by GriffXX at March 26, 2024, 3:49 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Aminshon
6 months, 1 week ago
Selected Answer: C
The order is : SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET. FortiAnalyzer_Analyst_7.2_Study_Guide page 11
upvoted 1 times
...
GriffXX
8 months, 1 week ago
C is correct. There is a mandatory sequence of SQL commands (if they are used, after SELECT and FROM, the rest are optional) Page 141 of 7.2 Study Guide. The order is : SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel