What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report model. Users must develop their own SSRS reports by using your report model in the Report Builder tool. The data source for the report model is a Microsoft SQL Server 2000 database that contains 900 tables and 700 views. You need to build a report model that allows users access to only the 10 tables that they require for reporting. What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report model. Users must develop their own SSRS reports by using your report model in the Report Builder tool. The data source for the report model is a Microsoft SQL Server 2000 database that contains 900 tables and 700 views. You need to build a report model that allows users access to only the 10 tables that they require for reporting. What should you do?

A.
Select the Create roles rule when you generate the report model.

B.
Create a data source view and select the Restrict to Schema(s) option.

C.
Create a data source view and select only the required tables and views.

D.
Clear the Create entities for all tables rule when you generate the report model.



Leave a Reply 0

Your email address will not be published. Required fields are marked *