A data engineer must deliver a trustworthy customer 360 dataset in Databricks for data scientists and BI teams. The engineer plans to join deduplicated customer records with cleaned transaction data, enforce schema and data quality checks, and create a conformed
"customer_transactions"view. Later, highly aggregated, domain-specific tables (for weekly spend and executive summaries) will be produced for dashboards.
Where should the engineer build the conformed "customer_transactions" dataset, and where should the aggregated, report-ready tables reside?