PrepAway - Latest Free Exam Questions & Answers

What action should you perform to accomplish this task?

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Reporting Services (SSRS) for the company.
You use SSRS to design a report with a dataset contained. Besides, the dataset uses a stored procedure to regain data resources.
With the use of the dataset, a table and a matrix are contained in the report.

Now you are assigned a task to limit the data displayed in the table without affecting the data displayed in the matrix.
What action should you perform to accomplish this task?

PrepAway - Latest Free Exam Questions & Answers

A.
A filter should be added to the table

B.
A parameter should be added to the stored procedure with the result set filtered

C.
A filter should be added to the stored procedure.

D.
A filter should be added to the dataset

E.
A filter should be added to the matrix


Leave a Reply