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 SQL Server 2008 Analysis Services (SSAS) solution that contains a cube. The solution has a measure group that contains different measures aggregated by different dimensions. Users often browse the cube by using Microsoft Excel. You need to enable users to view additional row-level information of the aggregated measures from Excel by using the minimum amount of development effort.
Which Action should you create?

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. You plan to design a logging strategy for a SQL Server 2008 Integration Services (SSIS) solution. The SSIS solution contains 15 packages. You want to log detailed information about each package. You need to ensure that custom events specific to each control flow task in each package are logged.
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 design a Business Intelligence (BI) solution by using SQL Server 2008. You develop 10 SQL Server 2008 Integration Services (SSIS) packages. You plan to include package configuration for all the packages.
The package configuration has the following requirements:
-All configurations are stored in a single location.
-Configuration variables are easily backed up and restored.
-Indirect configuration is used.
-The database administrators will use SQL Server client tools to change the configuration values.

You need to create package configurations for the packages to meet the configuration requirements.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have created an extract, transform, and load (ETL) solution by using SQL Server 2008 Integration Services (SSIS). The solution contains 10 child packages and a parent package that executes the child packages in sequence.
You plan to deploy the solution to 20 locations that are not connected to each other. You need to deploy the solution by configuring the connection managers of all packages with the appropriate settings. You need to achieve this goal by using the minimum amount of administrative effort.
What should you do?

You are managing a Business Intelligence (BI) infrastructure that uses SQL Server 2008 Integration Services (SSIS). Your infrastructure has many SSIS solutions that contain several packages. The current backup strategy includes nightly backups of all databases on the server. You need to develop a deployment strategy that meets the following requirements:
-Deploys only the packages that have been modified.
-Includes all packages in the current backup strategy.

What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop a SQL Server 2008 Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process from a Microsoft Access database to a SQL Server 2008 data warehouse. The package is developed on a computer that runs a 32-bit operating system. You deploy the package to a server that runs a 64-bit operating system. You create a SQL Server Agent job to run the package. The package fails to run when the job starts. You need to ensure that the package runs successfully.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to transform vehicle survey data from a flat file to a data warehouse. You need to design a solution that performs the following tasks:
-Redirect data of vehicle owners to a table named DimOwner.
-Redirect data of vehicle enthusiasts to a table named DimEnthusiast.
-Log each record’s key along with the data transfer date to an audit table.

What should you do?