Answer: Eliminates duplicate data, quarantines bad data

The silver layer in a multi-hop architecture is crucial for data cleansing and standardization. It processes the raw data from the bronze layer by removing duplicates, handling inconsistencies, and quarantining records that fail to meet quality standards. This ensures the data is reliable and consistent for further processing in the gold layer. - **A. Optimized query performance for business-critical data**: This is more aligned with the gold layer's objectives, where data is transformed and modeled for performance. - **B. Refined views with aggregated data**: This describes the gold layer's role, where data is aggregated and refined for business analysis. - **D. Efficient storage and querying of full, unprocessed history of data**: This is characteristic of the bronze layer, which stores data in its original form for auditing purposes. - **E. Replaces a traditional data lake**: Multi-hop architecture works within a data lake, not replacing it, by organizing data into bronze, silver, and gold layers for progressive refinement.

Author: LeetQuiz Editorial Team