You are developing a SQL Server 2008 Reporting Services (SSRS) instance of report model for Company.com.
In the Report Builder tool, the users should need to create their SSRS reports.
The data source they used will include a Microsoft SQL Server 2008 database. Which include 1000 tables?
You should design the report model for users, and allow access to only the 20 tables which they require for reporting. Which is the correct answer?
A.
You should develop DataSet using the Web Service to Schema(s) option.
B.
You should develop DataTable using the Web Service to Schema(s) option.
C.
You should develop a data source view and select only the required tables and views.
D.
You should set the data source view in the setting file.
Explanation:
Data source view (DSV ) Abstracts the underlying database schema. Although a DSV might seem redundant, it can be very useful by letting you augment the schema. For example, you can add calculated columns to a DSV when security policies prevent you from changing the database schema.