70-779

HOTSPOT You have a workbook query that uses an Excel data source. The data source contains the following table. You need the data to appear as shown in the following table. How should you transform the data from Query Editor? To answer, select the appropriate options in the answer area....

You have an Excel workbook that has the following two workbook queries: A query named consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database A query named employees that retrieves a table named Employee_Contact from a Microsoft Azure SQL database Both tables have the same columns....

HOTSPOT You have a workbook query that uses an Excel data source. The data source contains the following table. You need the data to appear as shown in the following table. How should you transform the data from Query Editor? To answer, select the appropriate options in the answer area....

You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model. You discover that new rows were added to the tables in Azure SQL Database. You need to ensure that the workbook has the new data. Why should you do?A...

Your company has sales offices in several cities. You create a table that represents the amount of sales in each city by month as shown in the exhibit. You need to ensure that all values lower than 250 display a red icon. The solution must ensure that all values greater...

HOTSPOT 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 the Excel worksheet shown in the exhibit. You need to transform the data by using Query Editor. What should you do first?A . From the Data tab, Click From Table/Range.B . From the Insert tab, Click Store.C . From the Data tab, Click Flash Fill.D . From the...

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...

You have an Excel workbook query that loads data to a worksheet and the data model. You need to ensure that the data is refreshed whenever you open the workbook. What should you do?A . From the File tab, click Option, and then modify the Data option.B . From the...

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...