70-467 Question #47: Real Exam Question with Answer & Explanation

The correct answer is B: Use the PowerPivot Configuration Tool and select the Configure or Repair PowerPivot for. The PowerPivot Configuration Tool's 'Configure or Repair' option automatically detects and corrects data refresh misconfiguration with the least administrative effort.

Question

You need to fix the PowerPivot data refresh problem by using the least amount of administrative effort. What should you do?

Options

AUse the PowerPivot Configuration Tool and select the Upgrade Features, Services,
BUse the PowerPivot Configuration Tool and select the Configure or Repair PowerPivot for
DIn SharePoint Central Administration, create a target application and configure the

Explanation

The PowerPivot Configuration Tool's 'Configure or Repair' option automatically detects and corrects data refresh misconfiguration with the least administrative effort.

Common mistakes.

A. The 'Upgrade Features, Services' option in the PowerPivot Configuration Tool is intended for post-upgrade scenarios to update farm-level features, not to repair existing data refresh configuration problems.
D. Manually creating a target application in SharePoint Central Administration involves multiple configuration steps and addresses only the Secure Store credential aspect, not all potential causes of PowerPivot data refresh failures, requiring more administrative effort.

Concept tested. PowerPivot Configuration Tool repair for data refresh

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

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice