Microsoft
70-332 · Question #23
70-332 Question #23: Real Exam Question with Answer & Explanation
Sign in or unlock 70-332 to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
Configure and manage service applications
Question
You are a SharePoint administrator at Litware, Inc. Excel Services is not currently able to load workbooks on the SharePoint site. The Unified Logging Service (ULS) log contains the following error message:
System.Data.SqlClient.SqlException: Cannot open database "WSS_Content_Portal_Content_Database" requested by the login. The login failed. Login failed for user 'LITWARE\svcExcelService'.
You need to grant only the minimum necessary permissions to the Excel Services account to ensure that users can open Excel workbooks from within a browser window. Which Windows PowerShell cmdlet or cmdlets should you run?
Options
- A$ssa = Get-SPServiceApplication | where {$_.TypeName -eq "Excel Services Application Web Service Application"} and $ssa.GrantContentDatabasePermissions($WSS_Content_Portal_Content_Database")
- BAdd-SPShellAdmin -Username LITWARE\svcExcelService
- CAdd-SPShellAdmin -Username LITWARE\svcExcelService -Database WSS_Content_Portal_Content_Database
- D$wa = Get-SPWebApplication https://portal.litware.com and $wa.GrantToProcessIdentity("LITWARE \svcExcelService")
Unlock 70-332 to see the answer
You've previewed enough free 70-332 questions. Unlock 70-332 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.
Topics
#Excel Services#GrantToProcessIdentity#service account permissions#ULS logs