Exam DP203 front-end services Azure Synapse Analytics Studio

From MillerSql.com
Revision as of 16:35, 15 November 2024 by NeilM (talk | contribs)

First front-end_service is 1. Azure Synapse Analytics Studio

To open this, go into the Azure Synapse Analytics Workspace resource, and click a button to open the Azure Synapse Analytics Studio web app.

Pipelines.

Two types of tables can be configured in Azure Synapse Analytics Studio as two tabs:

  1. Workspace
  2. Linked

Functions:

  • Descriptive analytics
  • Diagnostic analytics
  • Predictive analytics
  • Prescriptive analytics

A Workspace typically has a default data lake, which is implemented as a linked service to an Azure Data Lake Storage Gen2 container.

Note there are two meanings of the word "Workspace". The first one is that of the overall Azure Synapse Analytics Resource. The other is the name of the "Workspace" tab.

Looking at the "Workspace" and "Linked" tabs in more detail:

Workspace

Linked

Access by Azure Synapse Analytics Studio to files in Azure Data Lake Storage Gen2 is normally done in the "Linked" tab, under section "Azure Data Lake Storage Gen2" by adding a path to the files in Azure Data Lake Storage Gen2.

This involves providing credentials so that Azure Synapse Analytics Studio is able to connect to Azure Data Lake Storage Gen2.

Retrieved from ‘https://wiki.millersql.com/wiki/index.php?title=Exam_DP203_front-end_services_Azure_Synapse_Analytics_Studio&oldid=920’