Question 186

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 187

You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.

You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
  • Question 188

    You have a Microsoft Excel file in a Microsoft OneDrive folder.
    The file must be imported to a Power Bi dataset
    You need to ensure that the dataset can be refreshed in powefbi.com.
    Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
    NOTE: Each correct selection is worth one point.
  • Question 189

    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 190

    How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.