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.
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
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)- A78% (32)
- B2% (1)
- C12% (5)
- D7% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.
