Option B is not the best because increasing the SQL endpoint's scaling range addresses resource limits, but doesn't directly resolve the latency issue, which is likely caused by insufficient resource allocation or optimization.

For more explanation, you can use these Databricks Certified Data Engineer Associate practice exams