Exam 98-364 topic 1 question 42 discussion

Actual exam question from Microsoft's 98-364

Question #: 42
Topic #: 1

[All 98-364 Questions]

You need to establish a set of permissions that you can routinely assign to new users.
What should you create?

A. Resource
B. Group
C. List
D. Role

Show Suggested Answer

Suggested Answer: D 🗳️

by jrn1992 at June 2, 2020, 9:43 p.m.

Comments

Submit Cancel

jrn1992

Highly Voted 5 years ago

SQL Role. CREATE ROLE creates a set of privileges which may be assigned to users of a database. Once a role is assigned to a user, (s)he gets all the Privileges of that role. By creating and granting roles, best means of database security can be practiced.

upvoted 9 times

syed5

4 years, 11 months ago

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-role-transact-sql?view=sql-server-ver15

upvoted 1 times

...

Pink_Dreams

4 years, 5 months ago

Well Done!

upvoted 2 times

...

dishijn2

Most Recent 3 years, 8 months ago

SQL roles are useful for administering privileges when a database has many users. Roles provide a more powerful way to grant privileges to users' sessions than to grant privileges to each user of the database, which easily becomes tedious and error-prone when many users are involved.

upvoted 1 times

...