Microsoft Exam Questions

Which option should you use?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.

Your data source contains the following tables:

Products table with a column named ProductCategories_ID ProductCategories table with a column named ID The ProductCategories_ID column is used to link to the ID column. You create a data source view with the RetrieveRelationships property set to false.

You need to set the NameMatchingCriteria property of the data source view to an option to create a relationship between the two tables.

Which option should you use?

A.
(none)

B.
Same name as primary key

C.
Same name as destination table name

D.
Same name as destination table name + primary key name