In the context of implementing lookup tables in Delta Lake within a Microsoft Azure environment, consider a scenario where your organization is optimizing a data model for both performance and integrity. The project has key constraints including cost efficiency, compliance with data governance policies, and the need for scalable solutions. Discuss the trade-offs between normalized and denormalized data models in this scenario. Additionally, provide a code snippet demonstrating how to create a lookup table in Delta Lake and join it with a main table to retrieve additional information. Choose the option that best describes the trade-offs for normalized data models under these constraints. (Choose one)