Microsoft-PRO Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 Set 4

You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. Now you??re in charge of designing SQL Server2008 Integration Services (SSIS) projects. You intend to deploy the projects in the following manner: A parent package on an instance that is named SSIS1.Three child packages individually on three instances that are named SSIS2, SSIS3, and SSIS4. So what should you do to make sure that the parent package can discover the execution state of the child packages?

You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. You work out a SQL Server 2008 Analysis Services (SSAS) solution. Customer data is stored in the tables named CustomerContact and CustomerDetails. The solution utilizes the following two data sources from two different servers: ContosoCRM that accesses the CustomerContact table Contoso that accesses the CustomerDetails tableYou intend to create a dimension named DimCustomer that analyzes customer data. You have to make sure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. So what should you do to ensure this?

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. You create a SQL Server 2008 Reporting Services (SSRS) solution which has a report named SellDetails. The report contains a parameter named WorkerID. You have the following constraints: Eight thousand employees need the report to be in different file formats.The employees can view only their sales data by specifying their identity number as the EmployeeID parameter. You have to make sure that before you deliver the report to the workers, the constraints are met. So what should you do?

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution.A SQL Server 2008 Analysis Services (SSAS) solution includes a cube that has the following objects: Measures named TotalSales and InternetSalesDimensions named DimCustomer, DimProduct, and DimGeographyBy authenticating with their Windows accounts, users run reports against all dimensions and measures.You have to offer the users a basic view of data to display only DimGeography, DimProduct, and TotalSales while using as little storage space as possible. So what should you do?

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. A SQL Server 2008 instance is used by the SQL Server 2008 Integration Services (SSIS) developers as the primary development environment. All the SSIS packages contain data connection managers that use SQL Server authentication to extract data. All the SSIS packages contain data connection managers that use SQL Server authentication to extract data. You intend to use an automated script to perform the package migration from the development environment to a production environment. You must make sure that the packages execute while no error occur in the production environment. So what should you do?

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. And you develop a SQL Server 2008 Reporting Services (SSRS) solution. You use Microsoft Visual Studio .NET 2008 to create reports. The manager of your company asks to create 60 SSRS reports. You mustmake sure that the company logo and the company name are included in the page header of all the reports. So what should you do?

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. You use SQL Server 2008 to work out a SQL Server 2008 Analysis Services (SSAS) solution. A source database which contains a table named Client is tilized in the solution. And the Client table contains lots ofcolumns. You have read-only access to the database. You intend to cut down the number of columns in the Client table. You have to split the Client table to be distributed across multiple table definitions. So what should you do?

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. You intend to create a SQL Server 2008 Reporting Services (SSRS) solution. Developers generate random reports against a data source that contains 180 tables. Power users generate random reports against five of the 180 tables. You have to design a strategy for the SSRS solution to satisfy the following requirements: Use as little development effort as possible.Supply the developers group and the power users group with two sets of tables in SSRS.So which strategy will you use?

You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. You work out a solution to analyze the usage of discount vouchers issued by the company. There are two columns in the dimension table, respectively named ClientFullName and VoucherNumber. A value for the ClientFullName column is not available until the voucher is used. Even if there is a NULL value in the ClientFullName column, the slowly Changing imension transformation must be configured to load the Vouchers dimension. So what should you do?

You are the administrator of your company network. And now you??re in charge of SQL Server 2008 Analysis Services (SSAS) data mining. You create a data mining solution which collects data from three different operational source systems. You noticed that when the operational source systems are accessed directly, performance problems occur. During the off- duty time, the solution is updated continuously by using current data on a daily basis. What should you do to integrate data for the data mining solution without causing performance problems?