Security and Supported File Formats

This lesson covers authentication and authorization in Synapse Analytics, including Azure AD integration for user authentication. It explains the three-layer security model: authentication layer, authorization layer, and data lake access permissions. The lesson also reviews supported file formats including Parquet, JSON, and CSV, recommending Parquet for its columnar storage and superior aggregation query performance.