View all questions & answers for the DP-300 exam
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?
CREATE LOGIN and the FROM WINDOWS clause
CREATE USER and the FROM CERTIFICATE clause
CREATE USER and the FROM LOGIN clause
CREATE USER and the ASYMMETRIC KEY clause
CREATE USER and the FROM EXTERNAL PROVIDER clause
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;
Submit