Explain the fundamental differences between a data warehouse and a data lake, and describe when you would choose one over the other for an enterprise client.
Use the supplied platform and asset metadata to produce a concise comparison that supports this decision.
platform_name, storage_model, asset_count, structured_asset_pct, governed_asset_pct, and recommended_forstorage_model, then platform_name| Column | Type | Description |
|---|---|---|
| platform_idPK | INT | Unique storage platform identifier |
| platform_name | VARCHAR(120) | Name of the storage platform |
| storage_model | VARCHAR(30) | Storage classification, such as warehouse or lake |
| Column | Type | Description |
|---|---|---|
| asset_idPK | INT | Unique data asset identifier |
| platform_id | INT | Referenced storage platform identifier |
| asset_name | VARCHAR(120) | Name of the data asset |
| asset_type | VARCHAR(30) | Data shape classification |
| governance_status | VARCHAR(30) | Governance and catalog status |