Cloud Computing Study Guide - 10
Study Guide
Beginner → Exam Ready
By Levi J.
2026 Edition
Azure Services for Data and Analytics
Overview
Azure provides a comprehensive suite of services for data processing, storage, analytics, and business
intelligence. These services work together to create modern data architectures.
Core Azure Data Services
1. Azure Synapse Analytics
Definition:
Azure Synapse Analytics is an Azure service that combines data warehousing and big data analytics.
Purpose:
It is used to store, process, and analyze large amounts of data.
Key Features:
Data Warehousing - Enterprise data warehouse capabilities
Big Data Analytics - Process large-scale data using Spark
Real-Time Analytics - Analyze streaming data
Business Intelligence - Integrated visualization and reporting
Components:
SQL Pools - Serverless SQL for data exploration
Spark Pools - Apache Spark for big data processing
Page 1 of 10
, Cloud Computing Study Guide - 10
Pipelines - Data integration and orchestration
DevOps - Integrated development experience
Use Cases:
Enterprise data warehousing
Big data processing
Real-time analytics
Data exploration and visualization
2. Azure Data Factory
Definition:
Azure Data Factory is a cloud service used to create data pipelines.
What is a Pipeline?
A pipeline is a set of steps that moves and transforms data between systems.
Key Features:
Data Movement - Copy data between sources and destinations
Data Transformation - Transform data using various compute services
Orchestration - Schedule and coordinate data activities
Monitoring - Track pipeline performance and execution
Example:
Moving customer data from a SQL database into Azure Synapse.
Capabilities:
Supports both ETL and ELT patterns
Connects to 90+ data sources
Visual pipeline designer
Code-free transformation options
Integration with other Azure services
Page 2 of 10
Study Guide
Beginner → Exam Ready
By Levi J.
2026 Edition
Azure Services for Data and Analytics
Overview
Azure provides a comprehensive suite of services for data processing, storage, analytics, and business
intelligence. These services work together to create modern data architectures.
Core Azure Data Services
1. Azure Synapse Analytics
Definition:
Azure Synapse Analytics is an Azure service that combines data warehousing and big data analytics.
Purpose:
It is used to store, process, and analyze large amounts of data.
Key Features:
Data Warehousing - Enterprise data warehouse capabilities
Big Data Analytics - Process large-scale data using Spark
Real-Time Analytics - Analyze streaming data
Business Intelligence - Integrated visualization and reporting
Components:
SQL Pools - Serverless SQL for data exploration
Spark Pools - Apache Spark for big data processing
Page 1 of 10
, Cloud Computing Study Guide - 10
Pipelines - Data integration and orchestration
DevOps - Integrated development experience
Use Cases:
Enterprise data warehousing
Big data processing
Real-time analytics
Data exploration and visualization
2. Azure Data Factory
Definition:
Azure Data Factory is a cloud service used to create data pipelines.
What is a Pipeline?
A pipeline is a set of steps that moves and transforms data between systems.
Key Features:
Data Movement - Copy data between sources and destinations
Data Transformation - Transform data using various compute services
Orchestration - Schedule and coordinate data activities
Monitoring - Track pipeline performance and execution
Example:
Moving customer data from a SQL database into Azure Synapse.
Capabilities:
Supports both ETL and ELT patterns
Connects to 90+ data sources
Visual pipeline designer
Code-free transformation options
Integration with other Azure services
Page 2 of 10
