SC-100 Question #134: Real Exam Question with Answer & Explanation

Question

Your company has on-premises Microsoft SQL Server databases. The company plans to move the databases to Azure. You need to recommend a secure architecture for the databases that will minimize operational requirements for patching and protect sensitive data by using dynamic data masking. The solution must minimize costs. What should you include in the recommendation?

Options

• ASQL Server on Azure Virtual Machines
• BAzure Synapse Analytics dedicated SQL pools
• CAzure SQL Database

Explanation

{"question_number": 4, "correct_answer": "C", "explanation": "Azure SQL Database (C) is the correct choice for three reasons: First, it is a fully managed PaaS service - Microsoft handles all OS and SQL Server patching, minimizing operational overhead. Second, it natively supports dynamic data masking as a built-in feature that can be configured without additional tooling. Third, it is significantly less expensive than Azure Synapse Analytics dedicated SQL pools (B), which are purpose-built for large-scale analytics workloads and carry much higher costs. SQL Server on Azure Virtual Machines (A) is an IaaS offering that requires the customer to manage and apply patches manually, violating the 'minimize operational requirements for patching' constraint.", "generated_by": "claude-sonnet", "llm_judge_score": 4}

No community discussion yet for this question.