Bulk user operations from CSV in PowerShell - Practice Problems & Coding Challenges

Challenge - 5 Problems

💻 Command Output

intermediate

What is the output of this PowerShell script reading a CSV?

Given a CSV file named users.csv with the following content:

Username,Email
alice,[e-mail]
bob,[e-mail]

What will this script output?

Import-Csv users.csv | ForEach-Object { "User: $($_.Username), Email: $($_.Email)" }

PowerShell

Import-Csv users.csv | ForEach-Object { "User: $($_.Username), Email: $($_.Email)" }

A

User: alice, Email: [e-mail]
User: bob, Email: [e-mail]

B

Username,Email
alice,[e-mail]
bob,[e-mail]

C

User: $_.Username, Email: $_.Email
User: $_.Username, Email: $_.Email

D Error: Cannot find path 'users.csv' because it does not exist.

💡 Hint

Think about how Import-Csv creates objects and how ForEach-Object accesses properties.

Import-Csv reads the CSV and creates objects with properties Username and Email. The script outputs formatted strings for each user.

📝 Syntax

intermediate

Which option correctly updates user emails from CSV in PowerShell?

You want to update user emails in Active Directory from a CSV file with columns Username and NewEmail. Which script snippet correctly updates the email attribute for each user?

A Import-Csv users.csv | ForEach-Object { Set-ADUser -Identity $_.Username -Email $_.NewEmail }

B Import-Csv users.csv | ForEach-Object { Set-ADUser -Identity $Username -EmailAddress $NewEmail }

C Import-Csv users.csv | ForEach-Object { Set-ADUser -Identity $_.Username -EmailAddress $_.NewEmail }

D Import-Csv users.csv | ForEach-Object { Set-ADUser -User $_.Username -EmailAddress $_.NewEmail }

💡 Hint

Check the parameter names for Set-ADUser and how to access CSV properties.

Set-ADUser uses -Identity for the user and -EmailAddress for the email attribute. $_.Username and $_.NewEmail correctly access CSV columns.

🔧 Debug

advanced

Why does this bulk user creation script fail?

This script is intended to create users from a CSV file with Username and Password columns:

Import-Csv users.csv | ForEach-Object {
  New-ADUser -Name $_.Username -AccountPassword (ConvertTo-SecureString $_.Password) -Enabled $true
}

What is the cause of the error?

PowerShell

Import-Csv users.csv | ForEach-Object {
  New-ADUser -Name $_.Username -AccountPassword (ConvertTo-SecureString $_.Password) -Enabled $true
}

A Import-Csv cannot read the CSV file without specifying the delimiter.

B New-ADUser does not accept -AccountPassword parameter.

C The script is missing a pipeline to export the created users.

D ConvertTo-SecureString requires the -AsPlainText and -Force flags to convert plain text passwords.

💡 Hint

Think about how ConvertTo-SecureString handles plain text input.

ConvertTo-SecureString needs -AsPlainText and -Force to convert plain text passwords; otherwise, it throws an error.

🚀 Application

advanced

How to safely disable multiple users from a CSV list?

You have a CSV file with a list of usernames to disable in Active Directory. Which script snippet safely disables these users and logs each action to a file named disable_log.txt?

A

Import-Csv users.csv | ForEach-Object {
  Disable-ADAccount -Identity $_.Username
  Add-Content -Path disable_log.txt -Value "Disabled user: $($_.Username)"
}

B

Import-Csv users.csv | ForEach-Object {
  Disable-ADAccount $_.Username
  Out-File disable_log.txt -InputObject "Disabled user: $_.Username"
}

C

Import-Csv users.csv | ForEach-Object {
  Disable-ADAccount -Identity $_.Username | Out-File disable_log.txt
}

D

Import-Csv users.csv | ForEach-Object {
  Disable-ADAccount -User $_.Username
  Add-Content disable_log.txt "Disabled user: $_.Username"
}

💡 Hint

Check the correct parameter names and how to append text to a file.

Disable-ADAccount uses -Identity parameter. Add-Content appends text to a file, preserving previous content.

🧠 Conceptual

expert

What is the main benefit of using Import-Csv with pipeline in bulk user operations?

Why is using Import-Csv piped into ForEach-Object a preferred method for bulk user operations in PowerShell?

A It runs all user operations in parallel to speed up execution.

B It allows processing each user record as an object, enabling property access and command chaining efficiently.

C It automatically validates user data and prevents errors during bulk operations.

D It converts CSV data into XML format for better compatibility with Active Directory.

💡 Hint

Think about how PowerShell treats CSV data and pipelines.

Import-Csv converts CSV rows into objects, which can be processed one by one in the pipeline, making scripting flexible and readable.