You are designing a medallion architecture in Microsoft Fabric. Which THREE tasks are essential for the 'Silver' layer processing?
Deduplication is a core function of the Silver layer. By removing redundant entries, the system ensures that analytical queries return accurate results. This process is vital for maintaining data quality and preventing inflated metrics, which are common issues when raw source data contains overlapping or multiple records for the same entity.
Why this answer
The Silver layer serves as the refined, validated, and conformed data store. Essential tasks include deduplicating records to ensure uniqueness, enforcing data types to ensure schema consistency, and applying business logic to standardize formats across different source systems. These steps bridge the gap between raw data and analytical readiness, ensuring that downstream consumers can trust the data without performing repetitive, complex cleaning operations on every single query or report.
Exam trap
Candidates often confuse Bronze layer ingestion tasks with Silver layer processing, incorrectly including raw data preservation or appending uncleaned logs as primary Silver layer responsibilities.