AZ-400 · Question #192
AZ-400 Question #192: Real Exam Question with Answer & Explanation
Sign in or unlock AZ-400 to reveal the answer and full explanation for question #192. The question stem and answer options stay visible for context.
Question
SIMULATION You manage a website that uses an Azure SQL Database named db1 in a resource group named RG1lod11566895. You need to modify the SQL database to protect against SQL injection. To complete this task, sign in to the Microsoft Azure portal. Answer: Set up Advanced Threat Protection in the Azure portal 1. Sign into the Azure portal. 2. Navigate to the configuration page of the server you want to protect. In the security settings, select Advanced Data Security. 3. On the Advanced Data Security configuration page: 4. Enable Advanced Data Security on the server. Note: Advanced Threat Protection for Azure SQL Database detects anomalous activities indicating unusual and potentially harmful attempts to access or exploit databases. Advanced Threat Protection can identify Potential SQL injection, Access from unusual location or data center, Access from unfamiliar principal or potentially harmful application, and Brute force SQL credentials Reference: https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create https://docs.microsoft.com/en-us/azure/azure-sql/database/threat-detection-configure
Options
- taskSet up Advanced Threat Protection in the Azure portal to protect an Azure SQL Database against SQL injection
- prerequisitesAzure portal access
Unlock AZ-400 to see the answer
You've previewed enough free AZ-400 questions. Unlock AZ-400 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.