The ability to discern key insights from the information available to you is an important part of any data solution. Azure Synapse Analytics provides a limitless managed cloud service for both traditional data warehousing and big data analytics. In this hands-on lab scenario, you are the DBA for Awesome Company. You’ve been asked to investigate using Azure Synapse Analytics as the company’s central analytics platform. Performing the actions of this lab will help you become familiar with deploying an Azure Synapse Analytics workspace and a dedicated Synapse SQL pool.
Successfully complete this lab by achieving the following learning objectives:
- Create a Synapse Workspace
Before you can create a dedicated SQL pool for T-SQL-based compute and storage, you must create a workspace for it to reside in.
- Create a SQL Pool
Now that your workspace is available, create a dedicated SQL pool for it.
- Query Data
Use Azure Synapse Studio to query sample data.