jump to navigation

Latest 70-779 Practice Exam Dumps

70-779 Exam is for BI professionals, data analysts who work with Microsoft Excel, Power BI in their daily jobs. The Analyzing and Visualizing Data with Microsoft Excel Exam measures the candidate’s skills to Consume and Transform Data by Using Microsoft Excel, Model Data, Visualize Data.

The ideal candidates for this exam are those who understand how to use Microsoft Excel to perform data analysis. They should also be able to configure and manipulate data in PowerPivot, PivotTables, and PivotCharts. One of the best ways to learn these skills is to get help from the 70-779 Exam Dumps. These questions answers possess a real-like resemblance to the actual exam questions. Here are some 70-779 Sample Questions:

Question # 1:

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.
You need to combine all the data from Consultants and Employees into one table. Which command should you use?
A. Transpose
B. Append Queries
C. Merge Queries
D. Combine Binaries
Answer: B
Explanation:

Append is similar to UNION ALL in T-SQL.
http://radacad.com/append-vs-merge-in-power-bi-and-power-query

Question # 2:

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 File tab, click Options, and then modify the General options.
C. From the Data tab, click Queries & Connections, and then edit the properties of the query.
D. From the Power Pivot model, modify the Table Behavior setting.
Answer: C
Explanation:

https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016
forwiHYPERLINK
“https://support.office.com/en-us/article/refresh-an-external-data-connection-inexcel2016-for-windows-1524175f-777a-48fc-8fc7-c8514b984440″ndows-1524175f-777a-48fc-8fc7-c8514b984440

Question # 3:

DRAG DROP
You use a workbook query to import a table named Customers that contains a column named CustomerName. CustomerName has names in the format of Lastname, Firstname. You need the CustomerName column to contain names in the format of Firstname Lastname. A Space must separate Firstname and Lastname.
Which two commands should you use? To answer, drag the appropriate fields to the correct areas. Each field may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point

Answer:
Explanation:
https://support.office.com/en-us/article/split-a-column-of-text-power-query-5282d425-
6ddHYPERLINK “https://support.office.com/en-us/article/split-a-column-of-text-power-query5282d425-6dd0-46ca-95bf-8e0da9539662″0-46ca-95bf-8e0da9539662
https://support.office.com/en-us/article/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d

Question # 4:

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 new data. What should you do?
A. Select a cell in the worksheet and pressF5.
B. From the data tab, click Refresh All.
C. Close and open the workbook.
D. From the Power Pivot tab, click Update All.
Answer: B

Explanation:
Refresh data from a Microsoft Query, the Data Connection Wizard, or web query. Click any cell in the range or table that contains the link to the external data. On the Data tab, in the Connections group, click Refresh All.

To update only the selected data, click Refresh.
You can also right-click a cell in the range or table, and then click Refresh. To update all the data connections in the workbook, click Refresh All.
Note: If you have more than one workbook open, you’ll need to repeat the operation in each
workbook.
https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016-
forwindows1524175f-777a-48fc-8fc7-c8514b984440?ui=en-USHYPERLINK
“https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016-
forwindows1524175f-777a-48fc-8fc7-c8514b984440?ui=en-US&rs=en-CA&ad=CA”&HYPERLINK
“https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016-
forwindows1524175f-777a-48fc-8fc7-c8514b984440?ui=en-US&rs=en-CA&ad=CA”rs=en-CAHYPERLINK
“https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016-
forwindows1524175f-777a-48fc-8fc7-c8514b984440?ui=en-US&rs=en-CA&ad=CA”&HYPERLINK
“https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016-for
windows-1524175f-777a-48fc-8fc7-c8514b984440?ui=en-US&rs=en-CA&ad=CA”ad=CA

Question # 5:

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 Data tab, Click Consolidate.
Answer: A
Explanation:
Excel uses a dedicated Query Editor to facilitate and display data transformations. When you select
Data > Get Data, then select the data source, such as a workbook, or a database, the Navigator
window appears so you can select which table (or tables) you want to use in your query. When you
select a table, a preview of its data is shown in the right pane of the Navigator window.
https://support.office.com/en-us/article/getting-started-with-get-transform-in-excel-2016-
a8HYPERLINK “https://support.office.com/en-us/article/getting-started-with-get-transform-in-excel2016-a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=en-US&ad=US”310388-2a12-438c9d29-c6d29cb8df6a?ui=en-USHYPERLINK “https://support.office.com/en-us/article/getting-startedwithget-transform-in-excel-2016-a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=enUS&ad=US”&HYPERLINK “https://support.office.com/en-us/article/getting-started-with-gettransformin-excel-2016-a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=en
US&ad=US”rs=en-USHYPERLINK “https://support.office.com/en-us/article/getting-started-withgettransformin-excel-2016-a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=enUS&ad=US”&HYPERLINK “https://support.office.com/en-us/article/getting-started-with-gettransformin-excel-2016-a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=enUS&ad=US”ad=US

Comments»

no comments yet - be the first?