You work for MDFT Pro, a well-known training agency with an Azure subscription for cloud database deployments. Mark, the In-Memory Database Specialist, needs to deploy a new Azure SQL managed instance to host a high-performance student analytics database. The database will run complex analytical queries that process large datasets of student performance metrics, course completion rates, and learning patterns. These queries heavily utilize in-memory processing and require substantial memory for optimal performance. Additionally, the database handles real-time updates from the learning platform and must minimize latency for both read and write operations. Mark needs to select a configuration that optimizes latency for the best transaction performance and maximizes the memory-to-vCore ratio to ensure sufficient memory for the memory-intensive analytical workloads.
Which service tier and hardware generation should you use?
Choose all correct answers from the options below.
Explanations for each answer: