Deal of the Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 70-465 Topic 1 Question 3 Discussion

Actual exam question for Microsoft's 70-465 exam
Question #: 3
Topic #: 1
[All 70-465 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer: B

An application role is a database principal that enables an application to run with its own, user-like 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.


Currently there are no comments in this discussion, be the first to comment!

Save Cancel