Analyze and optimize data warehouse storage in Azure Synapse Analytics

Analyze and optimize data warehouse storage in Azure Synapse Analytics

In this module, you will learn to analyze information used to optimize a data warehouse in Azure Synapse Analytics.

Data Engineer
Synapse Analytics

Module Objectives

In this module, you will:

  • Understand skewed data and space usage
  • Understand column store storage details
  • Understand the impact of wrong choices for column data types
  • Describe the impact of materialized views
  • Understand rules for minimally logged operations

Prerequisites

  • It is recommended that students understand how Azure Synapse Analytics works