70-779 Exam Questions

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

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

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

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

You have two queries named Client and Invoices. A sample of Client is shown in the following table. A sample of Invoices is shown in the following table. You need to create a new t...

You have a workbook query that loads the following table: You pivot the table on the Key column by using Value as the values column, and you receive the results shown in the follow...

You have 20 workbook queries that load 20 CSV files to a local computer. You plan to send the workbook and the 20 CSV files to several users. The users will store the files in vari...

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

You have a table named Sales that has three columns named OrderDate, OrderNumber, and SalesAmount. You need to create the PivotTable as shown in the following table. What should yo...

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

You have a table named Sales that has three columns named Region, Country, and SalesAmount. You create a PivotTable as shown in the following exhibit. You need to ensure that the P...

You have a pie chart. You need the wedges of the pie chart to be separated as shown in the following exhibit.

You need to create a PivotChart that has a filter as shown in the following exhibit. What should you do first?

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

You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1. You need to modify Goal to multiply the sales from the previous year by...

You add two tables named Date and Invoices to a data model, Invoices contains a column named InvoiceDate that has a Data Type of Date, Date contains a column named DateID that has...

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

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

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 have an Excel workbook that contains two tables named User and Activity. You plan to publish the workbook to the Power BI service. Users will use Q&A in the Power BI service to...

You open C:\Data\Data,xlsx m Excel. When you attempt to publish the file to Microsoft Power BI, you receive the following error message: "We couldn't publish to Power BI. Make sure...

You have an Excel spreadsheet that contains a PivotChart. You install Microsoft Power BI Publisher for Excel. You need to add a tile for the PivotChart to a Power BI dashboard. Wha...

You need to configure a PivotChart as shown in the following exhibit. Witch chart element should you enable?

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

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 a table in a Microsoft SQL Server database that has more than 50 columns. A sample of the data and some of the columns are shown in the following table. The table contains...

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 the data model shown in the exhibit. You need to create a hierarchy from DimProductSubcategory[ProduaSubcategoryName]andDimProduct[ProductName]. What should you do before...

You have a measure that is used by a KPI. You need to display the output of the measure in a cell in your workbook. Which Excel function should you use?

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

You have a measure named SalesGrowth that calculates the percent of sales growth. The measure uses the following formula. ([Total Sales Current Year] - [Total Sales Last Year]) / [...

You have a table that contains sales data. You need to create a PivotTable that will display the sales by country as shown in the following exhibit. What should you use to display...

You create a PivotTable and a Pivot Chart as shown in the following exhibit. You need to decrease the number of columns in the PivotChart to six. What should you do?

You have a query that retrieves customers and their locations. You have a sample of the data as shown in the following table. Additional customers and locations are added frequentl...

You have a PivotChart template named Template1. You add a PivotChart to a worksheet. You need to apply the template to the PivotChart. What should you do?