You are designing a data mining structure for a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. The solution requires the use of relational data. You need to design the data mining structure so that the data mining models can use the data from a case table and a nested table. What should you do?

You are designing a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. The SSAS database includes a data mining model that uses the Microsoft Neural Network algorithm. You use Prediction Query Builder in Microsoft SQL Server Management Studio (SSMS) to build the Data Mining Extensions (DMX) queries for the database. You need to write a query that returns the number of cases in the data mining model and the percentage of the sample cases that fit the model. Which Prediction Query Builder field configuration should you use?

You are analyzing a data mining structure that is hosted on a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You view the classification matrix for a data mining structure as shown in the following exhibit. (Click the Exhibit button.) You need to modify the parameters of the data mining model that has the largest percentage of inaccurate predictions. Which data mining model should you modify?

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 administering a Microsoft SQL Server 2005 Reporting Services (SSRS) solution. SSRS is installed on 10 Web servers in a Network Load Balancing configuration. When the SSRS service starts, only the first Web server makes connections to the Report Server database. You need to connect additional Web servers in the SSRS Web farm. What should you do?

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 administer a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You need to edit the items that are included within the <Extension> subelement of the <Render> element in the RSReportServer.config file so that all the reports render only to Microsoft Excel. What should you do?

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 managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You have a machine named COMPANYCUBE for a SSAS instance. The COMPANYCUBE machine hosts a SSAS database that has a cube named HR. You need to restrict the local administrators from accessing any data stored in the HR cube. What should you do?