QuestionQ34

VerifiedDatabase Fundamentals

A database administrator must aggregate data from multiple tables without affecting the original tables, then provide the resulting information to a department. Which of the following is the best way for the administrator to accomplish this task?

Explanation

A materialized view stores the results of a query over one or more base tables, including aggregated data, without changing the source tables. It provides a separate, refreshable dataset that can be made available to the department.

Community Discussion

No comments yet. Be the first to start the discussion!