What should you run as part of the implementation?

You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.

What should you run as part of the implementation?
A . CREATE LOGIN and the FROM WINDOWS clause
B . CREATE USER and the FROM CERTIFICATE clause
C . CREATE USER and the FROM LOGIN clause
D . CREATE USER and the ASYMMETRIC KEY clause
E . CREATE USER and the FROM EXTERNAL PROVIDER clause

View Answer

Answer: E

Explanation:

Scenario: Authenticate database users by using Active Directory credentials.

(Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01.) Authenticate the user in SQL Database or SQL Data Warehouse based on an Azure Active Directory user:

CREATE USER [Fritz@contoso.com] FROM EXTERNAL PROVIDER;

Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql