Exam DP203 Dedicated SQL Pool

Dedicated SQL Pool.

Reads relational data from data Warehouses.

In Synapse Studio Manage - SQL Pools tab, notice that there is an item that has been set up by the tutorial: sql9cxqfg2

Click the arrow to the left of it to resume it. I think this starts up a virtual machine in the background.

Then once it has started, in Data - Workspace, there is header "SQL Database". And inside this is database: sql9cxqfg2 underneath of which is a folder for tables and other metadata. This is a relational database that exists (by virtue of being under "Workspace") only in Synapse Studio.

Once querying is complete, pause the pool to save money.

Set the performance level for the pool: DW100c to DW30000c