Exam DP203 Path 1: Difference between revisions
No edit summary |
Tag: Manual revert |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 23: | Line 23: | ||
Two types of SQL Pool: | Two types of SQL Pool: | ||
# Serverless | # Serverless - These query file-based data in a data lake. | ||
# Dedicated | # 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. | 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. | |||
Latest revision as of 17:04, 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.