SEARCH
You are in browse mode. You must login to use MEMORY

   Log in to start


From course:

POWER BI [PI-300]

» Start this Course
(Practice similar questions for free)
Question:

You have a Power BI data source that contains the following tables: ProductCategory: Lists the product category ID and category name ProductSubcategory: Lists the product subcategory ID, subcategory name, and the related category ID ProductList: Lists the product ID, name, and subcategory ID You need to optimize the data to create a dimension for use in a star schema data model. How should the tables be transformed before loading into the model?Select only one answer. Import all three tables into the data model and connect them using relationships. Merge the queries to create a single loaded table for Product. Import only the ProductName table into the model. Use the append command to create a single loaded table for product.

Author: da-bi



Answer:

Merge the queries to create a single loaded table for Product. This answer is correct.


0 / 5  (0 ratings)

1 answer(s) in total

Author

da-bi
da-bi