Multiple choice technology databases

For which of the following is a data warehouse optimized?

  1. Backup and Recovery

  2. Transactions

  3. Security

  4. Queries

Reveal answer Fill a bubble to check yourself
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.