ACD200 Exam Dumps | You are investigating a slow-performing query entity which is mapped to a view and you decide to look

<< Prev Question Next Question >>

Question 17/39

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.)

A. Reduce the number of columns returned from the query.

B. Reduce the use of unnecessary columns in the GROUP BY clause in the database view.

C. Lower the batch size parameter of the query.

D. Create a database index on the column being filtered against.

Question 17/39

LEAVE A REPLY

Download PDF File