Online Access Free 070-452 Exam Questions

You design a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a cube. The structure
of the cube is as shown in the exhibit. (Click the Exhibit button.)
Each branch does transactions by using the local currency of the country in which it is located. Daily
exchange rates for all local currencies are recorded against the U.S. dollar in the FactCurrencyRate
measure group.
All transactions must be reported in U.S. dollars.
You need to prepare the cube to define currency conversion.
What should you do?
Exhibit:

• A.Create a reference relationship between FactCurrencyRate and Branch.
• B.Create a many-to-many relationship between FactCurrencyRate and Branch.
• C.Create a many-to-many relationship between FactSales and Currency.
• D.Create a reference relationship between FactSales and Currency.

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?

• A.drilldown
• B.filter
• C.a document map
• D.drillthrough

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 cube. Add 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 role. Grant access only to DimGeography, DimProduct, and TotalSales.
• D.You should create a new perspective for the current cube. Select DimGeography, DimProduct, and TotalSales.

You are the administrator of your company network. You use Server 2008 to develop a Business Intelligence (BI) solution. You work out a SQL Server 2008 Analysis Services (SSAS) solution. Customer data is stored in the tables named CustomerContact and CustomerDetails. The solution utilizes the following two data sources from two different servers: ContosoCRM that accesses the CustomerContact table Contoso that accesses the CustomerDetails tableYou intend to create a dimension named DimCustomer that analyzes customer data. You have to make sure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. So what should you do to ensure this?

• A.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and
• B.You should create a data source view named DsvCustomer which is associated with the
  Contoso data source and create a named query in the data source view to
• C.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to
• D.You should create a data source view named DsvContoso which is associated with the two data sources and create a named query in the data source view to
• E.You should create a data source view named DsvCustomer which is associated with the Contoso data source and add the CustomerDetails table to the data
• F.You should create a data source view named DsvContoso which is associated with the two data sources and add the tables to the data source view.

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?

• A.Set the Change Type option to Changing Attribute for the VoucherNumber column.
• B.Set the Change Type option to Fixed Attribute for the CustomerFullName column.
• C.Enable the support for inferred members.
• D.Set the Change Type option to Historical Attribute for the VoucherNumber column.