nerdexam
Microsoft

70-467 · Question #58

You need to configure data refresh for the Manufacturing Performance PowerPivot workbook. What should you do? (Each Answer presents part of the solution. Choose ail that apply.)

The correct answer is A. Configure the PowerPivot Data Refresh Timer Job to run every 60 minutes. PowerPivot data refresh in a SharePoint-integrated deployment is managed by the PowerPivot Data Refresh Timer Job, not by SQL Server Agent or direct SSAS restore operations.

Plan business intelligence (BI) infrastructure

Question

You need to configure data refresh for the Manufacturing Performance PowerPivot workbook. What should you do? (Each Answer presents part of the solution. Choose ail that apply.)

Exhibit

70-467 question #58 exhibit

Options

  • AConfigure the PowerPivot Data Refresh Timer Job to run every 60 minutes.
  • BRestore the PowerPivot workbook to an SSAS instance in tabular mode.
  • CScript a process command and configure a SQL Server Agent job to execute the command
  • DRestore the PowerPivot workbook to an SSAS instance in PowerPivot for SharePoint mode.

How the community answered

(41 responses)
  • A
    78% (32)
  • B
    2% (1)
  • C
    12% (5)
  • D
    7% (3)

Why each option

PowerPivot data refresh in a SharePoint-integrated deployment is managed by the PowerPivot Data Refresh Timer Job, not by SQL Server Agent or direct SSAS restore operations.

AConfigure the PowerPivot Data Refresh Timer Job to run every 60 minutes.Correct

The PowerPivot Data Refresh Timer Job is the built-in SharePoint timer job that polls for scheduled refresh requests on PowerPivot workbooks published to a SharePoint library; setting its interval to 60 minutes ensures the workbook data is refreshed at the required frequency within the SharePoint service infrastructure.

BRestore the PowerPivot workbook to an SSAS instance in tabular mode.

Restoring the workbook to a generic SSAS tabular-mode instance removes it from the SharePoint-integrated PowerPivot environment entirely, breaking the SharePoint-based scheduling and refresh mechanism.

CScript a process command and configure a SQL Server Agent job to execute the command

SQL Server Agent jobs are used to process SSAS databases in standalone deployments; PowerPivot workbooks hosted in SharePoint use the SharePoint timer job framework for refresh orchestration, not SQL Server Agent.

DRestore the PowerPivot workbook to an SSAS instance in PowerPivot for SharePoint mode.

PowerPivot workbooks are published to a SharePoint document library, not restored to an SSAS instance; the data refresh lifecycle is managed through SharePoint timer jobs and the PowerPivot service application, making an SSAS restore the wrong operation.

Concept tested: PowerPivot SharePoint data refresh timer job configuration

Source: https://learn.microsoft.com/en-us/analysis-services/power-pivot-sharepoint/power-pivot-data-refresh-with-sharepoint-2013

Topics

#PowerPivot data refresh#SSAS tabular mode#SharePoint#Timer Job

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice