ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam
Go to Exam

Exam 70-764 topic 1 question 84 discussion

Actual exam question from Microsoft's 70-764
Question #: 84
Topic #: 1
[All 70-764 Questions]

You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure.
You need to grant only the necessary permissions.
What should you do?

  • A. Grant EXECUTE permission on p_AddInventory to all users. Grant VIEW DEFINITION to all users.
  • B. Grant EXECUTE permission on p_AddInventory to all users. Add all users to the db_datawriter role.
  • C. Add all users to the db_owner role.
  • D. Grant EXECUTE permission on p_Add!nventory to all users. Add all users to the db_datareader role.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Spicy2312 at April 22, 2019, 11:21 p.m.

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
Submit Cancel
tapsAch
4 years, 4 months ago
D is the correct answer. db_datareader to read data from all the tables and EXECUTE to perform for SP
upvoted 1 times
...
techiebuddhas
4 years, 10 months ago
B and D are same, It seems some Typo in D, then B is the correct answer!
upvoted 1 times
SuzMoore
4 years, 10 months ago
B and D aren't the same. B is datawriter and D is datareader, since they want select permissions they need datareader. So D is the correct answer it just has a typo
upvoted 3 times
...
...
TheSwedishGuy
4 years, 10 months ago
Yes, the users needs to be able to SELECT (i.e. have db_datareader at a minimum) and also to EXECUTE the stored procedure. So D is correct.
upvoted 2 times
...
Spicy2312
5 years, 7 months ago
Even with this typo "!" D would still be the answer?
upvoted 2 times
Slava_bcd81
4 years, 3 months ago
it implies one should parse procedure names at the beginning
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago