You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services (SSRS) solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements:

Uses minimum amount of development effort.

Provides two sets of tables in SSRS to the developers group and the

power users group. Which strategy should you use?

Question

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services (SSRS) solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements:

Uses minimum amount of development effort.
Provides two sets of tables in SSRS to the developers group and the

power users group. Which strategy should you use?

Accepted Answer

B. Create a Report Builder model by using all the tables

Answer

A. Create two Report Builder models.Include the four frequently used tables in the first model and all

Answer

C. Create a Report Builder model by using all the tables.

Answer

D. Create two Data Source Views.Include all the tables in one Data Source View and the four

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services (SSRS) solution. Developers generate random reports against a data…

Question

Options

How the community answered

Community Discussion