Data warehousing using azure

Which database is used by Azure?
Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud.
Azure SQL is built upon the familiar SQL Server engine, so you can migrate applications with ease and continue to use the tools, languages, and resources you're familiar with..
Azure Data Factory's job is to build data factories on the cloud.
To put it another way, ADF is a cloud-based managed service designed for complicated hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.
Components.
Azure Synapse Analytics is an analytics service for data warehouses and big data systems.
This tool uses a massively parallel processing architecture and has deep integration with Azure services.
Disk Storage
An Azure managed disk is a virtual hard disk (VHD).
You can think of it like a physical disk in an on-premises server but, virtualized.
Azure-managed disks are stored as page blobs, which are a random IO storage object in Azure.

How can Azure synapse analytics help you build a data warehouse?

Learn how Azure Synapse Analytics enables you to build Data Warehouses using modern architecture patterns

Understand file formats and structure for a modern data warehouse Before taking this module, it is recommended that you complete Data Fundamentals

Exercise - Identify modern data warehouse architecture components min

Designing a data warehouse using Azure is essential for storing and analyzing large amounts of data from various sources in a centralized space

Join the DZone community and get the full member experience

Businesses in the modern, data-driven economy significantly rely on data to make wise decisions