Exam DP203 Storage 3 Azure Lake Database: Difference between revisions
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
To create a Lake Database, go into Synapse Studio '''Data''' tab, and click the '''+ button''' and select Lake Database under "Workspace". This creates a new section "Lake Database" under which the database is created, under '''Data''' - '''Workspace'''. | To create a Lake Database, go into Synapse Studio '''Data''' tab, and click the '''+ button''' and select Lake Database under "Workspace". This creates a new section "Lake Database" under which the database is created, under '''Data''' - '''Workspace'''. | ||
In the design section, you can choose a template from different business scenarios, or choose to create it as empty. Then after you can add tables to it. | In the design section, you can choose a template from different business scenarios, or choose to create it as empty. Then after you can add tables to it, including key relationships between tables. | ||
Revision as of 21:11, 16 November 2024
The third Storage type is: Azure Lake Database.
The underlying data is in Parquet or CSV files only.
Serverless SQL Pool, or Spark.
To create a Lake Database, go into Synapse Studio Data tab, and click the + button and select Lake Database under "Workspace". This creates a new section "Lake Database" under which the database is created, under Data - Workspace.
In the design section, you can choose a template from different business scenarios, or choose to create it as empty. Then after you can add tables to it, including key relationships between tables.