DRAG DROP
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.)
Answer: See the explanation.
Explanation:
Note:
* To create a new tabular model project from a PowerPivot for Excel file
1. In SQL Server Data Tools, on theFilemenu, clickNew, and then clickProject.
(box 2)
2. In theNew Projectdialog box, underInstalled Templates, clickBusiness Intelligence,
and then clickImport from PowerPivot.
(box 3)
3. InName, type a name for the project, then specify a location and solution name, and
then clickOK.4. In theOpendialog box, select the PowerPivot for Excel file that contains the model
metadata and data you want to import, and then clickOpen.
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
Reference: Import from PowerPivot (SSAS Tabular)
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00816.jpg a
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image01019.jpg a
1. We need native (not sharepoint) SSAS Tabular
2. In 2012 version we use Data Tools instead of BIDS
3. There is a wizard for PowerPivot import.