Microsoft
70-458 · Question #111
You administer a Microsoft SQL Server 2012 database named Contoso that contains a single user-defined database role namedBillingUsers. All objects in Contoso are in the dbo schema. You need to grant…
The correct answer is D. Option D. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2012 database named Contoso that contains a single user-defined database role namedBillingUsers. All objects in Contoso are in the dbo schema. You need to grant EXECUTE permissions for all stored procedures in Contoso to BillingUsers. Which Transact-SQL statement should you use?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(38 responses)- A8% (3)
- B5% (2)
- C3% (1)
- D84% (32)
Community Discussion
No community discussion yet for this question.