NOTE Each correct selection is worth one point page 7 19

Note each correct selection is worth one point page 7

This preview shows page 7 - 14 out of 19 pages.

NOTE: Each correct selection is worth one point. page 7 / 19
Image of page 7
Answer: 11.You have a app workspace named Retail Store Analysis in thePower BI service. You need manage the members that have access tothe app workspace. What should you do? A.From the Power BI Admin portal, click Usage metricsB.From the Office 365 Admin center, click UsersC.From the Office 365 Admin center, click GroupsD.From the Power BI Admin portal, click Tenant settingsAnswer: D12.HOTSPOT You have the following table. page 8 / 19
Image of page 8
You need to create a new table that displays the top 10 customers bythe total of Sales Amount.How should you complete the DAX formula? To answer, select theappropriate options in the answer area. NOTE: Each correct selection is worth one point. page 9 / 19
Image of page 9
Answer: 13.Note: This question it part of a series of questions that use the same scenario. For your convenience, the scenario is repeated In each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series. You have a Microsoft SQL Server database that contains the following tables. page 10 / 19
Image of page 10
The Oder table contains more than one million rows. The Store table has a relationship to the Monthy_returns table on the page 11 / 19
Image of page 11
StoreID column. This is the only relationship between the tables.You plan to use Power BI Desktop to create an analytics solution forthe data.You plan to create a chart that displays total Order [Order_amount] byStore [Name].You need to modify the model to ensure that you can create the chart.Which two actions should you perform? Each correct answer presentspart of the solution.NOTE: Each correct selection is worth one point.A. To the Order table, add a column that user theRELATED(¡®Store¡¯[Store_ID]) DAX formula.B. Create a relationship between the Order table and the Store table.C. To the Order table, add a measure that uses theCOUNT(¡®Order¡¯[Order_amount]) DAX formula.D. To the Order table, add a measure that uses theSUM(¡®Order¡¯[Order_amount] ) DAX formula. 14.You are create a report in Power BI Desktop.You are consuming the following tables. page 12 / 19
Image of page 12
Date [Date] is in the mm/dd/yyy format. Date[DateKey] is in the ddmmyyy format. Date[MonthNumber] is in the mm formate[MonthName] is in the mmm format. You create the report shown in the exhibit. (Click the Exhibit button.) You need to ensure that the months appear in the order of the calendar. How should you sort the MonthName column? A. by MonthNumber B. descending C. ascending D. by DateKey
Image of page 13
Image of page 14

You've reached the end of your free preview.

Want to read all 19 pages?

  • Spring '18
  • E. J Janet Smith
  • Microsoft SQL Server, power bi, app workspace

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture