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.
Explanation:
Tip: “snowflake schema” = “Create a data source view … add the tables to the data source view”