____ allows selection of the relevant information necessary for the data…

2015

____ allows selection of the relevant information necessary for the data warehouse:

  1. A.

    The Top-Down View

  2. B.

    Data Warehouse View

  3. C.

    Datasource View

  4. D.

    Business Query View

Attempted by 78 students.

Show answer & explanation

Correct answer: A

Correct answer: The Top-Down View.

Explanation: The Top-Down View begins with business requirements and decisions to be supported, and from there identifies the subject areas, measures, and dimensions that the data warehouse must contain. This ensures selection of the relevant information needed for analytics and reporting.

  • Start with business needs: identify the decisions and reports the warehouse must support.

  • Determine subject areas and key data elements (facts and dimensions) required to meet those needs.

  • Map those required elements to source systems and design extraction and integration as needed.

Why the other views are less appropriate:

  • Data Warehouse View: Describes the overall architecture or organization of the warehouse, but does not itself drive the identification of business-relevant data.

  • Datasource View: Focuses on source systems and extraction; useful for integration planning but source-centric rather than requirement-driven selection.

  • Business Query View: Centers on how users query and report; helpful for design tuning, but it represents usage patterns rather than the top-down selection process.

Explore the full course: Mppsc Assistant Professor