Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 9 Question 31 Discussion

D18912E1457D5D1DDCBD40AB3BF70D5DYou need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.What should you run as part of the implementation?
E) CREATE USER and the FROM EXTERNAL PROVIDER clause
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

Microsoft DP-300 Exam - Topic 9 Question 31 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 31
Topic #: 9
[All DP-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: E

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

by Izetta at May 10, 2022, 01:45 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Francesco
9 months ago
I’m not sure about D, asymmetric keys are a bit overkill here.
upvoted 0 times
...
Arlene
9 months ago
Option C is solid too, especially for internal users.
upvoted 0 times
...
Jessenia
9 months ago
Wait, can we really use external providers for this? Seems risky.
upvoted 0 times
...
Tayna
9 months ago
Definitely agree with E, it fits compliance needs.
upvoted 0 times
...
Dallas
9 months ago
I think option E is the best choice for external authentication.
upvoted 0 times
...
Lettie
9 months 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.
upvoted 0 times
...
Tonja
10 months 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.
upvoted 0 times
...
Linwood
10 months 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.
upvoted 0 times
...
Beatriz
10 months 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.
upvoted 0 times
...
Alyce
10 months 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.
upvoted 0 times
...
Chauncey
10 months 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.
upvoted 0 times
...
Keshia
10 months 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.
upvoted 0 times
...
Renay
10 months 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.
upvoted 0 times
...

Save Cancel