<< Prev Question Next Question >>

Question 26/75

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