- All Exams Instant Download
How should you create the visualization?
HOTSPOT You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario: The sales managers require a visual...
You publish the semantic model to powerbi.com
HOTSPOT You publish the semantic model to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer:
You need to get data from the Microsoft SQL Server tables.
You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'A . import that uses a Microsoft accountB . DirectQuery that uses the end-user s credentialsC . DirectQuery that uses a database credentialD . Import that uses a database credentialView AnswerAnswer: B
You publish the dataset to powerbi.com
HOTSPOT You publish the dataset to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer:
What should you create to meet the reporting requirements of the sales department?
What should you create to meet the reporting requirements of the sales department?A . a measure that uses a formula of SUM (Sales [sales_id])B . a calculated column that use a formula of COUNTA (sales [sales_id])C . a measure that uses a formula of COUNTROWS (Sales)D . a calculated column...
What should you do before you can create the relationship?
You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?A . Change the data type of Sales[region_id] to Whole Number.B . In the Sales table, add a measure for sum(sales_amount).C . Change the data type of sales[sales_id] to Text.D...
Which DAX expression should you use?
You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?A . FORMAT('Date'[date], "MMM YYYY")B . FORMAT('Date' [date], "M YY")C . FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")D . FORMAT('Date' [date_id], "MMM YYYY")View AnswerAnswer: A
What should you do in Power Query Editor?
Topic 1, Litware, Inc. Case Study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to...
What should you include in the solution?
You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?A . Create a security role that has a table filter on the Sales_Manager table where username = UserName()B . Create a security role that has a table filter...
What should you do?
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?A . In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to...