Question

A retail company runs its transactional workload on an Azure SQL Database. The analytics team needs near real-time reporting over this operational data using a lakehouse and Power BI, without impacting the performance of the production OLTP database and without building and maintaining custom ETL pipelines. Which approach should you recommend?

Accepted Answer

Enable Microsoft Fabric mirroring for the Azure SQL Database to continuously replicate data into OneLake for analytics

Answer

Schedule nightly Azure Data Factory copy activities to extract the tables into an Azure Data Lake Storage Gen2 account

Answer

Create a read replica of the Azure SQL Database and point Power BI DirectQuery at the replica

Answer

Deploy an Azure Synapse dedicated SQL pool and load the data with periodic PolyBase imports