You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a data source view. You add a table named Customer from the data source to the data source view. You alter the name of the table from Customer to DimCustomer in the data source. You need to ensure that the following requirements are met:

The data source view uses the altered table name as the source.

All existing relationships and table references are preserved.

What should you do?

Question

You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a data source view. You add a table named Customer from the data source to the data source view. You alter the name of the table from Customer to DimCustomer in the data source. You need to ensure that the following requirements are met:

The data source view uses the altered table name as the source.
All existing relationships and table references are preserved.

What should you do?

Accepted Answer

A. Refresh the data source view.

Answer

B. Replace the Customer table in the data source view with DimCustomer.

Answer

C. Remove the Customer table in the data source view.

Answer

D. Change the FriendlyName property of the Customer table to DimCustomer.

You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a data source view. You add a table named Customer from the data source to the data source view. You alter the name of the…

Question

Options

How the community answered

Community Discussion