Answer-first summary for fast verification
Answer: Design a stored procedure that directly modifies the existing customer dataset by adding a new column to indicate membership status, based on a predefined condition.
Option D is the optimal choice because it adheres to the requirement of efficiency and minimal data manipulation. By updating the dataset in-place to include the new column, the solution avoids the overhead of creating additional tables or performing join operations. This approach not only simplifies the process but also enhances performance by reducing the complexity and storage requirements.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer, you are tasked with enhancing a dataset within a lakehouse environment. The dataset comprises customer information, and you need to add a new column that identifies premium members. The solution must be efficient, minimize data manipulation, and not require the creation of additional tables. Considering these constraints, which approach should you implement in your stored procedure? (Choose one correct answer)
A
Develop a stored procedure that performs a join operation between the customer dataset and a separate premium member dataset, then appends a new column to signify membership status.
B
Implement a stored procedure that filters the customer dataset to exclusively include premium members and subsequently adds a new column to denote membership status.
C
Construct a stored procedure that generates a new table combining the customer dataset with a new column for membership status, determined by a specific condition.
D
Design a stored procedure that directly modifies the existing customer dataset by adding a new column to indicate membership status, based on a predefined condition.
No comments yet.