Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You need to create a stored procedure in your lakehouse that processes and aggregates monthly sales data. Describe the steps you would take to create this stored procedure, including the use of temporary tables and error handling mechanisms.
A
Create the stored procedure without using temporary tables or error handling.
B
Create the stored procedure using temporary tables for intermediate results and implement error handling to manage exceptions.
C
Create the stored procedure only using temporary tables.
D
Create the stored procedure only implementing error handling.