nerdexam
Microsoft

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.

Build an analysis services database

Question

You need to create the data source view for the StandardReports project. What should you do?

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)
  • A
    3% (1)
  • B
    90% (36)
  • C
    3% (1)
  • D
    5% (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.

AGenerate a relational schema from the dimensions and cubes by using the Schema Generation wizard.

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.

BCreate a data source, connect it to the data warehouse, and then use the Data Source View wizard.Correct

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.

CExecute the Import from Table wizard and then use the Data Source View wizard.

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.

DCreate a new data source view and then use the Import from Table wizard.

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

#data source view#DSV wizard#data source#data warehouse

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice