Which two SQL Server components should you install on SPS1?

You have a server named SPS1 that has Microsoft SharePoint Server 2013 installed.

You have several Power View reports that are created in Microsoft Excel 2016.

You need to configure SPS1 to display the Power View reports.

Which two SQL Server components should you install on SPS1? Each correct answer presents part of the solution.
A . SQL Server Analysis Services (SSAS) in Multidimensional and Data Mining Mode
B . SQL Server Reporting Services (SSRS) in SharePoint mode
C . the PowerPivot for SharePoint 2013 add-in
D . SQL Server Analysis Services (SSAS) in SharePoint mode
E . SQL Server Analysis Services (SSAS) in Tabular Mode

View Answer

Answer: B,C

Explanation:

Power Pivot for SharePoint is a middle-tier data engine that loads, queries, and refreshes data models hosted in SharePoint. It is used to implement Power Pivot and Excel data models in SharePoint.

Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting. Power View is a feature of Microsoft Excel 2013, and of Microsoft SharePoint Server 2010 and 2013 as part of the SQL Server 2012 Service Pack 1 Reporting Services Add-in for Microsoft SharePoint Server Enterprise Edition.

References: https://support.office.com/en-us/article/Power-View-Explore-visualize-and-present­your-data-98268d31-97e2-42aa-a52b-a68cf460472e