Exam DP203 Dedicated SQL Pool: Difference between revisions

Revision as of 15:53, 18 November 2024

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

Revision as of 20:00, 15 November 2024 view source NeilM (talk \| contribs) 1,601 edits No edit summary Tag: Visual edit ← Older edit		Revision as of 15:53, 18 November 2024 view source NeilM (talk \| contribs) 1,601 edits No edit summary Tag: Visual edit Newer edit →
Line 10:		Line 10:

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

			Set the performance level for the pool: ''DW100c'' to ''DW30000c''