You have a server named Contoso with multiple databases. You have been tasked to write a PowerShell script to determine which databases on the server are larger than 100GB. You open PowerShell from SQL Server Management Studio. You create two variables as follows:

PS SQLSERVER:\SQL\Contoso> $MultipleOfGB = 1024 * 1024 PS SQLSERVER:\SQL\Contoso> $Server = Get-Item You need to determine which script will produce the desired list of databases. What script should you use?

Question

You have a server named Contoso with multiple databases. You have been tasked to write a PowerShell script to determine which databases on the server are larger than 100GB. You open PowerShell from SQL Server Management Studio. You create two variables as follows:

PS SQLSERVER:\SQL\Contoso> $MultipleOfGB = 1024 * 1024 PS SQLSERVER:\SQL\Contoso> $Server = Get-Item You need to determine which script will produce the desired list of databases. What script should you use?

Accepted Answer

A. $Server.Databases | Where-Object{($_.Size * $MultipleOfGB) -gt 100GB\}

Answer

B. $Server | Where-Object{($_.DatabaseSize * $MultipleOfGB) -match 100GB\}

Answer

C. $Server | Where-Object{($_.DatabaseSize * $MultipleOfGB) -gt 100GB\}

Answer

D. $Server.Databases | Where-Object{($_.Size * $MultipleOfGB) -match 100GB\}

You have a server named Contoso with multiple databases. You have been tasked to write a PowerShell script to determine which databases on the server are larger than 100GB. You open PowerShell from…

Question

Options

How the community answered

Community Discussion