You are troubleshooting a failed Spark job in Azure Databricks. Describe the steps you would take to diagnose the issue and resolve it. Include details on the tools and logs you would consult, and the potential areas of investigation for common Spark job failures.