LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Microsoft Fabric Analytics Engineer Associate DP-600

Microsoft Fabric Analytics Engineer Associate DP-600

Get started today

Ultimate access to all questions.


You are presented with a source data model as shown in the exhibit. The primary keys in the tables are marked by a key symbol next to the respective columns. Your task is to create a dimensional data model that allows analysis of order items by date, product, and customer. What should you include in your solution? Select the appropriate options from the provided choices in the answer area.

A) Dependent on ProductID only B) Denormalize Company into Product table C) A new surrogate key which combines Product and Company D) Denormalize Company into Customer table

Exam-Like



Powered ByGPT-5