Consider a scenario where you need to load a DataFrame in Azure Databricks with sensitive information from an Azure SQL Database. What encryption methods would you use to protect the data both at rest and in transit, and how would you implement these methods?

Simulated

Explanation:

Azure SQL Database provides built-in encryption for data at rest (TDE) and supports SSL/TLS for data in transit, ensuring comprehensive protection for sensitive data.