Microsoft
70-466 · Question #19
You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade to the instance to SQL Server 2014. You need to import an existing PowerPivot workbook to create a t
The correct sequence of steps to migrate a PowerPivot workbook to a tabular project is: 1. Install SQL Server PowerPivot Add-in for SharePoint. 2. Open SQL Server Data Tools and create a new project. 3. Use the Import from Server (Tabular) template as the project type. 4. Install
Build a tabular data model
Question
You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade to the instance to SQL Server 2014. You need to import an existing PowerPivot workbook to create a tabular project. Which of the following actions should you perform in sequence?
Explanation
The correct sequence of steps to migrate a PowerPivot workbook to a tabular project is: 1. Install SQL Server PowerPivot Add-in for SharePoint. 2. Open SQL Server Data Tools and create a new project. 3. Use the Import from Server (Tabular) template as the project type. 4. Install an instance of SQL Server 2012 Analysis Services in Tabular mode.
Topics
#PowerPivot import#tabular project#SSDT upgrade#SSAS 2014 migration
Community Discussion
No community discussion yet for this question.