Question

Point out the correct statement.

(a) The permissions of a role may allow members to access and administer the database

(b) Server roles, roles defined by administrators to control access to objects and data for non-administrator user

(c) Database roles, roles defined by administrators to control access to objects and data for administrator user

(d) None of the mentioned

I got this question during an internship interview.

The origin of the question is Analysis Services topic in division Business Intelligence of SQL Server

Answer 1

The correct choice is (a) The permissions of a role may allow members to access and administer the database

Easiest explanation: Each permission has one or more access rights associated with it, which in turn gives the permission finer control over access to a particular object in the database.