What is Azure SQL used for?
Azure SQL is a cloud based Azure SQL Server Database that is used for data warehousing.  It contains data tables, sql queries, stored procedures, grants and permissions.  System of Record (SoR) can be accessed and flow to the Azure SQL Server Database using a data pipeline or the Azure SQL API.  Once the data lands in Azure SQL you will need to consider a strategy for how to handle change data capture (CDC).  The data can be served to the business from Azure SQL Database for dashboarding and business reporting.