DP-300 Certification Practice Question #82

Question

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:

Accepted Answer

To impersonate a database-level user named `user1` in Azure SQL Database, you use the `EXECUTE AS USER = 'username'` syntax. Impersonation of database users is performed at the database level using `USER`. Once the test query is executed, you return to the original caller's context by using the `REVERT` command.

More DP-300 practice questions