Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-204 All Questions

View all questions & answers for the AZ-204 exam
Go to Exam

Exam AZ-204 topic 1 question 14 discussion

Actual exam question from Microsoft's AZ-204
Question #: 14
Topic #: 1
[All AZ-204 Questions]

You manage an Azure SQL database that allows for Azure AD authentication.
You need to make sure that database developers can connect to the SQL database via Microsoft SQL Server Management Studio (SSMS). You also need to make sure the developers use their on-premises Active Directory account for authentication. Your strategy should allow for authentication prompts to be kept to a minimum.
Which of the following should you implement?

  • A. Azure AD token.
  • B. Azure Multi-Factor authentication.
  • C. Active Directory integrated authentication.
  • D. OATH software tokens.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by MrXBasit at July 26, 2021, 2:29 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
MrXBasit
Highly Voted 3 years, 3 months ago
Correct
upvoted 26 times
...
forgetfulalligator
Most Recent 1 month, 3 weeks ago
Selected Answer: C
Active Directory integrated authentication is the correct option as it allows users to connect to the database using their Windows credentials, which are authenticated through their on-premises Active Directory. This option avoids the need for users to enter their credentials each time they connect to the database, reducing authentication prompts to a minimum.
upvoted 2 times
...
harbox
1 month, 3 weeks ago
Selected Answer: C
Azure AD can be the initial Azure AD managed domain. Azure AD can also be an on-premises Active Directory Domain Services that is federated with the Azure AD. Using an Azure AD identity to connect using SSMS or SSDT The following procedures show you how to connect to a SQL database with an Azure AD identity using SQL Server Management Studio or SQL Server Database Tools. Active Directory integrated authentication Use this method if you are logged in to Windows using your Azure Active Directory credentials from a federated domain.
upvoted 1 times
...
UkadikeToch
1 month, 3 weeks ago
Active Directory integrated authentication allows developers to use their on-premises AD account to authenticate and connect to the Azure SQL database. With this method, SSMS uses the logged-in Windows credentials of the user to authenticate against the database. By configuring SSO between on-premises AD and Azure AD, developers can achieve a seamless authentication experience without additional prompts.
upvoted 4 times
...
TusharChandak
1 year, 3 months ago
Selected Answer: C
Correct
upvoted 1 times
...
uffuchsi
1 year, 9 months ago
C - Active Directory integrated authentication
upvoted 1 times
...
OPT_001122
1 year, 11 months ago
Selected Answer: C
C. Active Directory integrated authentication.
upvoted 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel