
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are designing a data pipeline that integrates stored procedures, notebooks, and dataflows to process and analyze data for a retail company. The company requires the pipeline to be cost-effective, scalable, and maintainable, with each component executing in a specific sequence to ensure data integrity. Given these requirements, which of the following approaches should you take to optimally add these components to the data pipeline? (Choose one correct option)
A
Combine all components into a single activity within the data pipeline to minimize costs and simplify management.
B
Use a dataflow activity to encapsulate the execution of stored procedures, notebooks, and other dataflows, reducing the number of activities in the pipeline.
C
Schedule each component to run independently at different times and manually merge the results in the data pipeline to avoid conflicts.
D
Add each component as a separate activity within the data pipeline to allow for independent execution, proper sequencing, and easier troubleshooting.