nerdexam
Microsoft

70-466 · Question #138

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

The correct answer is B. PowerPivot Configuration Tool D. SharePoint Central Administration E. PowerShell. PowerPivot for SharePoint can be configured using the dedicated PowerPivot Configuration Tool, SharePoint Central Administration, or PowerShell cmdlets - all three are valid, complete configuration paths.

Configure and maintain an analysis services database

Question

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.)

Options

  • ASQL Server Configuration Manager
  • BPowerPivot Configuration Tool
  • CSharePoint Products Configuration Wizard
  • DSharePoint Central Administration
  • EPowerShell

How the community answered

(52 responses)
  • A
    2% (1)
  • B
    92% (48)
  • C
    6% (3)

Why each option

PowerPivot for SharePoint can be configured using the dedicated PowerPivot Configuration Tool, SharePoint Central Administration, or PowerShell cmdlets - all three are valid, complete configuration paths.

ASQL Server Configuration Manager

SQL Server Configuration Manager manages SQL Server service startup, protocols, and network configuration but has no functionality related to PowerPivot for SharePoint farm configuration.

BPowerPivot Configuration ToolCorrect

The PowerPivot Configuration Tool is a dedicated wizard-based utility provided with the SQL Server feature installation that automates the steps needed to configure PowerPivot for SharePoint, making it a complete standalone solution.

CSharePoint Products Configuration Wizard

The SharePoint Products Configuration Wizard configures SharePoint itself (farm join, database, service accounts) but does not include PowerPivot-specific configuration steps and is not a complete solution for PowerPivot setup.

DSharePoint Central AdministrationCorrect

SharePoint Central Administration provides a GUI to configure the PowerPivot Service Application settings, manage service accounts, and enable features, constituting a complete configuration path.

EPowerShellCorrect

PowerShell with the SharePoint and Analysis Services snap-ins exposes all configuration cmdlets needed to set up PowerPivot for SharePoint programmatically, providing a full scripted solution.

Concept tested: PowerPivot for SharePoint configuration tools and methods

Source: https://learn.microsoft.com/en-us/analysis-services/power-pivot-sharepoint/configure-or-repair-power-pivot-for-sharepoint-2013

Topics

#PowerPivot for SharePoint#configuration tools#SharePoint farm integration#SSAS setup

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice