Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are working on a project that involves analyzing a large dataset for a retail company. During the initial data exploration phase, you discover that the dataset contains duplicate records. The dataset is critical for generating monthly sales reports and customer insights. The company emphasizes data accuracy and compliance with data protection regulations. Considering these constraints, which of the following approaches would you recommend to identify and resolve issues with duplicate data in the dataset? (Choose the best option.)