1. The ultimate goal for optimizing transformations is to reduce the movement of data within your data warehouse.
  2. A CTE is a named select statement that can be reused in a single query.
  3. The two tier architecture in data warehousing is - Compute & Storage.