<< Prev Question Next Question >>

Question 55/76

Note: This question is a part of a series of questions that present 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 exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain data information:
* Date[Month] in the mmyyyy format
* Date[Date_ID] in the ddmmyyyy format
* Date[Date_name] in the mm/dd/yyyy format
* Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI desktop to create an analytics solution for the data.
End of repeated scenario.
You plan to create a chart that displays total Order [Order_amount] by Store [Name].
You need to modify the model to ensure that you can create the chart.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (76q)
Question 1: You plan to use Power BI Desktop to create a report. The rep...
Question 2: You open powerbi.com as shown in the following exhibit. Use ...
Question 3: You use Power BI Desktop to create a visualization for a Mic...
Question 4: You have a Microsoft Excel spreadsheet that contains a table...
Question 5: Note: This question is part of a series of questions that us...
Question 6: You need to create a dashboard in the Power BI service to di...
Question 7: You plan to create a Power BI report. You have the schema mo...
Question 8: You have a Power BI model for sales data. You need to create...
Question 9: You have an on-premises Power BI Report Server. You plan to ...
Question 10: Note: This question is part of a series of questions that pr...
Question 11: Note: This question is a part of a series of questions that ...
Question 12: Note: This question is part of a series of questions that pr...
Question 13: You have a Power BI report that is configured to use row-lev...
Question 14: You plan to develop a Power BI report that has a bar chart t...
Question 15: You are creating reports in Power BI Desktop. The model has ...
Question 16: You have the following two tables: * Subscriber (Subscriberl...
Question 17: You have a Microsoft SQL Server Analysis Services (SSAS) cub...
Question 18: Note: This question is part of a series of questions that pr...
Question 19: Note: This question is a part of a series of questions that ...
Question 20: Note: This question is a part of a series of questions that ...
Question 21: Note: This question is part of a series of questions that us...
Question 22: You plan to use Power BI Desktop optimized for Power BI Repo...
Question 23: You are creating a report in Power BI Desktop that has two v...
Question 24: You have a Power BI report that displays a bar chart and a d...
Question 25: Note: This question is part of a series of questions that pr...
Question 26: You have a power BI model that contains the following tables...
Question 27: You have the following tables. (Exhibit) You need to create ...
Question 28: You have a Power BI Desktop project that uses DirectQuery to...
Question 29: You have a Microsoft Excel 2016 workbook that has a Power Pi...
Question 30: You have a Power BI model that contains the following tables...
Question 31: Note: This question is a part of a series of questions that ...
Question 32: You attempt to publish a Microsoft Excel file to Power BI, a...
Question 33: Your company plans to use Power BI for 20 users in the sales...
Question 34: Note: This question is a part of a series of questions that ...
Question 35: You have a table that contains a column named Phone. The fol...
Question 36: You have three Power BI Desktop projects named Reportl.pbix,...
Question 37: From the Home tab in Power BI Desktop, you click Enter Data ...
Question 38: You have a query that uses a Microsoft Excel data source. Th...
Question 39: Note: This question is part of a series of questions that us...
Question 40: You have a sales report in an app workspace. The report disp...
Question 41: You have a query that retrieves sales data. A sample of the ...
Question 42: You have a Power BI model that contains a table named Sales....
Question 43: You have a table named Sales. Sales contains the data shown ...
Question 44: Note: This question is a part of a series of questions that ...
Question 45: Note: This question is a part of a series of questions that ...
Question 46: You have a query named FactlnternetSales used by several Pow...
Question 47: Note: This question is a part of a series of questions that ...
Question 48: You embed a Power BI report in a Microsoft SharePoint Online...
Question 49: Note: This question is part of a series of questions that us...
Question 50: You are creating a work schedule for a retail store. You hav...
Question 51: You create a new app workspace. You add a user named Userl1 ...
Question 52: Note: This question is part of a series of questions that pr...
Question 53: You have a service published to a website. When you connect ...
Question 54: Note: This question is part of a series of questions that pr...
Question 55: Note: This question is a part of a series of questions that ...
Question 56: You have the following two queries in Power BI Desktop: * A ...
Question 57: You plan to deploy a Power BI app workspace that will be vie...
Question 58: You have a Microsoft Excel workbook that contains two tables...
Question 59: From Power BI Desktop, you publish an app that contains one ...
Question 60: You have the report shown in the following exhibit. (Exhibit...
Question 61: You open the Power BI Admin portal as shown in the following...
Question 62: You have a Power BI app named App1. The privacy for the App1...
Question 63: Note: This question is part of a series of questions that us...
Question 64: You create a report in Power BI Desktop. You need to embed t...
Question 65: Note: This question is part of a series of questions that pr...
Question 66: You have a Power BI report in an app workspace. You plan to ...
Question 67: You create a dashboard that displays the results of a custom...
Question 68: You create a report in the Power BI service that displays th...
Question 69: You have a column named phone_number. The values in the colu...
Question 70: Note: This question is part of a series of questions that pr...
Question 71: You create a KPI visualization in Power BI Desktop that uses...
Question 72: Note: This question is a part of a series of questions that ...
Question 73: You have the datasets shown in the following graphic. (Exhib...
Question 74: You are creating a report in Power BI Desktop. You are consu...
Question 75: Your company has a security policy stating that proprietary ...
Question 76: You have two tables named CustomerVisits and Date in a Power...