In a Databricks environment, you are working with a large dataset that includes a 'transaction_date' column formatted as 'yyyy-MM-dd'. Your task is to analyze transactions by year, month, and day. To achieve this, you need to cast the 'transaction_date' column to a timestamp and then extract the year, month, and day from the resulting timestamp. Considering the need for accuracy and performance in processing large datasets, which of the following Spark SQL queries correctly accomplishes this task? Choose the best option from the four provided. | Databricks Certified Data Engineer - Associate Quiz