Question 1 of 30
A data engineer is tasked with profiling a large dataset containing customer transactions to identify anomalies and ensure data quality before loading it into a data warehouse. The dataset includes fields such as transaction ID, customer ID, transaction amount, transaction date, and payment method. After performing data profiling, the engineer discovers that 15% of the transaction amounts are negative, which is unexpected. What is the most appropriate next step for the data engineer to take in response to this finding?
Investigate the source of the negative transaction amounts to determine if they are legitimate refunds or errors.
Remove all transactions with negative amounts from the dataset without further analysis.
Normalize the transaction amounts to a common scale to eliminate the negative values.
Report the negative transaction amounts to the management team as a data quality issue without further investigation.

Preparing for Microsoft DP-203 Data Engineering on Microsoft Azure? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free