For which of the following is a data warehouse optimized?
-
Backup and Recovery
-
Transactions
-
Security
-
Queries
D
Correct answer
Explanation
Data warehouses are optimized primarily for query performance and analytics, not transaction processing. They support complex read-heavy queries for reporting and decision-making. Backup/recovery, security, and transactions are OLTP concerns.