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 AZ-400 Exam - Topic 5 Question 69 Discussion

You have an Azure subscription that contains the resources shown in the following table.You plan to create a linked service in DF1. The linked service will connect to SQL1 by using Microsoft SQL Server authentication. The password for the SQL Server login will be storedin KV1.You need to configure DF1 to retrieve the password when the data factory connects to SQL1. The solution must use the principle of least privilege.How should you configure DF1? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.

Microsoft AZ-400 Exam - Topic 5 Question 69 Discussion

Actual exam question for Microsoft's AZ-400 exam
Question #: 69
Topic #: 5
[All AZ-400 Questions]

You have an Azure subscription that contains the resources shown in the following table.

You plan to create a linked service in DF1. The linked service will connect to SQL1 by using Microsoft SQL Server authentication. The password for the SQL Server login will be stored

in KV1.

You need to configure DF1 to retrieve the password when the data factory connects to SQL1. The solution must use the principle of least privilege.

How should you configure DF1? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

https://docs.microsoft.com/en-us/azure/data-factory/store-credentials-in-key-vault

by Umar at Nov 22, 2022, 02:54 AM

Limited Time Offer

25%

Off

Get Premium AZ-400 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Alpha
10 months ago
I thought you had to use a service principal for this kind of setup?
upvoted 0 times
...
Merissa
10 months ago
Don't forget to set the right permissions on KV1!
upvoted 0 times
...
Refugia
10 months ago
Wait, can you really use managed identities with SQL Server?
upvoted 0 times
...
Chi
10 months ago
Totally agree, that's the best practice!
upvoted 0 times
...
Donette
10 months ago
You need to use a managed identity for DF1 to access KV1.
upvoted 0 times
...
Merri
11 months ago
I’m a bit confused about the steps to retrieve the password from Key Vault. I think we have to use a specific authentication method, but I can't remember which one.
upvoted 0 times
...
Katie
11 months ago
This question feels similar to one we practiced where we had to configure a linked service with Azure SQL. I hope I remember the least privilege principle correctly!
upvoted 0 times
...
Bulah
11 months ago
I think we need to set up a managed identity for DF1 to access KV1, but I can't recall the exact permissions needed.
upvoted 0 times
...
Della
11 months ago
I remember something about using Azure Key Vault to store passwords securely, but I'm not sure how to link it to Data Factory.
upvoted 0 times
...
Ruth
11 months ago
The key seems to be that they need to use Oracle Database and can't install any additional software on the on-premises servers. I'm leaning towards option C, the SAP Software Update Manager (SUM) Database Migration Option.
upvoted 0 times
...
Glynda
11 months ago
Wait, I'm confused. I thought the inode structure size was the main factor in determining file system capacity. I'll have to double-check my understanding on this one.
upvoted 0 times
...
Willie
11 months ago
I'd look for unexpected variances, unusual trends, or relationships that don't make sense logically. Those could signal fraud risks.
upvoted 0 times
...
Twana
11 months ago
I've got a good strategy for this. I'll eliminate the options that are less relevant, like earning profits and creating hierarchies, and focus on the ones about pooling resources, sharing skills, and specialization.
upvoted 0 times
...
Annamae
11 months ago
Rising import tariffs definitely seem like a macroeconomic factor, but I'm torn about whether equilibrium price fits in that category.
upvoted 0 times
...
Argelia
11 months ago
I feel like storing a password wouldn't be secure. It must be relying on a more robust method—like a RAM Role.
upvoted 0 times
...

Save Cancel