Discuss Fortinet FCP_FAZ_AN-7.6 Exam Topic 1 Question 7

In firmware version 7.6, how does on-premises FortiAnalyzer store logs? (Choose one answer)

AUses ClickHouse database

BUses MySQL database

CUses Postgres SQL database

DUses ElasticSeach database

Suggested Answer: A

Comprehensive and Detailed Explanation From Exact Extract of knowledge of FortiAnalyzer 7.6 Study guide documents:

FortiAnalyzer 7.6 stores on-premises logs in a ClickHouse SQL database (not MySQL, Postgres, or Elasticsearch). Fortinet's FortiAnalyzer 7.6 SQL Query documentation explicitly states that log data is inserted into the SQL database and that ''FortiAnalyzer uses a ClickHouse SQL database.''

This is consistent with how the study guide describes the storage/analytics pipeline in 7.6: it explains that FortiAnalyzer indexes incoming raw logs (insert rate) ''by the SQL database and the sqlplugind daemon.'' This ''SQL database'' in 7.6 corresponds to the ClickHouse-backed log database described in the Fortinet documentation.

Get Premium FCP_FAZ_AN-7.6 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

26 comments · newest first

Jacquelyne 1 month ago

D) ElasticSearch is great for searching logs, but not for storage.

Herminia 1 month ago

C) Postgres SQL could work, but not sure it's the best choice.

Lilli 2 months ago

I feel B) MySQL is more common for log storage.

Gerald 2 months ago

I think it's A) ClickHouse. It's optimized for analytics.

Dahlia 2 months ago

I’m going with D) ElasticSearch database. Great for log storage!

Aliza 2 months ago

I feel C) Postgres SQL database is the right choice. Good performance.

Shantell 2 months ago

I’m leaning towards B) MySQL database. It’s widely used.

Catalina 2 months ago

I think it's A) ClickHouse database. Seems modern.

Kristel 3 months ago

I’m going with D) ElasticSearch database. Great for log storage and searching!

Elenore 3 months ago

I feel like C) Postgres SQL database could be the answer. It’s powerful for complex queries.

Corrina 3 months ago

I’m leaning towards B) MySQL database. It’s widely used and reliable.

Katlyn 3 months ago

I think it's A) ClickHouse database. It’s optimized for analytics.

Lezlie 3 months ago

Yeah, I've seen it in the release notes!

Jutta 4 months ago

Wait, is that really true?

Tawny 5 months ago

Definitely ClickHouse, no doubt!

Sarina 5 months ago

I thought it was MySQL?

Lauran 5 months ago

A) Uses ClickHouse database

Bong 6 months ago

ClickHouse is the way to go for performance!

Sunny 6 months ago

Wait, are you sure? I thought they switched to PostgreSQL.

Aja 6 months ago

Definitely ClickHouse, I've read that somewhere.

Marg 6 months ago

I thought it was MySQL?

Adela 6 months ago

A) Uses ClickHouse database.

Eloisa 6 months ago

I recall reading about ClickHouse in the context of FortiAnalyzer, but I can't remember if it was for version 7.6 specifically.

Jonell 7 months ago

I’m a bit confused; I thought FortiAnalyzer might use ElasticSearch, but that seems more common for other products.

Karon 7 months ago

I practiced a similar question last week, and I feel like MySQL was mentioned as the primary database for log storage.

Ronald 7 months ago

I think I remember something about FortiAnalyzer using a specific database for logs, but I'm not entirely sure if it's ClickHouse or MySQL.

Fortinet FCP_FAZ_AN-7.6 Exam - Topic 1 Question 7 Discussion