Correct Answer: Azure SQL Managed Instance
Azure SQL Managed Instance provides the best of SQL Server with the benefits of a fully managed service....
Correct Answer
Azure SQL Managed Instance
Why This Answer Is Correct
Azure SQL Managed Instance provides the best of SQL Server with the benefits of a fully managed service.
This question evaluates your knowledge of Azure SQL Database — a core concept tested in Microsoft Certified: Azure Fundamentals (AZ-900). Understanding Azure SQL Database is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
A financial application requires a relational database that supports high availability and automated backups. The database must be fully managed to reduce operational overhead. Which service fits these requirements?
Which Azure SQL Database service tier is best suited for most business workloads, providing balanced compute and storage options?
Your application requires a relational database that can automatically scale compute resources up and down based on demand, and pause during periods of inactivity to save costs. Which option should you choose?
What is the purpose of Transparent Data Encryption (TDE) in Azure SQL Database?
You need to store and manage relational data for multiple independent databases while sharing a fixed set of resources (CPU and memory). Which Azure SQL Database feature should you use?