Microsoft Certified: Azure Administrator AssociateManage Azure identities and governanceMedium

A large enterprise uses Azure Active Directory (Azure AD) to manage thousands of user accounts. Due to a recent internal reorganization, many users have had their department and cost center information changed. An administrator needs to efficiently update these attributes for a large number of users in Azure AD. Which method is the most efficient for performing this bulk update?

  1. ACreate a custom application using Microsoft Graph API to modify user attributes.
  2. BManually update each user's profile in the Azure portal.
  3. CUse PowerShell with the Azure AD module to import a CSV file.
  4. DUse Azure AD Connect to synchronize changes from an on-premises Active Directory.
Show answer & explanation

Correct answer: C. Use PowerShell with the Azure AD module to import a CSV file.

Using PowerShell with the Azure AD module to import a CSV file is the most efficient and practical method for bulk updating user attributes directly in Azure AD. It allows for scripting and automation of changes for many users simultaneously.

Why the other options are wrong

  • A. While possible, creating a custom application is overkill and less efficient than a simple PowerShell script for a one-time or infrequent bulk update.
  • B. Manually updating each user is time-consuming and inefficient for a large number of users.
  • D. This assumes the changes originate from on-premises, but the scenario implies a direct update needed in Azure AD, or if on-prem, a more direct bulk method is still needed on-prem.

Azure AD Bulk User Attribute Update

Bulk updating user attributes in Azure AD for many users simultaneously is most efficiently done using scripting tools like PowerShell with CSV input, or through Azure AD Connect if changes originate on-premises.

  • PowerShell with CSV is common for direct Azure AD bulk updates.
  • Azure AD Connect handles bulk updates from on-premises AD.
  • Azure portal is for individual user management.

Memory trick: Many users, many changes? PowerShell saves the day!

More Manage Azure identities and governance questions