70-778

70-778 practice questions, page 6 of 6, with answer review and explanations.

Question 26

You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables: ✑ Product (Product_id, Product_Name) ✑ Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) ✑ Salesperson (Salesperson_id, Salesperson_name, address) The model has the following relationships: ✑ Sales to Product ✑ Sales to Salesperson You create a new Power BI file and import the Power Pivot model. You need to ensure that you can generate a report that displays the count of products sold by each salesperson. What should you do before you create the report?

  1. Create a one-to-one relationship between Product and Salesperson.
  2. For each relationship, change the Cross filter direction to Both.
  3. For each relationship, change the Cardinality to One to one (1:1).
  4. Change a many-to-one relationship between Product and Salesperson.

Question 27

You have a Power BI model that contains the following two tables: ✑ Sales (Sales_ID, DateID, sales_amount) ✑ Date(DateID, Date, Month, Week, Year) The tables have a relationship. You need to create a measure to calculate the sales for same period from the previous year. Which DAX formula should you use?

  1. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), DATESYID('Date'[Date]))
  2. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[Date]))
  3. SUM(sales[sales_amount]) "" CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[Date]))
  4. CALCULATEx(SUM(sales(sales_amount]), DATESYID('Date'[Date]))

Question 28

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns: ✑ CustomerID ✑ CustomerName ✑ Address ✑ City ✑ ProvState ✑ Country You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

  1. In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
  2. In the Value field, add Country at the top, followed by ProvState, and then City.
  3. In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
  4. In the Axis field, add Country at the top, followed by ProvState, and then City.

Question 29

You have a table named Sales that contains sales data for the United States. A sample of the data in Sales is shown in the following table. When you attempt to create a map that shows SalesAmount by Zone, you discover that the map shows a bubble based on cities instead of states. You need to ensure that the map shows bubbles based on states. What should you do?

  1. Add a column named Country that contains United States as the value.
  2. Add a column for longitude and a column for latitude.
  3. Select the Zone field. From the Modeling tab, change the Data Category.
  4. Select the Zone field. From the Modeling tab, change the Data Type.