Microsoft Analyzing and Visualizing Data with Microsoft Excel - 070-779 Exam Practice Test
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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a query named Query1 that retrieves the user information from two Excel files. One of the Excel files does not contain location information. A sample of the data retrieved by the query is shown in the following table.
You need to ensure that values in UserName are unique. The solution must ensure that the locations are retained. A sample of desired output is shown in the following table.
Solution: You use the Group By function to group the rows by UserName and you specify output columns for UserID and Location by using the Max operation.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a query named Query1 that retrieves the user information from two Excel files. One of the Excel files does not contain location information. A sample of the data retrieved by the query is shown in the following table.
You need to ensure that values in UserName are unique. The solution must ensure that the locations are retained. A sample of desired output is shown in the following table.
Solution: You use the Group By function to group the rows by UserName and you specify output columns for UserID and Location by using the Max operation.
Does this meet the goal?
Correct Answer: A
Vote an answer
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 six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheet. The data model is shown in the Data Model exhibit. (Click the Exhibit button.) Your company has 100 product subcategories and more than 10,000 products.
End of repeated scenario.
You need to create a measure named [Sales Monthly RT] that calculates a running total of [Sales] for each date within a month as shown in the following exhibit.
Start of repeated scenario
You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheet. The data model is shown in the Data Model exhibit. (Click the Exhibit button.) Your company has 100 product subcategories and more than 10,000 products.
End of repeated scenario.
You need to create a measure named [Sales Monthly RT] that calculates a running total of [Sales] for each date within a month as shown in the following exhibit.
Correct Answer:
Explanation
SUM([Sales],DATESMTD(DimDate[Date]))
CALCULATE(SUM([Sales],DATESMTD(DimDate[Date])))
You have a query that retrieves the following data.
You need to configure the query to ensure that the data appears as shown in the following table.
What should you do?
You need to configure the query to ensure that the data appears as shown in the following table.
What should you do?
Correct Answer: D
Vote an answer
You have the following table.
You plan to use [Month Name] as the axis in a PivotChart.
You need to ensure that whenever [Month Name] is used in a chart, the months are displayed chronologically be default.
What should you do?
You plan to use [Month Name] as the axis in a PivotChart.
You need to ensure that whenever [Month Name] is used in a chart, the months are displayed chronologically be default.
What should you do?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You have the following tables in a data model.
You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table.
You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table.
Correct Answer: D
Vote an answer
You have the following tables in a data model.
You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table.
You need to ensure that the data appears in chronological order.
What should you do?
You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table.
You need to ensure that the data appears in chronological order.
What should you do?
Correct Answer: B
Vote an answer
You have a data model in Excel.
You export the data and the data model into a dataset in the Microsoft Power BI service.
What can you use to modify the data model that is published to the Power BI service?
You export the data and the data model into a dataset in the Microsoft Power BI service.
What can you use to modify the data model that is published to the Power BI service?
Correct Answer: D
Vote an answer