MENU
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.
Suggested Answer:
Get Premium AZ-400 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
15 comments · newest first
AL
Alpha
11 months ago
I thought you had to use a service principal for this kind of setup?
ME
Merissa
11 months ago
Don't forget to set the right permissions on KV1!
RE
Refugia
12 months ago
Wait, can you really use managed identities with SQL Server?
CH
Chi
12 months ago
Totally agree, that's the best practice!
DO
Donette
1 year ago
You need to use a managed identity for DF1 to access KV1.
ME
Merri
1 year 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.
KA
Katie
1 year 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!
BU
Bulah
1 year 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.
DE
Della
1 year 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.
RU
Ruth
1 year 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.
GL
Glynda
1 year 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.
WI
Willie
1 year ago
I'd look for unexpected variances, unusual trends, or relationships that don't make sense logically. Those could signal fraud risks.
TW
Twana
1 year 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.
AN
Annamae
1 year ago
Rising import tariffs definitely seem like a macroeconomic factor, but I'm torn about whether equilibrium price fits in that category.
AR
Argelia
1 year ago
I feel like storing a password wouldn't be secure. It must be relying on a more robust method—like a RAM Role.