70-466 · Question #86
You need to create the data source view for the StandardReports project. What should you do?
The correct answer is B. Create a data source, connect it to the data warehouse, and then use the Data Source View wizard.. This question tests the correct sequence for creating a Data Source View (DSV) in an SSAS project using SQL Server Data Tools.
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.
How the community answered
(40 responses)- A3% (1)
- B90% (36)
- C3% (1)
- D5% (2)
Why each option
This question tests the correct sequence for creating a Data Source View (DSV) in an SSAS project using SQL Server Data Tools.
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.
In SSAS, a Data Source View requires an underlying Data Source object that defines the connection string to the relational database. The correct workflow is to first create a Data Source pointing to the data warehouse, and then launch the Data Source View wizard, which uses that connection to allow selection of tables and views to include in the DSV. This two-step sequence is the standard SSAS project setup procedure.
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.
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
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/data-source-views-in-multidimensional-models
Topics
Community Discussion
No community discussion yet for this question.