574 questions with instant explanations, domain breakdown, and wrong-answer analysis. Built for the real exam.
This is exactly what you see during practice — question, options, and a full explanation after you answer.
You are the database administrator for a healthcare organization that uses Azure SQL Database. You need to implement column-level encryption for a column containing patient Social Security numbers (SSNs). The SSNs must be encrypted at rest and in transit, and only authorized client applications should be able to decrypt them. Which technology should you use?
Always Encrypted is the correct choice because it ensures that sensitive data, such as SSNs, is encrypted both at rest and in transit, and the encryption keys are stored client-side (e.g., in Azure Key Vault). This design ensures that only authorized client applications with acce…Read full explanation
You are examining the configuration of an Azure SQL Database in the Business Critical tier. The exhibit shows the database properties. What is the maximum number of readable replicas available for read-only queries?
In the Business Critical service tier of Azure SQL Database, the primary replica is always available for read-write operations, and three additional secondary replicas are automatically provisioned to provide high availability and offload read-only workloads. These three secondar…Read full explanation
You have an Azure SQL Database in the Business Critical tier without zone redundancy. You need to configure a disaster recovery plan that ensures the database is available in a different Azure region within 1 hour of a regional outage. The solution must minimize data loss and not require manual intervention. What should you do?
Active geo-replication provides asynchronous replication to a secondary region, and auto-failover groups enable automatic failover without manual intervention, meeting the RTO of 1 hour with minimal data loss. Option B is incorrect because simply creating a failover group does no…Read full explanation
Answer at your own pace. Explanation and domain tag shown immediately after each answer.
Countdown timer starts immediately. Results and domain scores shown at the end — just like the real exam.
Full explanations on every question
Not just the right answer — you get exactly why each wrong option is wrong, so you learn the concept, not the answer.
Domain score breakdown
After each session see your score by exam domain so you know exactly where to focus study time.
100% free, forever
No subscription, no trial, no email wall. Start a session in under 10 seconds.
Exam-style questions
Scenario-based, precise wording, realistic distractors — written to match what you actually see on exam day.