Which of the following features enhances the security of Azure SQL Database?

Disable ads (and more) with a premium pass for a one time $4.99 payment

Prepare for the Microsoft Certified: Azure Database Administrator Associate (DP-300) exam with flashcards and multiple choice questions, complete with hints and explanations. Get exam-ready today!

Threat detection is a key feature of Azure SQL Database that actively enhances security. It continuously monitors the database for potentially harmful activities, such as unusual access patterns or attempted SQL injection attacks. When a threat is detected, the system generates alerts to inform the database administrators of the potential threat, allowing them to take immediate action to safeguard their data.

This proactive approach to security is essential in an era where cyber threats are increasingly sophisticated. By providing intelligence and insights into security vulnerabilities, threat detection enables organizations to remain vigilant and responsive to potential risks, ensuring that their database environments are well-protected.

In contrast, while manual scaling of resources, database replication, and data archiving policies may contribute to the overall functionality and management of the database, they do not directly enhance security. Manual scaling pertains to resource allocation, replication focuses on redundancy and availability, and archiving relates to data management rather than protective measures against security threats.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy