Home » Microsoft » 70-466 v.2 » Which tool should you use?
You maintain SQL Server Analysis Services (SSAS) instances.
You need to configure an installation of PowerPivot for Microsoft SharePoint in a SharePoint farm.
Which tool should you use? (Each correct answer presents a complete solution. Choose all that apply.)
A. SQL Server Configuration Manager
B. PowerPivot Configuration Tool
C. SharePoint Products Configuration Wizard
D. SharePoint Central Administration
E. PowerShell
Correct Answer: BDE
Explanation/Reference:
Explanation:
Power Pivot for SharePoint must be configured before it can be used. After you install Power Pivot for SharePoint using SQL Server Setup, you can configure it using any of the following approaches:
Power Pivot Configuration Tool or Power Pivot for SharePoint 2013 Configuration tool SharePoint Central Administration
PowerShell cmdlets
References: https://docs.microsoft.com/en-us/sql/analysis-services/power-pivot-sharepoint/power-pivot-server-administration-and-configuration-incentraladministration