You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to
upgrade the instance to SQL Server 2014.
You need to import an existing PowerPivot workbook to create a tabular project.
Which three actions should you perform in sequence? (To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:

Answer:

Explanation:
Note:
* To create a new tabular model project from a PowerPivot for Excel file
(box 2)
Box 1:
* When creating a new tabular model project by importing from a PowerPivot workbook, the
metadata that defines the structure of the workbook is used to create and define the structure of
the tabular model project in SQL Server Data Tools. Objects such as tables, columns, measures,
and relationships are retained and will appear in the tabular model project as they are in the
PowerPivot workbook.
* Analysis Services provides three different approaches for creating a business intelligence
semantic model: tabular, multidimensional, and PowerPivot. Tabular solutions use relational
modeling constructs such as tables and relationships for modeling data, and the xVelocity inmemory
analytics engine for storing and calculating data
Import from PowerPivot (SSAS Tabular)