MicrosoftMicrosoft
DP-700 · Question #59
DP-700 Question #59: Real Exam Question with Answer & Explanation
Sign in or unlock DP-700 to reveal the answer and full explanation for question #59. The question stem and answer options stay visible for context.
Monitor and optimize a data analytics solution
Question
You have a data warehouse that is experiencing performance issues during data loading. The data warehouse is using a partitioned table. You have noticed that the data loading process is taking a long time. Which of the following actions would be most effective in improving data loading performance ?
Options
- AIncrease the number of partitions in the table.
- BDecrease the number of partitions in the table.
- CIncrease the number of dataflow units in the pipeline.
- DIncrease the memory allocation for the pipeline.
Unlock DP-700 to see the answer
You've previewed enough free DP-700 questions. Unlock DP-700 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Data Loading Optimization#Table Partitioning#Data Warehouse Performance#Parallel Processing