MS SSRS

You design a report by using SQL Server 2008 Reporting Services (SSRS). The report will be included in a Windows Forms application that is distributed to remote users. These users have no access to the report server. You need to ensure that the application renders the report correctly. What should you do?

You maintain a SQL Server 2008 Reporting Services (SSRS) instance.
The network security model for the domain that hosts the instance changes.
You need to ensure that the instance will only support Kerberos authentication.
What should you do?

You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instance.
The report contains query parameters that allow users to filter the contents of the report.
The report queries the data source randomly.
You configure the report to be rendered from a report execution snapshot.
You need to ensure that users can continue to use parameters to filter the report.
What should you do?

You install and configure SQL Server 2008 Reporting Services (SSRS) instance. The users of the report server plan to deliver reports through e-mail messages. You need to configure the report server for e-mail message delivery by using a remote SMTP server. What should you do?

You maintain an instance of SQL Server 2008 Reporting Services (SSRS). The instance contains several reports.
You deploy a report project on the instance by using the Business Intelligence
Development Studio (BIDS). You discover that the production data sources on the instance are replaced by the test data sources of the report project.
You need to ensure that when the report project is deployed in future, the existing reports are unaffected.
What should you do?

You create a SQL Server 2008 Reporting Services (SSRS) report. You plan to create a list of customers by using a List control. For each customer in the List control, you plan to include a table that contains the orders for that customer. The customer data is stored in the Customers table in the data source, and the order data is stored in the Orders table. You need to define the required dataset or datasets for this report. What should you do?

You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com. Assembly should be created in order to run real-time lookup and currency conversion. The assembly has a static class named daily which lives in the namespace HomeCalc. there is a method called DMO which need two arguments, Cuurnt and HomeCalc When the report is operating, you should reference the ToEUR method in an expression to convert USD to USO. Which is the correct answer?

You develop a SQL Server 2008 Reporting Services (SSRS) report. A Multidimensional Expressions (MDX) query used in the report contains a parameter to display sales data for various product categories. You write the following query. You discover that the query generates an error when executed. You need to ensure that the query executes successfully. What should you do?

You create a SQL Server 2008 Reporting Services (SSRS) report. The report contains a report header and a report footer. The report preview shows that the report is rendered correctly. You discover that when the report is rendered as a PDF file, even-numbered pages are rendered blank. You need to modify the report to prevent the rendering of blank pages. What should you do?

You create a SQL Server 2008 Reporting Services (SSRS) report that contains a dataset. The dataset retrieves data by executing a stored procedure. The report contains a table and a matrix that use the dataset. You need to limit data that is displayed in the table while ensuring that the matrix is unaffected. What should you do?