Question 51

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.
What should you recommend?
  • Question 52

    You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

    Sales contains only the data shown in the following table.

    For each of the following statements, select Yes if the statement is true. Otherwise, select No.
    NOTE: Each correct selection is worth one point.

    Question 53

    You import a Power Bl dataset that contains the following tables:
    * Date
    * Product
    * Product Inventory
    The 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 the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?
  • Question 54

    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 Bl. 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 write a DAX expression that uses the FILTER function.
    Does this meet the goal?
  • Question 55

    What is the minimum number of datasets and storage modes required to support the reports?