HOTSPOT (Drag and Drop is not supported) You are creating a Microsoft Power BI data model that has the tables shown in the following table.The Products table is related to the ProductCategory table through the ProductCategoryID column. Each product has one product category.You need to ensure that you can analyze sales by product category.How should you configure the relationship from ProductCategory to Products? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
Answer(s): A
Box 1: One-to-many The one-to-many and many-to-one cardinality options are essentially the same, and they're also the most common cardinality types.Incorrect: A many-to-many relationship means both columns can contain duplicate values. This cardinality type is infrequently used. It's typically useful when designing complex model requirements. You can use it to relate many-to-many facts or to relate higher grain facts. For example, when sales target facts are stored at product category level and the product dimension table is stored at product level.Box 2: Single Incorrect:Bear in mind that bi-directional relationships can impact negatively on performance. Further, attempting to configure a bi-directional relationship could result in ambiguous filter propagation paths. In this case, Power BI Desktop may fail to commit the relationship change and will alert you with an error message.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
You import a Power BI dataset that contains the following tables:-Date-Product-Product InventoryThe Product Inventory table contains 25 million rows. A sample of the data is shown in the following table.The Product Inventory table relates to the Date table by using the DateKey column. The Product Inventory table relates to the Product table by using theProductKey column.You need to reduce the size of the data model without losing information.What should you do?
Answer(s): D
HOTSPOT (Drag and Drop is not supported) You are enhancing a Power BI model that has DAX calculations.You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.Which DAX functions should you use? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
Box 1: CALCULATE Example:Total sales on the last selected date =CALCULATE (SUM ( Sales[Sales Amount] ),'Sales'[OrderDateKey] = MAX ( 'Sales'[OrderDateKey] ))Box 2: SUM Box 3: SAMEPERIODLASTYEAR SAMEPERIODLASTYEAR returns a set of dates in the current selection from the previous year.Example:-- SAMEPERIODLASTYEAR returns the selected period shifted back one year.EVALUATE VAR StartDate = DATE ( 2008, 07, 25 )VAR EndDate = DATE ( 2008, 07, 31 )RETURN CALCULATETABLE (SAMEPERIODLASTYEAR ( 'Date'[Date] ),'Date'[Date] >= StartDate &&'Date'[Date] <= EndDate)ORDER BY [Date]
https://docs.microsoft.com/en-us/dax/calculate-function-daxhttps://dax.guide/sameperiodlastyear/
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.During the development process, you need to import a sample of the data from the Order table.Solution: You add a report-level filter that filters based on the order date.Does this meet the goal?
Answer(s): B
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:-Due Date-Order Date-Delivery DateYou need to support the analysis of sales over time based on all the date foreign keys.Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.Does this meet the goal?
Post your Comments and Discuss Microsoft PL-300 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the PL-300 content, but please register or login to continue.