View all questions & answers for the NSE 5 - FortiAnalyzer 7.6 Analyst Exam Materials exam


Question 18 Discussion

Refer to the exhibit. A FortiAnalyzer analyst is customizing a SQL query to use in a report. Which SQL query should the analyst run to get the expected results? (Choose one answer)

  • A. SELECT srcip AS "Source IP", dstport AS "Destination Port" ORDER BY dstport DESC GROUP BY srcip, dstport FROM $log WHERE $filter AND srcip = '10.0.1.10'
  • B. SELECT srcip AS "Source IP", dstport AS "Destination Port" FROM $log WHERE $filter AND srcip = '10.0.1.10' GROUP BY srcip, dstport ORDER BY dstport DESC
  • C. SELECT srcip AS "Source IP", dstport AS "Destination Port" FROM $log WHERE $filter AND Source IP != '10.0.1.10' GROUP BY srcip, dstport ORDER BY dstport DESC
  • D. SELECT srcip AS "Source IP", dstport AS "Destination Port" FROM $log WHERE $filter AND srcip = '10.0.1.10' ORDER BY dstport GROUP BY srcip, dstport DESC
Correct Answer: B

Brave-Dump Clients Votes

B 100%

Comments



Anonymous User 2026-03-06 15:51:26

Selected Answers: B


SELECT ... FROM ... WHERE ... GROUP BY ... ORDER BY eliminates A and D
C contains an invalid column (Source IP) and an invalid condition (!=)