Exam DP-300 topic 2 question 16 discussion

Actual exam question from Microsoft's DP-300

Question #: 16
Topic #: 2

You have an Azure subscription that contains a server named Server1. Server1 hosts two Azure SQL databases named DB1 and DB2.
You plan to deploy a Windows app named App1 that will authenticate to DB2 by using SQL authentication.
You need to ensure that App1 can access DB2. The solution must meet the following requirements:
✑ App1 must be able to view only DB2.
✑ Administrative effort must be minimized.
What should you create?

A. a contained database user for App1 on DB2
B. a login for App1 on Server1
C. a contained database user from an external provider for App1 on DB2
D. a contained database user from a Windows login for App1 on DB2

Show Suggested Answer

Suggested Answer: A 🗳️

by quermi at Nov. 9, 2021, 5:10 p.m.

Comments

Submit Cancel

Ciupaz

Highly Voted 7 months, 1 week ago

Selected Answer: A

The question specify "by using SQL authentication". So is NOT External Provider or Windows login, but only Contained Database use.

upvoted 6 times

...

quermi

Highly Voted 1 year, 7 months ago

It's correct. Login to server will get access at all database in the server and it is not possible. External provider and windows login aren't SQL authentication

upvoted 6 times

...

duman_sarin

Most Recent 1 year, 6 months ago

Correcr answer

upvoted 5 times

...