DS0-001 Question #18: Real Exam Question with Answer & Explanation

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?

Options

• ACreate a materialized view.
• BCreate indexes on those tables.
• CCreate a new database.
• DCreate a function.

Explanation

The best way for the administrator to accomplish this task is to create a materialized view. A materialized view is a type of view that stores the result of a query on one or more tables as a separate table in the database. A materialized view can aggregate data from multiple tables in a way that does not impact the original tables, and then provide this information to a department as a single source of truth. A materialized view also improves query performance and efficiency by reducing the need to recompute complex queries every time they are executed. The other options are either not suitable or not optimal for this task. For example, creating indexes on those tables may improve query performance on individual tables, but not on aggregated data; creating a new database may require additional resources and maintenance, and may introduce inconsistency or redundancy; creating a function may require additional coding and execution, and may not store the result as a separate table.

No community discussion yet for this question.