Multiple choice technology databases

Which of the following is a typical data warehouse query?

  1. What is this customer’s address?

  2. Does this customer have any unpaid bills?

  3. What is the balance in this customer’s account?

  4. What is the total sales for each of the last 6 months?

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Typical data warehouse queries are analytical and historical, examining trends over time like total sales across months. Options A, B, and C are operational OLTP queries for individual customer transactions, which are characteristic of operational systems, not data warehouses.