Free Microsoft 070-778 Exam Dumps Questions & Answers
| Exam Code/Number: | 070-778Join the discussion |
| Exam Name: | Analyzing and Visualizing Data with Power BI |
| Certification: | Microsoft |
| Free Question Number: | 155 |
| Publish Date: | Nov 14, 2026 |
| # of views: | 4158 |
|
|
|
You have the following tables.
You need to create a measure to calculate a running total of TransactionQuantity.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a Microsoft SharePoint Online site named Sales.
Your company has 1,000 sales users. All the sales users can access Sales.
You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part.
You need to ensure that all the sales can view the report from the Sales site.
What should you do?
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.
Start of repeated scenario
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 StoreJD column. This is the only relationship between the tables.
You plan to use Power Bl Desktop to create an analytics solution for the data.
End of repeated scenario.
You are modeling the data in Power Bl.
You need to import only a sample of the data from the Order table.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE:
Each correct selection is worth one point.
You open the Power BI Admin portal as shown in the following graphic.
All the app workspaces use the customer's capacity.
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.
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.
Start of repeated scenario
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 StoreJD column. This is the only relationship between the tables.
You plan to use Power B! Desktop to create an analytics solution for the data.
End of repeated scenario.
You need to create a chart that displays a sum of Order[Order_amount] by month for the Order_ship_date column and the Order_date column.
How should you model the data?



