You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a sales report by using SQL Server 2008 Reporting Services (SSRS). The report is used by managers in a specific country.
Each manager prints multiple copies of the report that contains the previous day’s sales for each of their sales executives.
You need to ensure that the report uses the minimum number of round trips to the database server.
What should you do?
A.
Query the database for both Country and Sales Executive.
B.
Implement report filtering for both Country and Sales Executive.
C.
Implement report filtering for Country and query the data source for Sales Executive.
D.
Implement report filtering for Sales Executive and query the data source for Country.
Explanation:
Tip: "multiple copies … round trips" = "report Sales / query Country"http://technet.microsoft.com/en-us/library/dd239395.aspx
Choosing When to Set a Filter
Specify filters for report items when you cannot filter data at the source. For example, use report filters when the data source does not support query parameters, or you must run stored procedures and cannot modify the query, or a parameterized report snapshot displays customized data for different users.You can filter report data before or after it is retrieved for a report dataset. To filter data before it is retrieved, change the query for each dataset. When you filter data in the query, you filter data at the data source, which reduces the amount data that must be retrieved and processed in a report. To filter data after it is retrieved, create filter expressions in the report. You can set filter expressions for a dataset, a data region, or a group, including detail groups. You can also include parameters in filter expressions, providing a way to filter data for specific values or for specific users, for example, filtering on a value that identifies the user viewing the report.