Question 630
An application team must address both issues before release. An SQL database accepts connections from every public IP even though all legitimate clients run in a designated Azure virtual network. A Data API builder deployment stores a privileged SQL connection secret directly in a checked-in YAML file. Which response best addresses these needs?
Explanation
Correct Answer
First, network reachability should be limited to required sources rather than relying solely on login credentials. Second, source control history may retain exposed credentials even if the latest file is later edited.
Incorrect Answers
Restrict firewall and private connectivity to approved workloads and validate intended client access; Scope model invoke permissions and impose budget and use-case controls independently from the private network design: source control history may retain exposed credentials even if the latest file is later edited.
Remove and rotate the secret and reference an approved protected configuration source in deployment; do not restrict firewall and private connectivity to approved workloads and validate intended client access: restrict firewall and private connectivity to approved workloads and validate intended client access.
Use tenant- and workload-scoped identities or credentials with independent rotation and audit capability; remove and rotate the secret and reference an approved protected configuration source in deployment: network reachability should be limited to required sources rather than relying solely on login credentials.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests