MENU
D18912E1457D5D1DDCBD40AB3BF70D5D
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?
Suggested Answer: E
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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;
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql
13 comments · newest first
FR
Francesco
11 months ago
I’m not sure about D, asymmetric keys are a bit overkill here.
AR
Arlene
12 months ago
Option C is solid too, especially for internal users.
JE
Jessenia
12 months ago
Wait, can we really use external providers for this? Seems risky.
TA
Tayna
1 year ago
Definitely agree with E, it fits compliance needs.
DA
Dallas
1 year ago
I think option E is the best choice for external authentication.
LE
Lettie
1 year ago
I feel like the ASYMMETRIC KEY clause was mentioned in our last session, but I can't recall if it applies to this scenario.
TO
Tonja
1 year ago
I practiced a similar question where we had to choose between CREATE USER and different clauses. I think the FROM LOGIN clause could be relevant for linking users to logins.
LI
Linwood
1 year ago
I'm not entirely sure, but I think CREATE LOGIN is more about server-level access, while we need something specific for the database.
BE
Beatriz
1 year ago
I remember we discussed the importance of using the FROM EXTERNAL PROVIDER clause for modern authentication methods. That might be the right choice here.
AL
Alyce
1 year ago
I'm a bit unsure about this one. I'll need to refer back to the course materials to refresh my memory on the database schema and table relationships.
CH
Chauncey
1 year ago
Hmm, I'm a bit unsure about this one. I know compensation has different components, but I'm not totally clear on the exact terminology. I'll have to think this through carefully.
KE
Keshia
1 year ago
I'm a little confused by all the different IBM Spectrum products. They seem to have a lot of storage solutions, and it's not always clear how they differ. I'll need to review my notes to make sure I understand the key capabilities of each one.
RE
Renay
1 year ago
Hmm, I'm a bit confused by the wording of the options. I'll need to double-check the adjustments and make sure I'm matching them correctly to the journal entries. Taking my time and verifying my understanding will be important here.