70-448 · Question #28
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…
The correct answer is C. You should develop a data source view and select only the required tables and views. 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…
Question
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?
Options
- AYou should develop DataSet using the Web Service to Schema(s) option.
- BYou should develop DataTable using the Web Service to Schema(s) option.
- CYou should develop a data source view and select only the required tables and views.
- DYou should set the data source view in the setting file.
How the community answered
(38 responses)- A8% (3)
- B5% (2)
- C71% (27)
- D16% (6)
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.
Topics
Community Discussion
No community discussion yet for this question.