Question
A database administrator needs to aggregate data from multiple tables in a way that does not impact the original tables, and then provide this information to a department. Which of the following is the best way for the administrator to accomplish this task?
- A. Create a materialized view. Correct
- B. Create indexes on those tables.
- C. Create a new database.
- D. Create a function.
Explanation
A materialized view runs the aggregation query once and stores its result as a separate object that the department can query, without changing or locking the original tables for each read; it can be refreshed on a schedule. Indexes speed up queries but do not aggregate anything, a new database is unnecessary overhead, and a function returns computed values but does not provide a stored, queryable data set.
