nerdexam
Microsoft

70-467 · Question #89

You need to ensure that you can monitor the usage data. What should you do?

The correct answer is A. In SharePoint Central Administration, enable usage data collection.. PowerPivot for SharePoint usage data collection is controlled through SharePoint Central Administration, not through the PowerPivot Configuration Tool or Reporting Services.

Plan business intelligence (BI) infrastructure

Question

You need to ensure that you can monitor the usage data. What should you do?

Options

  • AIn SharePoint Central Administration, enable usage data collection.
  • BIn the PowerPivot Configuration Tool, repair PowerPivot for SharePoint.
  • CIn the PowerPivot Configuration Tool, upgrade PowerPivot for SharePoint.
  • DIn Reporting Services Configuration Manager, enable report execution logging.

How the community answered

(49 responses)
  • A
    94% (46)
  • B
    2% (1)
  • C
    4% (2)

Why each option

PowerPivot for SharePoint usage data collection is controlled through SharePoint Central Administration, not through the PowerPivot Configuration Tool or Reporting Services.

AIn SharePoint Central Administration, enable usage data collection.Correct

SharePoint Central Administration contains the Usage and Health Data Collection settings where administrators enable the collection of SharePoint usage events, including PowerPivot query activity, server health metrics, and data refresh history. Enabling this service is a prerequisite for the PowerPivot Management Dashboard to display usage statistics. Without this setting enabled, no usage telemetry is written to the logging database.

BIn the PowerPivot Configuration Tool, repair PowerPivot for SharePoint.

Repairing PowerPivot for SharePoint in the Configuration Tool re-runs installation steps to fix broken components; it does not enable or configure usage data collection.

CIn the PowerPivot Configuration Tool, upgrade PowerPivot for SharePoint.

Upgrading PowerPivot for SharePoint applies a newer version of the solution packages; it does not activate usage monitoring functionality.

DIn Reporting Services Configuration Manager, enable report execution logging.

Reporting Services report execution logging tracks SSRS report runs in the ReportServer database and is unrelated to PowerPivot for SharePoint usage data.

Concept tested: Enabling PowerPivot for SharePoint usage data collection

Source: https://learn.microsoft.com/en-us/analysis-services/power-pivot-sharepoint/configure-usage-data-collection-for-power-pivot-for-sharepoint

Topics

#usage data collection#SharePoint Central Administration#PowerPivot monitoring#BI infrastructure

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-467 Practice