Data warehouse workload means a very big database with a lot of range or full scans. Against it, everything must be subject to the response time. Azure SQL Data Warehouse fulfills these requirements through its very complex design.
The following screenshot shows the SQL Data Warehouse architecture:
The only point of contact with Azure SQL Data Warehouse is an SQL Server instance called control node. Control node responds to user requests and also receives data incoming during ETL executions. The control node itself plays the main role in the distribution of load between compute nodes. Every compute node is an SQL Server ...
