In a Databricks SQL context, consider a dataset with columns ' Department ', ' Employee ', and ' Sales '. You are required to analyze the data using the ROLLUP and CUBE functions. Given this scenario, select the correct statements regarding the type of aggregations ROLLUP and CUBE would generate when applied to the ' Department ' and ' Employee ' columns.