
Ultimate access to all questions.
Consider a scenario where a dataflow is experiencing significant delays during the data loading process. The dataflow is designed to ingest large volumes of transactional data from multiple sources. Identify potential bottlenecks and suggest performance improvements. Specifically, discuss how you would analyze the dataflow to identify bottlenecks, and what strategies you would employ to optimize the data loading process.
A
Increase the number of partitions in the dataflow.
B
Optimize SQL queries and use indexing where applicable.
C
Reduce the number of data sources and consolidate them.
D
Increase the memory allocation for the dataflow.