Explain how you would tune a query by using cache in an Azure Databricks environment. Describe the caching mechanisms available in Databricks and how they can be leveraged to improve query performance. Provide a scenario where caching would be particularly beneficial.