Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer working on a lakehouse project, you are tasked with creating a view that integrates data from three tables: product sales, customer demographics, and store locations. The solution must optimize for performance and simplicity while ensuring data integrity. The product sales table contains transactional data, the customer demographics table includes customer details, and the store locations table lists all store addresses. Given the requirement to frequently query this combined data for analytics, which approach should you take? (Choose one correct answer)