<< Prev Question Next Question >>

Question 60/77

Note: This question is 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.

The following columns contain date 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 a 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.
You are modifying the model to report on the number of orders.
You need to calculate the number of orders.
What should you do?

LEAVE A REPLY

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

Question List (77q)
Question 1: You create a dashboard that displays the results of a custom...
Question 2: You have a Power BI model that has a date table. A sample of...
Question 3: Your organization has a Microsoft Office 365 subscription. W...
Question 4: You are creating a report in Power BI Desktop. You are consu...
Question 5: Note: This question is part of a series of questions that us...
Question 6: Note: This question is part of a series of questions that pr...
Question 7: Note: This question is part of a series of questions that pr...
Question 8: You have a Power BI model for sales data. You create a measu...
Question 9: You have a Power BI Desktop project that has the model shown...
Question 10: In the Power BI service, you create an app workspace that co...
Question 11: You have a Microsoft Excel spreadsheet that contains a table...
Question 12: Your company has several developers who plan to create custo...
Question 13: Note: This question is part of a series of questions that pr...
Question 14: You have the following table named Location. (Exhibit) The G...
Question 15: Your company has a security policy stating that proprietary ...
Question 16: You have a service published to a website. When you connect ...
Question 17: You need to create a dashboard in the Power BI service to di...
Question 18: Note: This question is part of a series of questions that pr...
Question 19: You plan to create a dashboard in the Power BI service that ...
Question 20: You have a Microsoft SQL Server Analysis Services (SSAS) cub...
Question 21: You have a table named Sales that contains sales data for th...
Question 22: Note: This question is part of a series of questions that pr...
Question 23: Note: This question is part of a series of questions that pr...
Question 24: You manage a Power BI model that has two tables named Sales ...
Question 25: Note: This question is part of a series of questions that pr...
Question 26: You are creating a report in Power BI Desktop. You are consu...
Question 27: You plan to deploy a Power BI app workspace that will be vie...
Question 28: Note: This question is part of a series of questions that pr...
Question 29: Note: This question is part of a series of questions that pr...
Question 30: You have a sales report in an app workspace. The report disp...
Question 31: Note: This question is part of a series of questions that us...
Question 32: You have a Power Pivot model that includes a KPI. You need t...
Question 33: You are creating a report in Power BI Desktop that has two v...
Question 34: You plan to use Power BI Desktop to create a report. The rep...
Question 35: You have the following two queries in Power BI Desktop: A qu...
Question 36: Note: This question is part of a series of questions that pr...
Question 37: You have a Microsoft Excel 2016 workbook that has a Power Pi...
Question 38: You have a workspace that contains 10 dashboards. A dashboar...
Question 39: You use Power BI Desktop to create a visualization for a Mic...
Question 40: You have a Power BI app named App1. The privacy for the App1...
Question 41: Note: This question is part of a series of questions that us...
Question 42: You are importing sales data from a Microsoft Excel file nam...
Question 43: Note: This question is part of a series of questions that us...
Question 44: You have a Power BI model that contains the following two ta...
Question 45: You plan to embed multiple visualizations in a public websit...
Question 46: You have a Microsoft SharePoint Online site named Sales. You...
Question 47: Your organization has a Microsoft Office 365 subscription. W...
Question 48: Note: This question is part of a series of questions that us...
Question 49: You plan to use Power BI Desktop optimized for Power BI Repo...
1 commentQuestion 50: From the Home tab in Power BI Desktop, you click Enter Data ...
Question 51: Note: This question is part of a series of questions that us...
Question 52: From Power BI Desktop, you create a query that imports the f...
Question 53: You plan to create a dashboard in the Power BI service that ...
Question 54: You attempt to publish a Microsoft Excel file to Power BI, a...
Question 55: Note: This question is part of a series of questions that us...
Question 56: Note: This question is part of a series of questions that pr...
Question 57: You have a Power BI report that is configured to use row-lev...
Question 58: You have a table in Power BI Desktop as shown in the followi...
Question 59: You have a Power BI Desktop project that uses DirectQuery to...
Question 60: Note: This question is part of a series of questions that us...
Question 61: You have a Power BI report that displays a bar chart and a d...
Question 62: Note: This question is part of a series of questions that us...
Question 63: You plan to create several datasets by using the Power BI se...
Question 64: Note: This question is part of a series of questions that pr...
Question 65: Note: This question is part of a series of questions that pr...
Question 66: You have a query that retrieves sales data. A sample of the ...
Question 67: You create a report in the Power BI service. You plan to pro...
Question 68: You have two tables named Customer and Orders. A sample of t...
Question 69: You plan to join a fact table named ActivityLog to a Date di...
Question 70: Note: This question is part of a series of questions that us...
Question 71: Note: This question is part of a series of questions that pr...
Question 72: You embed a Power BI report in a Microsoft SharePoint Online...
Question 73: Note: This question is part of a series of questions that pr...
Question 74: Note: This question is part of a series of questions that us...
Question 75: You have a Power BI model for sales data. You create a measu...
Question 76: You plan to develop a Power BI report that has a bar chart t...
Question 77: You have the following tables. (Exhibit) There is a many-to-...