NOTE: Each correct selection is worth one point. page 7 / 19
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
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
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
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
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
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
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