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

You administer a server that runs SQL Server 2008 Integration Services (SSIS) packages. The packages are stored on the file system. You need to integrate the backup and restore processes for the SSIS packages along with the regular SQL Server backup process. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop a SQL Server 2008 Analysis Services (SSAS) project and use Microsoft Visual Source Safe (VSS) as the source control system. After making changes to the project, you check in the files to the VSS. Then, you deploy the project to a shared server for testing. Four new developers are assigned to work in parallel on the project. You need to ensure that the new developers can modify the most recent version of the project and test it without affecting the work of the existing developers. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a logging strategy for all SQL Server 2008 Integration Services (SSIS) packages for your company. You want to log errors that occur in all existing and future packages to a SQL Server 2008 table. You need to design the strategy to meet the following requirements: -The logging mechanism must be reused by each package. -Changes to the logging mechanism must be applied to all packages by using the minimum amount of administrative effort. What should you do?

You administer a SQL Server 2005 Reporting Services server. Your company publishes reports to a public Web site. Customers can view the reports without providing user credentials. You plan to upgrade the server to use SQL Server 2008 Reporting Services. You need to ensure that customers can continue to view the reports without providing user credentials. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services (SSAS) solution. The solution contains a cube named SalesCube to analyze sales data. The cube has the following objects: Dimensions named Product and Customer Measure named SalesAmount The organization commences online sales transactions. The SalesCube cube must be modified to add a new dimension named Geography and a new measure named InternetSales. You need to ensure that users can browse through the previous version of the SalesCube cube. You also need to ensure that users are denied access to the new objects. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a solution that analyzes the usage of discount vouchers issued by the company. The data warehouse of the company contains a dimension table named Vouchers. The dimension table contains two columns named VoucherNumber and CustomerFullName. A value for the CustomerFullName column is not available till the voucher is used. You need to configure the Slowly Changing Dimension transformation to load the Vouchers dimension even if there is a NULL value in the CustomerFullName column. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The SQL Server 2008 instance hosts a database. The database is currently scheduled for a full backup on a monthly basis. The 4-terabyte database contains 3.5 terabyte of data in a read-only filegroup. The database uses the bulk- logged recovery model. You need to back up the database changes to a tape drive every night by using minimum storage space and time. Which backup strategy should you use?

You design a SQL Server 2008 Reporting Services (SSRS) solution. The solution contains a report. The report includes information that is grouped into hierarchical levels. You need to ensure that the solution meets the following requirements: When you click each level, the next level of information must be displayed. When you click the last level, detailed information must be displayed. When the report is exported to a Microsoft Excel spreadsheet, all the levels and all detailed information must be available in the spreadsheet. Which feature should the report use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to develop SQL Server 2008 Reporting Services (SSRS) reports. Several reports will contain identical data regions. You need to minimize the amount of maintenance when changes are made to the data regions. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services (SSAS) database. A cube in the database contains a large dimension named Customers. The database uses a data source that is located on a remote server. Each day, an application adds millions of fact rows and thousands of new customers. Currently, a full process of the cube takes several hours. You need to ensure that queries return the most recent customer data with the minimum amount of latency. Which cube storage model should you use?