What should you configure?
HOTSPOT You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields: ✑ Customer ID ✑ Customer City ✑ Customer State ✑ Customer Name ✑ Customer Address 1 ✑ Customer Address 2 ✑ Customer Postal Code The Invoice table contains the...
You have a report page that contains the visuals shown in the following exhibit
HOTSPOT You have a report page that contains the visuals shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: cross-filter...
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 account B. DirectQuery that uses the end-user s credentials C. DirectQuery that uses a database credential D. Import that uses a database credentialView AnswerAnswer: B
Which type of visualization should you use?
You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months. Which type of visualization should you use?A . scatter chart B. ribbon chart...
You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?
Topic 3, Northwind Traders 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...
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
Does this meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...
Which three actions should you perform in sequence?
DRAG DROP You create a data model in Power BI. Report developers and users provide feedback that the data model is too complex. The model contains the following tables. The model has the following relationships: * There is a one-to-one relationship between Sales_Region and Region_Manager. * There are more records...
Which type of visualization should you use?
You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?A . Key influences B. Funnel chart C. Q&A D. Line and clustered...
You have a report page that contains the visuals shown in the following exhibit
HOTSPOT You have a report page that contains the visuals shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: cross-filter...