nerdexam

70-158 · Question #5

70-158 Question #5: Real Exam Question with Answer & Explanation

The correct answer is D: Ensure that no stored procedure runs in FIM.. To continue the restore process after encountering an error stopping the SQL Server Agent service for a failed FIM Portal, you must ensure that no active database processes, such as running stored procedures, are preventing the agent from shutting down.

Submitted by marco_it· Mar 4, 2026Install and upgrade FIM

Question

You administer a Forefront Identity Management (FIM) 2010 server in your company network. The server that runs the FIM Portal fails. You begin the restore process. However, you receive an error when you stop the SQL Server Agent service. You need to be able to continue the restore process. What should you do?

Options

  • ARun iisreset.exe.
  • BClose the FIM Portal.
  • CStop the FIM Synchronization service.
  • DEnsure that no stored procedure runs in FIM.

Explanation

To continue the restore process after encountering an error stopping the SQL Server Agent service for a failed FIM Portal, you must ensure that no active database processes, such as running stored procedures, are preventing the agent from shutting down.

Common mistakes.

  • A. Running iisreset.exe restarts Internet Information Services (IIS), which hosts the FIM Portal, but it does not directly address an error preventing the SQL Server Agent service from stopping.
  • B. The FIM Portal server has already failed, so 'closing' the portal is either redundant or insufficient to resolve an issue with the SQL Server Agent service.
  • C. Stopping the FIM Synchronization service would halt synchronization activities, but it might not directly resolve an issue preventing the SQL Server Agent service from stopping, especially if the problem lies with the agent's own jobs or other active database processes.

Concept tested. SQL Server Agent service shutdown for database operations

Topics

#FIM Portal#Disaster Recovery#Database Restore#SQL Server Agent

Community Discussion

No community discussion yet for this question.

Full 70-158 PracticeBrowse All 70-158 Questions