Valid 70-779
Dumps shared by Lead1pass for Helping Passing 70-779 Exam! Lead1pass now offer the newest 70-779 exam dumps, the Lead1pass 70-779 exam questions have been updated and answers have been corrected get the newest Lead1pass 70-779 dumps with Test Engine here:
http://https://www.lead1pass.com/Microsoft/70-779-practice-exam-dumps.html (102 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 5

HOTSPOT
You have two visualization as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
Note: Each correct answer is worth one point.

Answer:

Explanation: The Registration Chart shows Combo Chart.
The Average Score Pivot Chart shows Stock chart.

NEW QUESTION NO: 6
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.

A. From the Extract menu, click Last Characters.
B. From the Split Column menu, click By Delimiter.
C. From the Format menu, click Clean.
D. From the Format menu, click Trim.
Answer: B

NEW QUESTION NO: 7
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.
What should you do?
A. From powerbi.com, click Get apps.
B. From the Power BI tab in Excel, click Pin.
C. From the File menu in Excel, click Publish.
D. From powerbi.com, upload the excel workbook.
Answer: B

NEW QUESTION NO: 8
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:
* 40
* 1
* 999
* 7658
* 883432
You need to ensure that when you load the data to the model, LineTotal is set as currency.
What should you do from Query Editor?
A. Split the column by delimiter.
B. Round the column.
C. Split the column by characters.
D. Configure the Data Type
Answer: D

NEW QUESTION NO: 9
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

NEW QUESTION NO: 10
HOTSPOT
Note: This question is part of a series of questions that use the same scenario, For your convenience 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.
Start of repeated scenario
You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit.
Your company has 100 product subcategories and more than 10,000 products.
End of repeated scenario.
You need to create a measure named [Sales Monthly RT] that calculates a running total of
[Sales] for each date within a month as shown in the following exhibit.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:
SUM [Sales], DATESMTD
The following sample formula creates a measure that calculates the 'Month To Date Total' for the Internet sales.
To see how this works, create a PivotTable and add the fields, CalendarYear, MonthNumberOfYear and DayNumberOfMonth, to the Row Labels area of the PivotTable.
Then add a measure, named Month To Date Total, using the formula defined in the code section, to the Values area of the PivotTable.
= CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]),
DATESMTD(DateTime[DateKey]))
https://msdn.microsoft.com/en-us/query-bi/dax/datesmtd-function-dax

NEW QUESTION NO: 11
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 answer a question in this section, you will NOT be able to return to it. As a result these questions will not appear in the review screen.
You have two Microsoft SQL Server database servers named Production1 and Test1.
Production1 contains the same tables as Test1, but only a subset of the data.
You add Test1 as a data source, and you select 10 tables. You configure several transformations.
You need to connect the model to the tables in Production1. The solution must maintain the existing transformations.
Solution: From Query Editor, you edit the source of each table query.
Does this meet the goal?
A. Yes
B. No
Answer: A

NEW QUESTION NO: 12
Your network contains a folder that has data files m various formats.
You need to identify how many files of each extension type are in the folder by using Query Editor.
What should you do?
A. Create a query that uses a folder source, and then use the Group By command on the Home tab.
B. Create a query that uses a folder source, and then use the Count Values command on the Transform tab.
C. Create a query that uses a file source, and then use the Group By command on the Home tab.
D. Create a query that uses a file source, and then use the Count Values command on the Transform tab.
Answer: A

NEW QUESTION NO: 13
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 1.15.
What should you do?
A. From Power Pivot, modify the measure.
B. From Power Pivot, create a new calculated column, and then modify the KPI.
C. From the properties of the KPI, modify the absolute value.
D. From the properties of the KPI, modify the KPI base field.
Answer: A

NEW QUESTION NO: 14
You have the following table.

You need to create a PivotTable as shown in the following exhibit.

What should you do?
A. Add Product to the Rows area. Add LineTotal to the Values area twice.
B. Add LineTotal to the Rows area. Add Product to the Values area twice.
C. Add Product to the Rows area. Add LineTotal to the Columns area twice.
D. Add LineTotal to the Rows area. Add Product to the Values area twice.
Answer: C

NEW QUESTION NO: 15
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
https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016- for-windows-1524175f-777a-48fc-8fc7-c8514b984440