70-779

You open an Excel worksheet as shown in the following exhibit. You need to export the data into a dataset in the Microsoft Power BI service. What should you do first?A . Save the tile as an Excel template.B . Select the data, and then insert a table.C . Select...

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

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

DRAG DROP You have a model that contains the following table named Sales. You have measure named TotalSales that calculates the sum of Line Total. You plan to create a PivotChart to display TotalSale for each category and the percent of total sales for each category as shown in the...

You need to create a PivotChart that has a filter as shown in the following exhibit. A . From the model, create a measure.B . From Query Editor, create a function.C . From Query Editor, create a parameter.D . From the model, create a hierarchy.View AnswerAnswer: D

DRAG DROP You merge several CVS files by using Query Editor. You need to remove all the leading whitespaces and all the non-printable characters from a column. What should you do to achieve each task? To answer, drag the appropriate actions to the correct goals. Each action may be used...

You have a table in Power Pivot model that is loaded from a Microsoft SQL Server database. The source table has four columns named ID, Price, Quantity, and Total. Total is derived by multiplying Price and Quantity. ID is a unique row identifier. You need to minimize the amount of...

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

You have a query that retrieves customers and their locations. You have sample of the data as shown in the following table. Additional customers and locations are added frequently. You need to transform the data as shown in the following table. What should you do?A . Select the Locations columns...