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
Is B C E
Why is E: https://technet.microsoft.com/en-us/library/ee210697%28v=sql.105%29.aspx
B, D, E: https://technet.microsoft.com/en-us/library/ee210609(v=sql.110).aspx
It is not necessary to use power shell for power pivot configuration,
if you doing everything in correct order.
B and D in my mind.
B,D,E is correct.
B,D,E is correct.
B,D,E – Correct final answer
“B” – Configure, repair, or remove a SQL Server 2012 and SQL Server 2012 SP1 PowerPivot for SharePoint with the PowerPivot Configuration Tools.
https://msdn.microsoft.com/pl-pl/library/hh213173(v=sql.110).aspx
“D” – During instalation also SharePoint Central Administration is used- here description how:
https://technet.microsoft.com/en-us/library/dn456880.aspx
“E” – Configuration can be done also using PowerShell:
https://msdn.microsoft.com/pl-pl/library/hh230903(v=sql.110).aspx