Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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)
A
Develop a single view that performs a join operation on all three tables, selecting only the columns necessary for the analytics, to minimize complexity and enhance query performance.
B
Create individual views for each table and then design a final view that joins these individual views, allowing for modular data access but potentially increasing complexity.
C
Construct a view that joins the product sales and customer demographics tables first, then create another view that joins this intermediate view with the store locations table, aiming for a step-by-step data integration.
D
Design a view that initially joins the product sales and store locations tables, followed by another view that joins this intermediate result with the customer demographics table, focusing on geographical data integration first.