Microsoft-TS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance Set 4

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Reporting Services (SSRS) package for Abc.com. The SSRS package includes a parameter named @ProductID. You need to configure the value of the @ProductID parameter in the report by selecting a particular region. You have to ensure that the report is set to stop clients from modifying the value of the @ProductID parameter. What should you do?

You work as a database administrator at Abc.com. You are currently creating a SQL Server 2008 Reporting Services (SSRS) instance for Abc.com. You need to ensure that the reports only render to Microsoft Excel. You thus want to compile the items contained in the sub element of the element in the RSReportServer.config file. What else should you do?

You work as a systems administrator for Abc.com. You are responsible for managing a SQL Server 2008 Reporting Services (SSRS) sample for Abc.com. A Abc.com user named Amy Walsh published numerous reports to the SSRS sample by accident. You need to determine a way to recover the status of the SSRS sample prior to the reports published on it. What should you do?

You work as a database administrator at Abc.com. Your duties include managing a Microsoft SQL Server 2008 Reporting Services (SSRS) instance for Abc.com. You need to assign Abc.com users in the Marketing department to a predefined security role that allows the users to read all the report definitions. What should you do?

You work as a database administrator at Abc.com. Your duties include managing a SQL Server 2008 Reporting Services (SSRS) sample for Abc.com. You need to allow Abc.com users to transfer reports using e-mail. You have to ensure that the server is configured for e-mail delivery. What should you do?

You work as a database administrator at Abc.com. Your duties include administrating a SQL Server 2008 Reporting Services (SSRS) sample. The SSRS sample does not provide some rendering extensions. You need to ensure that the server is configured to render to Microsoft Word. What should you do?

You work as a database administrator at Abc.com. You are in the process of operating a SQL Server 2008 Reporting Services (SSRS) instance. You need to provide Abc.com users with the necessary permissions to deploy reports and manage the content in a private folder. You want to accomplish this task by adding a role to the SSRS instance. What should you do?

You work as a database administrator at Abc.com. The Abc.com network contains a SQL Server 2008 report server named ABC-DB02. ABC-DB01 is currently configured to allow all user groups to run reports in any folder on the server. You are in the process of creating a new SQL Server 2008 Reporting Services (SSRS) instance in a folder named CKData on ABC-DB02. You need to ensure that only departmental managers are able to browse and change reports in CKData. What should you do?

You work as a database administrator at Abc.com. The Abc.com network contains a SQL Server 2008 Network Load Balancing (NLB) cluster that consists of two nodes. Internet Information Services (IIS) is installed on both nodes of the NLB cluster. You are in the process of deploying a SQL Server 2008 Reporting Services (SSRS) instance for Abc.com. You decide to publish the SSRS on the NLB cluster. You want to publish SSRS in a fault- tolerant scale-out deployment. What should you do?

You work as a database administrator at Abc.com. Your duties include creating a SQL Server 2008 Reporting Services (SSRS) report for Abc.com. The data source for the SSRS report is a Transact-SQL stored procedure that does not have any input parameters. The stored procedure returns all records in a set of tables. There are five other applications on the SQL Server 2008 computer that also make use of the stored procedure. You need to limit the amount of data that is displayed on the report without impacting on any other applications that also make use of the stored procedure. What should you do?