What does a DBA mainly do?
Manage databases, security, backups, and performance.
DBA stands for Database Administrator.
What does a Data Engineer mainly do?
Build data pipelines (ETL/ELT), move/clean data, integrate systems.
ETL stands for Extract, Transform, Load.
What does a Data Analyst mainly do?
Analyse data, create dashboards, find insights.
Data Analysts focus on interpreting data to support decision-making.
Why have data roles grown?
Because data volume exploded and businesses rely on data to compete.
The increase in digital data has created a demand for data professionals.
What is Azure SQL Database?
A fully managed SQL database in the cloud.
It provides built-in high availability and security.
What is Azure SQL Managed Instance?
A more flexible cloud SQL service similar to full SQL Server.
It allows for easier migration from on-premises SQL Server.
What is Azure SQL VM?
A virtual machine running SQL Server with full server control.
Users have complete control over the SQL Server environment.
Who mainly uses Azure SQL services?
- DBAs
- Data Engineers
- Data Analysts
These roles utilize Azure SQL for database management and analysis.
What does Azure Database for MySQL/Postgres/MariaDB provide?
Managed open-source relational databases.
These services simplify database management for developers.
What is Azure Cosmos DB?
A global-scale NoSQL database supporting multiple data models.
It is designed for high availability and low latency.
Name four Cosmos DB data models.
- Document
- Key-Value
- Column-Family
- Graph
These models allow for flexible data storage and retrieval.
Who uses Cosmos DB most?
- Developers
- Data engineers
They leverage its capabilities for building scalable applications.
What is Azure Storage used for?
Storing raw files, blobs, and big data.
It provides scalable storage solutions for various data types.
Name 3 Azure Storage types.
- Blob storage
- File shares
- Data lake storage
Each type serves different storage needs.
Who uses Azure Storage heavily?
Data Engineers.
They require storage solutions for data processing and analytics.
What is Azure Data Factory (ADF)?
Azure’s main ETL tool for moving and transforming data.
ADF facilitates data integration from various sources.
Who uses ADF?
Data Engineers.
They utilize ADF for data pipeline creation and management.
What is Azure Synapse Analytics?
A unified platform including pipelines, SQL pools, Spark, and Data Explorer.
It integrates big data and data warehousing.
Name Synapse’s 4 main components.
- Pipelines
- SQL Pools
- Apache Spark
- Data Explorer
These components work together for data analytics and processing.
Who uses Synapse?
- Data engineers
- Data analysts
- Data scientists
These roles benefit from its comprehensive analytics capabilities.
What is Azure Databricks?
A platform combining Spark with notebooks for big data & ML.
It enhances collaborative data science and engineering.
Who typically works in Databricks?
- Data engineers
- Data scientists
They use Databricks for data processing and machine learning tasks.
What is Azure HDInsight?
Cloud-hosted clusters for open-source tools like Spark, Hive, Kafka.
It provides a managed environment for big data processing.
What is Azure Stream Analytics used for?
Real-time data processing (IoT, logs, events).
It enables real-time insights from streaming data.
-
Core Data Concepts30
-
Data Roles and Services30
-
Fundamental relational data concepts34
-
Explore relational database services in Azure30
-
Explore Azure Storage for non-relational data30
-
Explore fundamentals of Azure Cosmos DB30
-
Explore fundamentals of large scale analytics30
-
Explore fundamentals of real time analytics30
