Exam 70-764 topic 1 question 252 discussion

Actual exam question from Microsoft's 70-764

Question #: 252
Topic #: 1

You have two databases named DB1 and DB2 that are located on the same server.
You plan to create a stored procedure named SProc1 in DB1. SProc1 will query a table named Table2 in DB2. You need to recommend a solution to ensure that
SProc1 can access Table2 without granting users direct access to Table2.
What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer.

A. Contained databases
B. Application roles
C. Cross-database ownership chaining
D. Digital certificates

Show Suggested Answer

Suggested Answer: B 🗳️
An application role is a database principal that enables an application to run with its own, userlike permissions. You can use application roles to enable access to specific data to only those users who connect through a particular application. Unlike database roles, application roles contain no members and are inactive by default.

by TheSwedishGuy at Jan. 31, 2020, 2:24 p.m.

Comments

Submit Cancel

MSSucks

5 years, 5 months ago

Yes, just from the text of the question you cannot determine the correct answer. "... without granting *users* direct access ... " = "Application Roles" "... without granting users *direct* access ... " = "Cross database ownership chaining"

upvoted 1 times

...

TheSwedishGuy

5 years, 6 months ago

Argh! The question doesn't make clear that an application will be used to run the stored procedure!

upvoted 2 times

KC

4 years, 11 months ago

I appreciate the fact that someone else is frustrated by the phrasing of these questions.

upvoted 1 times

...