Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.