Zabbix Database Management and Tuning
Exam Questions With Correct Answers
(Verified Answers) Plus Rationales 2026 Q&A |
Instant Download Pdf
1. What is the primary database role in Zabbix architecture?
A. Store configuration, historical data, and events
B. Render dashboards
C. Execute monitoring checks
D. Manage user authentication only
Answer: A
Rationale: Zabbix relies on its database as the central storage for
configuration data, monitoring history, trends, events, and
operational metadata. While other components handle checks
and UI, the database is the system of record.
2. Which database type is officially supported by Zabbix for
production use?
A. MongoDB
B. PostgreSQL
, C. Cassandra
D. Redis
Answer: B
Rationale: Zabbix officially supports relational databases such as
PostgreSQL and MySQL/MariaDB, with PostgreSQL often
preferred for performance and scalability in large environments.
3. What table type holds historical time-series data in Zabbix?
A. users
B. history
C. hosts
D. triggers
Answer: B
Rationale: The history tables (such as history, history_uint,
history_str) store raw time-series monitoring data collected from
items.
4. What is the purpose of trend tables in Zabbix?
A. Store raw per-second metrics
B. Store aggregated hourly/daily data
C. Store user permissions
D. Store trigger expressions
Answer: B
, Rationale: Trend tables store aggregated data (min, max, avg,
count) over longer periods, reducing database size and
improving query performance for long-term analysis.
5. Which Zabbix component writes data into the database?
A. Zabbix frontend only
B. Zabbix server
C. Zabbix proxy only
D. SNMP agents only
Answer: B
Rationale: The Zabbix server is primarily responsible for writing
collected data into the database, including history, trends, and
events.
6. What is a common cause of database performance issues in
Zabbix?
A. Too few users logged in
B. Excessive historical data retention
C. Too many dashboards
D. Too many proxies
Answer: B
Rationale: Large volumes of historical data without proper
, retention policies significantly increase table sizes and slow
down queries and inserts.
7. What does housekeeper process do in Zabbix?
A. Manages user sessions
B. Deletes outdated historical and trend data
C. Encrypts database tables
D. Balances database load
Answer: B
Rationale: The housekeeper cleans up old data based on
retention policies, preventing uncontrolled database growth.
8. Which technique helps improve Zabbix database performance?
A. Disable indexing
B. Increase history retention indefinitely
C. Partitioning tables
D. Store everything in history tables
Answer: C
Rationale: Table partitioning improves performance by splitting
large history/trend tables into smaller, manageable chunks.
9. Why are history_uint tables used?
A. Store string values
B. Store unsigned integer metrics
Exam Questions With Correct Answers
(Verified Answers) Plus Rationales 2026 Q&A |
Instant Download Pdf
1. What is the primary database role in Zabbix architecture?
A. Store configuration, historical data, and events
B. Render dashboards
C. Execute monitoring checks
D. Manage user authentication only
Answer: A
Rationale: Zabbix relies on its database as the central storage for
configuration data, monitoring history, trends, events, and
operational metadata. While other components handle checks
and UI, the database is the system of record.
2. Which database type is officially supported by Zabbix for
production use?
A. MongoDB
B. PostgreSQL
, C. Cassandra
D. Redis
Answer: B
Rationale: Zabbix officially supports relational databases such as
PostgreSQL and MySQL/MariaDB, with PostgreSQL often
preferred for performance and scalability in large environments.
3. What table type holds historical time-series data in Zabbix?
A. users
B. history
C. hosts
D. triggers
Answer: B
Rationale: The history tables (such as history, history_uint,
history_str) store raw time-series monitoring data collected from
items.
4. What is the purpose of trend tables in Zabbix?
A. Store raw per-second metrics
B. Store aggregated hourly/daily data
C. Store user permissions
D. Store trigger expressions
Answer: B
, Rationale: Trend tables store aggregated data (min, max, avg,
count) over longer periods, reducing database size and
improving query performance for long-term analysis.
5. Which Zabbix component writes data into the database?
A. Zabbix frontend only
B. Zabbix server
C. Zabbix proxy only
D. SNMP agents only
Answer: B
Rationale: The Zabbix server is primarily responsible for writing
collected data into the database, including history, trends, and
events.
6. What is a common cause of database performance issues in
Zabbix?
A. Too few users logged in
B. Excessive historical data retention
C. Too many dashboards
D. Too many proxies
Answer: B
Rationale: Large volumes of historical data without proper
, retention policies significantly increase table sizes and slow
down queries and inserts.
7. What does housekeeper process do in Zabbix?
A. Manages user sessions
B. Deletes outdated historical and trend data
C. Encrypts database tables
D. Balances database load
Answer: B
Rationale: The housekeeper cleans up old data based on
retention policies, preventing uncontrolled database growth.
8. Which technique helps improve Zabbix database performance?
A. Disable indexing
B. Increase history retention indefinitely
C. Partitioning tables
D. Store everything in history tables
Answer: C
Rationale: Table partitioning improves performance by splitting
large history/trend tables into smaller, manageable chunks.
9. Why are history_uint tables used?
A. Store string values
B. Store unsigned integer metrics
