Microsoft-TS Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance Set 2

You are administering a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You need to assign a group of users a predefined security role that permits them to read all the report definitions. Which role should you assign to the group?

You are creating a Microsoft SQL Server 2005 Reporting Services (SSRS) report. You deploy a new report by using Business Intelligence Development Studio (BIDS) from a test environment. Previously deployed reports display errors indicating unavailable production servers. You need to modify the SSRS project by using BIDS to allow the previously deployed data sources to work properly. What should you do?

You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) solution. The current reporting solution consists of a single computer that hosts both the Web server components and the database server components of SSRS. This computer is dedicated to the sales department. The company security policy requires a separate SSRS solution for the payroll department. There is no budget for any new hardware. You need to isolate the security models of each department without using separate Web servers or database servers. What should you do?

You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You need to perform the following tasks: Permit data sources to use the No credentials option. Access Report Manager by using Secure Sockets Layer (SSL). Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. The following events must occur at 2:00 on every Sunday: A data-driven subscription for the Human Resources report must write to several file shares. The execution of the Sales report must expire. The history of the Manufacturing report must include a new state of the data. You need to configure the package so that the events occur and are exposed for a single-step batch job. What should you do?

You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You have deployed a Microsoft SQL Server 2005 Analysis Services (SSAS) based data source named PhoneMetrics that accesses the PhoneMetrics cube. You need to permit clients to create ad hoc reports from the Web. What should you do?

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. The instance contains cubes that use the HOLAP storage mode. The retrieval of data from the cubes is slow. You need to monitor the frequency with which the users access a member of each cell in a cube in System Monitor. What should you do?

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You have a cube in an SSAS instance. You notice that the queries run slowly. You need to identify the queries that run slowly and change the storage configuration of the cube. What should you do?

You are designing Microsoft SQL Server 2005 Analysis Services (SSAS) cubes for two business units. Each business unit has the following requirements: Full administrative access only to its own cubes and not to the cubes of the other unit. Ability to run its cubes on a different computer in the event of a hardware failure. You need to install SSAS in a configuration to create cubes that meet the above requirements. Which instance should you use?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) solution by using Business Intelligence Development Studio (BIDS). The SSAS instance runs under a local system account. A trust relationship exists between the machine that hosts the SSAS instance and the data source. You need to use the Impersonation Information dialog box to create a data source that SSAS can connect to when SSAS is deployed from any workstation. Which impersonation information should you use?