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

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. Twenty users edit the content of the reports. The users belong to an Active Directory group named Developers. At times, the reports are published with incomplete information. You need to design an approval process. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a dimensional modeling strategy for a new data warehouse. The data warehouse has a dimension table named Employees. The Employees dimension table contains information about the employees and their departments. Employees are moved to different departments frequently. You need to preserve the historical information of the Employees table. Which dimensional model should you use?

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. There's a data warehouse named ClientA, it contains a Fact table named FactClient which has two columns named ClientMain and ClientSell. You use SQL Server 2008 Analysis Services (SSAS) to create a data mining model named ClientModel. You also use SQL Server 2008 Reporting Services (SSRS) to create a report, it is used to list the top 30 clients according to the sales amount. You add a column named Wellsale to the report which takes data from a SQL Server relational database. Now you must make sure that the Wellsale column displays the probability values of the expensive products that customers are intend to buy. So what Data Mining Extensions (DMX) query should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. A data warehouse named CustomerDW contains a Fact table named FactCustomer. The FactCustomer table contains two columns named CustomerKey and CustomerSales. You create a data mining model named CustomerModel by using SQL Server 2008 Analysis Services (SSAS). A report that is developed by using SQL Server 2008 Reporting Services (SSRS) lists the top 50 customers based on the sales amount. The report extracts data from a SQL Server relational database. You add a column named UpSell to the report. You need to ensure that the UpSell column displays the probability values of the expensive products that customers are likely to purchase. Which Data Mining Extensions (DMX) query should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) report. The report contains summary information in two sections named Agencies and States. The Agency summary section contains two matrices and the State summary section contains a table. The information about each section is grouped together. You need to design the report to meet the following requirements: -When the report is exported to a Microsoft Excel spreadsheet, each summary section is rendered to a separate tab. -The structure in each section is retained. What should you do?

You design a SQL Server 2008 Analysis Services (SSAS) solution that contains a cube. The cube uses an English (EN-US) locale. The cube has calculated members that use the members named Day of Week and Month Name of a dimension named Date to perform date-related operations. You implement translation in Spanish for the cube. You discover that the calculated members are not working correctly only when the cube is browsed in Spanish. You need to ensure that the calculated members work correctly when the cube is browsed in Spanish. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. Internet Information Services 7.0 (IIS 7.0) is installed on the system that hosts the SQL Server 2008 Reporting Services (SSRS) instance. You plan to design the security configuration for the SSRS instance. You need to ensure that customers can connect to the SSRS instance by using the Secure Sockets Layer (SSL) to render reports. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Analysis Services (SSAS) solution that has a dimension table named DimCustomer. The DimCustomer table has the following attributes: -Gender -Address -Marital Status -Phone Number You discover that DimCustomer takes a long time to process. You need to reduce the processing time of DimCustomer. You also need to reduce the disk space required for the DimCustomer dimension table. What should you do?

You design a SQL Server 2008 Analysis Services (SSAS) solution. The solution has dimensions named Account and Scenario. The Scenario dimension has the keys numbered 1 and 2 for the members named Actual and Budget, respectively. The Account dimension has the key numbered 40 for the member named Income. You create a key performance indicator (KPI) named Net Income that has the following parameters: KPI Value: ( [Account].[Accounts].&[40], [Scenario].[Scenario].&[1], [Measures].[Amount] ) KPI Goal: ( [Account].[Accounts].&[40], [Scenario].[Scenario].&[2], [Measures].[Amount] ) If the net income is less than 70 percent of the budgeted value, the performance is considered as bad. If the net income is greater than or equal to 90 percent of the budgeted value, the performance is considered as good. You need to calculate the performance at a specific point in time. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a data warehouse that has an online transaction processing (OLTP) database as the data source. The tables in the OLTP database do not include date or time information. On each execution, the SQL Server 2008 Integration Services (SSIS) package that copies the data must reload and process the entire dataset. You plan to improve the process of loading the data warehouse. You need to ensure that the following requirements are met: -Only new and modified data is processed. -All modifications of the rows caused due to insert, update, and delete activities are processed. -The impact of the loading process on the source system is minimal. Which action should you perform on the tables that are involved in the load process?