70-779 Exam Questions

You install Microsoft Power BI Publisher for Excel. You need to use Excel to connect and analyze Power BI data. To which two types of Power BI data can you connect? Each correct an...

You have the following table. You need to create a PivotTable as shown in the following exhibit. What should you do?

You have an Excel workbook that displays two PivotCharts. One chart displays sales by month. The other chart displays sales by year. You add a slicer for month. You discover that w...

You have the PivotTable shown in the following exhibit. You need to display only rows in the PivotTable in which the sum of LineTotal is greater than 100. What should you do?

Your company has a data analyst who uses Microsoft Power BI Desktop to create a data model and several reports. The data analyst publishes the reports to the Power BI service. You...

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

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

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

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

You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server database and loads data to the data model. You create a Pi...

You have a workbook query that loads data from a table named Products. Products contains a column named IntemalPrice that has a Data Type of Decimal. From Query Editor you create a...

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

From a workbook query, you import a table that has the following data. You need to configure the table to appear as shown in the following table.

You have the Excel worksheet shown in the exhibit. (Click the Exhibit button.) You need to transform the data by using Query Editor. What should you do first?

You have a workbook query that loads data from C:\Data\Users.xlsx. You move Users.xlsx to a shared folder on the network. You need to ensure that you can refresh the data from User...

You have a workbook query that loads data from a table in a Microsoft Azure SQL database. The table has a column named LineTotal. The following is a sample of the data in LineTotal...

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

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

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

You are building a KPI. You need to configure the KPI to display a red icon when the sales from a month is less than nine percent of the sales from the last 12 months. What should...

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

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

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

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

You have the following data sample. You need to create a PivotTable that presents the data as shown in the following table. What should you do?

You import the data from two next files into a PowerPivot model to create two tables named Customers and Invoices. Each table contains a column named CustomerID. When you attempt t...

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 have a data model that has the following tables. You create a PivotTable. The data displayed in the PivotTable is shown in the following table. You need to ensure that the corr...

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

You have an Excel workbook that contains a table named Sales. You add Sales to the Power Pivot model. You need to set a column named TransactionID as the row identifier for the Sal...

You have a Power Pivot data model that contains a table named DimProduct. DimProduct has seven columns named ProductKey, ProductLabel, ProductName, ProductDescription, ProductSubCa...

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

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

You have the data model shown in the Data Model exhibit. (Click the Exhibit button.) Data Model exhibit: You have the PivotChart shown in the Pivot Chart exhibit. (Click the Exhibi...