Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Microsoft 70-452
Title
: PRO:MS SQL Server@ 2008,
Designing a Business
Intelligence
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. You design a Business Intelligence (BI) solution by using SQL Server 2008.
You create a SQL Server 2008 Analysis Services (SSAS) solution. The data source view of the solution is
as shown in the following exhibit. (Click the Exhibit button.)
You create the following components from the corresponding tables in the data source view:
·Two dimensions named DimCustomer and DimGeography
·A measure group named FactSales
You plan to analyze data in the FactSales measure group by geographic locations.
You need to implement the rollup measures in the FactSales measure group by using the DimGeography
dimension.
What should you do?
A. Create a regular relationship for the DimGeography dimension.
B. Create a referenced relationship for the DimGeography dimension.
C. Create a many-to-many relationship for the DimGeography dimension.
D. Create a role-playing dimension instance for the DimGeography dimension.
Answer: B
2. 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.
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
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?
A. Create a data source view named DsvContoso that is associated with the two data source