When designing reports for performance, what technique can help reduce query execution time?

When designing reports for performance, what technique can help reduce query execution time?
A . Including multiple complex SQL functions in the queries.
B . Storing pre-aggregated data in the reporting database.
C . Using a higher level of normalization in the database schema.
D . Running reports during peak business hours to improve response time.

Answer: B