MENU
You are investigating a slow-performing query entity which is mapped to a view and you decide to look in the data_store_details.csv log to gain more information. You see that the majority of the time is spent in the transform phase.
Which two actions can you take to reduce the time spent in the transform phase? (Choose two.)
Suggested Answer: B, D
Get Premium ACD200 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
5 comments · newest first
NE
Nettie
3 days ago
A) and B) are solid choices!
LE
Leah
9 days ago
Lowering the batch size might help, but I feel like it could also slow things down if not done right.
TY
Tyisha
14 days ago
Creating an index sounds like a good idea, but I’m a bit uncertain if it would directly affect the transform phase.
CH
Chaya
19 days ago
I remember a practice question where we had to optimize a query, and reducing the number of returned columns was definitely one of the strategies.
GE
Georgene
24 days ago
I think reducing unnecessary columns in the GROUP BY clause could help, but I'm not entirely sure how much of an impact it would have.