Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with implementing a stored procedure in a lakehouse for data validation and cleaning on a dataset containing customer information. The dataset includes fields such as customer ID, name, email, and phone number. The solution must ensure data quality while considering cost efficiency and scalability. Which of the following approaches would you choose to implement a stored procedure that best meets these requirements? (Choose one option)