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

Exam NSE5_FAZ-7.0 All Questions

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

Exam NSE5_FAZ-7.0 topic 1 question 15 discussion

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

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

  • 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'
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Khs01 at Nov. 19, 2022, 10:29 a.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
[Removed]
10 months, 1 week ago
C is correct
upvoted 1 times
...
chyeahhh
11 months, 3 weeks ago
can confirm this was on exam today (6/15)
upvoted 1 times
...
KP001
1 year, 5 months ago
C is correct. SELECT - FROM - GROUP
upvoted 1 times
...
nerostart
1 year, 5 months ago
Selected Answer: C
FortiAnalyzer_7.0_Study_Guide-Online.pdf page 317 - SQL and Dataset
upvoted 1 times
...
lucient
1 year, 5 months ago
Selected Answer: C
C) FortiAnalyzer_7.0_Study_Guide-Online.pdf page 259: The main clauses FortiAnalyzer reports use are as follows: •FROM •WHERE •GROUP BY •ORDER BY • LIMIT • OFFSET 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.
upvoted 3 times
...
Khs01
1 year, 6 months ago
C is OK!
upvoted 1 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