What is a derived data source?

What is a derived data source?

• A. A data source created by combining multiple unrelated data sets without joins.
• B. A data source that is a backup copy of the base data source.
• C. A data source created by applying filters/joins to a base data source, producing a new reporting view.
• D. A data source that is read-only and cannot be modified.

Answer: (C)

A derived data source is a reporting view created from a base data source by applying transformations such as filters and joins. This builds a new, tailored view that pulls together the exact fields and related data you need for a specific report. That’s exactly what the option describes: you start with a base data source, apply filters and joins, and end up with a new reporting view. It’s not just a backup copy of the base data, and it isn’t simply a collection of unrelated datasets—the derived source defines relationships and selections to present coherent data for reporting. For example, you might derive a view from a base employee data source by filtering to a particular department and joining in payroll data to include compensation, producing a single, report-ready dataset.

A derived data source is a reporting view created from a base data source by applying transformations such as filters and joins. This builds a new, tailored view that pulls together the exact fields and related data you need for a specific report. That’s exactly what the option describes: you start with a base data source, apply filters and joins, and end up with a new reporting view. It’s not just a backup copy of the base data, and it isn’t simply a collection of unrelated datasets—the derived source defines relationships and selections to present coherent data for reporting. For example, you might derive a view from a base employee data source by filtering to a particular department and joining in payroll data to include compensation, producing a single, report-ready dataset.