70-466 Question #86: Real Exam Question with Answer & Explanation

Question

Options

• AGenerate a relational schema from the dimensions and cubes by using the Schema Generation wizard.
• BCreate a data source, connect it to the data warehouse, and then use the Data Source View wizard.
• CExecute the Import from Table wizard and then use the Data Source View wizard.
• DCreate a new data source view and then use the Import from Table wizard.

Explanation

This question tests the correct sequence for creating a Data Source View (DSV) in an SSAS project using SQL Server Data Tools.

Common mistakes.

• A. The Schema Generation wizard generates a relational schema from an existing SSAS model's dimensions and cubes - it is used after the model is built, not to create an initial DSV from a source database.
• C. The Import from Table wizard is used in SSAS Tabular models to import data, not to create a Data Source View in a Multidimensional project; this sequence conflates two different workflows.
• D. A DSV cannot be created before a Data Source exists because it needs an active connection to enumerate available tables; the Import from Table wizard also does not apply to creating DSVs in Multidimensional projects.

Concept tested. Creating a Data Source View in an SSAS Multidimensional project

Reference. https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/data-source-views-in-multidimensional-models

No community discussion yet for this question.