🔥 3-day streak
Microsoft Azure Solutions Architect Expert127 / 187
Question 127 of 187

A financial services company runs a mission-critical order-processing workload on Azure SQL Database in the Business Critical tier. Analysts increasingly run large, complex reporting queries directly against the production database, and these queries are causing latency spikes and blocking for the transactional workload. The company wants to enable near-real-time analytics on the operational data without impacting transactional performance, and without building and maintaining a separate ETL pipeline. Which solution should you recommend?

Reviewed for accuracy · Report an issueNext question