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 Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution contains a cube that has a measure named SalesAmount. The measure contains customer sales data for the last six months. The cube has a single partition that has the storage property set to real-time hybrid online analytical processing (HOLAP).
Queries against the cube must return current sales data that is entered one hour before cube processing. The partition takes two hours to process and the response time for the queries is slow. You need to improve the cube processing and query response time.
What should you do?

You design a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a measure named Sales Amount and a dimension named Date. The Date dimension has a hierarchy named Fiscal that has levels named Fiscal Year, Fiscal Quarter, and Fiscal Month.
You need to create a calculated member to analyze the Sales Amount share percentage at different levels compared to the total sales for a given Fiscal Year.
Which code segment should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server 2008. The solution contains a dimension named DimCustomer that represents customers. The solution provides a list of top 10 customers based on the sales amount. End users of the solution analyze data by using filters in Microsoft Excel worksheet. You need to ensure that the list is updated when the filters are applied.
Which named set expression should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Analysis Services (SSAS) solution contains a cube that has the following objects:
Dimensions named DimCustomer, DimProduct, and DimGeography Measures named InternetSales and TotalSales

Users run reports against all dimensions and measures by authenticating with their Windows accounts.
You need to provide a basic view of data to the users to display only DimGeography, DimProduct, and TotalSales by using the least amount of storage space.
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. Your database has a table named DimCustomer that contains columns named FirstName and LastName. You belong only to the db_datareader role in the database. You have added DimCustomer to a data source view. You need to design a solution that includes the following requirements:
-A column named FullName in DimCustomer by using the values from FirstName and Lastname
-The data source view allows you to delete columns from DimCustomer

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 by using SQL Server 2008. The solution uses a source database that contains a table named Customer. The Customer table has multiple columns.
You have read-only access to the database.
You plan to reduce the number of columns in the Customer table. You need to split the Customer table to be distributed across multiple table definitions.
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. Customer data is stored in the tables named CustomerDetails and CustomerContact.
The solution uses the following two data sources from two different servers:
-Contoso that accesses the CustomerDetails table
-ContosoCRM that accesses the CustomerContact table

You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables.
What should you do?