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.