nerdexam
Microsoft

70-467 · Question #47

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

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.

Plan business intelligence (BI) infrastructure

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

How the community answered

(52 responses)
  • A
    8% (4)
  • B
    87% (45)
  • D
    6% (3)

Why each option

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

AUse the PowerPivot Configuration Tool and select the Upgrade Features, Services,

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.

BUse the PowerPivot Configuration Tool and select the Configure or Repair PowerPivot forCorrect

Selecting 'Configure or Repair PowerPivot for SharePoint' instructs the PowerPivot Configuration Tool to diagnose and automatically fix misconfigured components - such as service accounts, timer jobs, and service application settings - that are required for data refresh to function. This is the minimum-effort approach because the tool applies all necessary corrections in a single guided operation without requiring manual navigation through multiple SharePoint Central Administration pages.

DIn SharePoint Central Administration, create a target application and configure the

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

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

Topics

#PowerPivot#data refresh#PowerPivot Configuration Tool#SharePoint

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice