Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 2

© examsnet.com

Question : 28 of 40

Marks: +1, -0

HOTSPOT
You have an Azure SQL database named db1 that contains an Azure Active Directory (Azure AD) user named user1. You need to test impersonation of user1 in db1 by running a SELECT statement and returning to the original
execution context. How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Hot Area:

EXECUTE AS ______ = 'user1@contoso.com' ______
CALLER
LOGIN
OWNER
USER
GO SELECT SUSER_SNAME() GO ______
REVERT
REVOKE
ROLLBACK

Go to Question:

Prev Question

Next Question