exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam

Exam 98-364 topic 1 question 68 discussion

Actual exam question from Microsoft's 98-364
Question #: 68
Topic #: 1
[All 98-364 Questions]

You assign User1 a set of permissions that include the WITH GRANT OPTION.
The WITH GRANT OPTION enables User1 to:

  • A. request a log of permission use.
  • B. delegate permissions to other users.
  • C. create new database users.
  • D. view other users' permissions.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
cdc
Highly Voted 5 years, 6 months ago
Answer C is incorrect. A GRANT issued to User1 WITH GRANT OPTION allows User1 to the grant access to other users
upvoted 16 times
...
tk09
Highly Voted 4 years, 10 months ago
Correct Answer: B
upvoted 10 times
...
stanlay
Most Recent 1 year, 8 months ago
I think the Correct Answer is B
upvoted 1 times
...
mikebui
2 years, 6 months ago
Answer is B. The optional WITH clause is used to enable a user to grant privileges to other users. The WITH GRANT OPTION clause gives the user the ability to give to other users any privileges the user has at the specified privilege level.
upvoted 1 times
...
dzoni68
2 years, 6 months ago
Answer is B. The WITH GRANT OPTION keywords convey the privilege or role to a user with the right to grant the same privileges or role to other users.
upvoted 1 times
...
omarjkf
2 years, 8 months ago
Selected Answer: B
Answer C is incorrect. A GRANT issued to User1 WITH GRANT OPTION allows User1 to the grant access to other users
upvoted 1 times
...
Yerke
2 years, 8 months ago
Selected Answer: B
is correct answer is B
upvoted 1 times
...
Yerke
2 years, 8 months ago
B is correct
upvoted 1 times
...
Jonny98101
2 years, 9 months ago
Selected Answer: B
https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-transact-sql?view=sql-server-ver15
upvoted 1 times
...
Morgane
3 years, 2 months ago
I'd lean on the side of B too. WITH GRANT OPTION indicates that the grantee will also be given the ability to grant the specified permission to other principals. "Delegate" might not be the best term, nevertheless B makes better sense.
upvoted 2 times
...
ADAsdASD
3 years, 7 months ago
B is correct: https://docs.actian.com/vector/5.0/index.html#page/SQLLang/GRANT_OPTION_Clause.htm
upvoted 1 times
...
pln95
3 years, 8 months ago
The WITH GRANT OPTION keywords convey the privilege or role to a user with the right to grant the same privileges or role to other users. The answer is B
upvoted 1 times
...
fbz
3 years, 10 months ago
B is correct
upvoted 1 times
...
CertMeUp
4 years, 2 months ago
Correct answer is B.
upvoted 1 times
...
Garyours
4 years, 2 months ago
B is correct, with grant option allows user1 to grant/delegate access right to other users
upvoted 1 times
...
bulat
4 years, 3 months ago
C is incorrect. B - delegating permissions to other users.
upvoted 1 times
...
syed5
4 years, 5 months ago
The WITH GRANT OPTION keywords convey the privilege or role to a user with the right to grant the same privileges or role to other users. You create a chain of privileges that begins with you and extends to user as well as to whomever user subsequently conveys the right to grant privileges.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago