Exam DP203 Path 1: Difference between revisions
No edit summary |
|||
| Line 29: | Line 29: | ||
Note I think these are distinct from Azure SQL Database. | Note I think these are distinct from Azure SQL Database. | ||
== Azure Synapse Link == | |||
Azure Synapse Link. Allows data to be moved between the various services. | |||
Revision as of 16:50, 15 November 2024
Path 1
Streaming data. Stream Analytics. Azure Event Hubs. Streaming vs Batch processing
Structured, semi-structured, and unstructured data.
Azure Data Lake Storage Gen2
Operational data (OLTP) vs Analytical data
Source to Sink
Azure Portal
In the portal, open a script window. This can run Bash or Powershell (.ps1 files).
Resource Groups and resources
Create a Resource Group.
In this, create Resources.
An example of a Resource is a Synapse Analytics "Workspace". You click on this to go into its properties, and in here is a button to click to open Azure Synapse Analytics Studio.
SQL Pools
Two types of SQL Pool:
- Serverless - These query file-based data in a data lake.
- Dedicated - These query relational data in a data warehouse.
Dedicated pools cost money to run, and need to be started up before they can be used. I think they are probably implemented as a virtual Windows machine that is run in the background, with the startup time being required for the reboot to take place.
Note I think these are distinct from Azure SQL Database.
Azure Synapse Link
Azure Synapse Link. Allows data to be moved between the various services.