Free Microsoft 070-452 Exam Dumps Questions & Answers

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?

• A.Set the ProcessingGroup property of DimCustomer to ByAttribute.
• B.Set the ProcessingGroup property of DimCustomer to ByTable.
• C.Set the AttributeHierarchyEnabled property of the Phone Number and Address attributes to false.
• D.Set the AttributeHierarchyEnabled property of the Gender and Marital Status attributes to false.

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes reports
hosted on a single SQL Server 2008 Reporting Services (SSRS) server. You plan to modify the report
server infrastructure to support a scale-out deployment. You need to ensure that the scale-out deployment
meets the following requirements:
-Allows users to access any of the Report Server servers by using the original Report Manager URL.
-Minimizes network traffic.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

• A.Modify the <ReportServerUrl> element in the <UI> section of each RsReportServer.config file.
• B.Modify the <UrlRoot> element in the <Service> section of each RsReportServer.config file.
• C.Modify the <sessionState> element in the <system.web> section of the web.config file in each ReportManager folder.
• D.Add the same <machineKey> element in the <system.web> section of all web.config files for each Report Server server.
• E.Add a different <machineKey> element in the <system.web> section of all web.config files for each Report Server server.
• F.Add a <HostName> element in the <Service> section of each RsReportServer.config file.

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. You use SQL sever 2008 to work out a SQLServer 2008 Analysis Services (SSAS) solution. There??s a dimension named DimCustomer that represents customers in the solution. The solution provides a list of top 8 customers in terms of the sales amount. End users of the solution use filters in Microsoft Excel worksheet to analyze data. You have to make sure that when the filters are applied, the list is updated. So which named set expression should you use?

• A.CREATE SESSION SET CURRENTCUBE.[Top 10 Customer] AS TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])
• B.CREATE HIDDEN SET CURRENTCUBE.[Top 10 Customer] AS TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])
• C.CREATE SET CURRENTCUBE.[Top 10 Customer] ASTOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])
• D.CREATE DYNAMIC SET CURRENTCUBE.[Top 10 Customer] AS TOPCOUNT([DimCustomer].[Customer].MEMBERS,10,[Measures].[SalesAmount])

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?

• A.Set the case sensitive value to true for the collation property of the Date dimension.
• B.Change the calculated members to use the numeric values of the Day of Week and Month Name members.
• C.Set the language property of the Date dimension to Spanish.
• D.Ensure that the Day of Week and Month Name members have translations defined in the Date dimension.

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?

• A.You should create a new role. Grant access only to DimGeography, DimProduct, and TotalSales.
• B.You should create a new data source view. Add the tables used for DimGeography, DimProduct, and TotalSales.
• C.You should create a new cube. Add DimGeography, DimProduct, and TotalSales.
• D.You should create a new perspective for the current cube. Select DimGeography, DimProduct, and TotalSales.