Microsoft
70-433 · Question #139
70-433 Question #139: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #139. The question stem and answer options stay visible for context.
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?
Options
- A$Server.Databases | Where-Object{($_.Size * $MultipleOfGB) -gt 100GB}
- B$Server | Where-Object{($_.DatabaseSize * $MultipleOfGB) -match 100GB}
- C$Server | Where-Object{($_.DatabaseSize * $MultipleOfGB) -gt 100GB}
- D$Server.Databases | Where-Object{($_.Size * $MultipleOfGB) -match 100GB}
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.