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 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?
A. Create a data source view named DsvContoso that is associated with the two data sources and add the
tables to the data source view.
B. Create a data source view named DsvContoso that is associated with the two data sources and create a
named query in the data source view to merge the tables.
C. Create a data source view named DsvCustomer that is associated with the Contoso data source and
add the CustomerDetails table to the data source view.
Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data
source and add the CustomerContact table to the data source view.
D. Create a data source view named DsvCustomer that is associated with the Contoso data source and
create a named query in the data source view to select data from the CustomerDetails table.
Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data
source and create a named query in the data source view to select data from the CustomerContact table.
Answer: A
2. You design a Business Intelligence (BI) solution by using SQL Server 2008.
You create a SQL Serv