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
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