A private SQL endpoint is reachable by IP, but the application cannot connect using the intended name and has no database data permissions. Which fixes are required? Select 2 answers.

Select all that apply. Every correct option and no extras are required for credit in the app.

A.Configure appropriate DNS and application network routing
B.Remove authentication because traffic is private
C.Increase the SQL tier to grant SELECT automatically
D.Authenticate the application and grant least-privilege database permissions

Show the answer and explanation

✓ Correct answers

Configure appropriate DNS and application network routing
Authenticate the application and grant least-privilege database permissions

Private access still requires correct DNS/routes and principal authorization. Private networking is not an authentication bypass. A more expensive tier does not grant database permissions. Source guide: PDF page 24.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.