nerdexam

70-158 · Question #26

You use Forefront Identity Manager (FIM) 2010 in your company network. You integrate a new Microsoft SQL Server database with FIM. You create a Management Agent (MA) and configure run profiles. You…

The correct answer is B. Refresh the SQL MA schema. E. Configure the schema in Management Agent Designer. When a SQL database schema changes (e.g., an attribute is deleted), the FIM Management Agent must be updated to reflect the new schema to avoid connection/import failures.

Submitted by valeria.br· Mar 4, 2026Configure the Synchronization Service

Question

You use Forefront Identity Manager (FIM) 2010 in your company network. You integrate a new Microsoft SQL Server database with FIM. You create a Management Agent (MA) and configure run profiles. You delete an attribute in the SQL database. You execute a Full Import run profile on the SQL MA and it fails. You review the Connection Log and discover a failed-connection error. You need to ensure that the new SQL database can synchronize with FIM. What should you do? (Choose all that apply.)

Options

  • ARun iisreset.exe.
  • BRefresh the SQL MA schema.
  • CConfigure a connector filter in the SQL MA.
  • DAdd a new step to the Full Import run profile.
  • EConfigure the schema in Management Agent Designer.

How the community answered

(66 responses)
  • A
    12% (8)
  • B
    61% (40)
  • C
    6% (4)
  • D
    21% (14)

Why each option

When a SQL database schema changes (e.g., an attribute is deleted), the FIM Management Agent must be updated to reflect the new schema to avoid connection/import failures.

ARun iisreset.exe.

Running iisreset.exe restarts IIS web services and has no effect on the FIM Synchronization Service or the SQL MA schema mismatch causing the import failure.

BRefresh the SQL MA schema.Correct

Refreshing the SQL MA schema forces FIM to re-read the current structure of the SQL database, removing the deleted attribute from the MA's awareness and resolving the schema mismatch that caused the failed-connection error.

CConfigure a connector filter in the SQL MA.

A connector filter controls which objects are included or excluded from synchronization based on attribute values, but does not resolve a schema mismatch caused by a deleted attribute.

DAdd a new step to the Full Import run profile.

Adding a new step to the Full Import run profile only changes how the import is executed (e.g., adding a delta step), but does not address the underlying schema discrepancy between the SQL database and the MA configuration.

EConfigure the schema in Management Agent Designer.Correct

After refreshing the schema, the Management Agent Designer must be updated to reconfigure attribute mappings and flows that referenced the deleted attribute, ensuring the MA's configuration aligns with the refreshed schema before synchronization can succeed.

Concept tested: FIM Management Agent schema refresh after database change

Source: https://learn.microsoft.com/en-us/microsoft-identity-manager/reference/microsoft-identity-manager-2016-ma-ws

Topics

#Management Agent#Schema Refresh#SQL MA#Run Profiles

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-158 Practice