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

NEW QUESTION NO: 27
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: 28
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 You create a new connection to Production1, and then you import the tables.
Does this meet the goal?
A. yes
B. No
Answer: B

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

NEW QUESTION NO: 30
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 various location.
You need to ensure that the users can change the path to the CSV files in the queries as quickly as possible.
What should you do from Query Editor?
A. Merge all the queries. Edit the source of the first query.
B. Append all the queries. Edit the source of the first query.
C. Create a parameter. Modify the source of each query to use the parameter.
D. For each query, create a new query that uses a reference. Modify the source of each new query.
Answer: C

NEW QUESTION NO: 31
You have a table that contains data relating to exam candidates and their associated scores.
You need to visualize the exam data by separating the data into quartiles. The visualization must display the mean score and must identify any outliers.
Which type of chart should you use?
A. line
B. histogram
C. pie
D. box and whisker
Answer: D
Explanation: https://support.office.com/en-us/article/create-a-box-and-whisker-chart-
62f4219f-db4b-4754-aca8-4743f6190f0d

NEW QUESTION NO: 32
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 more than two million rows. You have 100 clients and 100 products.
You need to load the data to Excel. The solution must minimize the amount of memory used by the model.
What should you do?
A. Load the data to three worksheets named Clients, Orders, and Products. Ensure that each worksheet has only the relevant columns. Remove duplicate rows from Clients and Products.
B. Move the database to a Microsoft Azure SQL database. Load the table to the data model.
C. Load the data to one worksheet.
D. Load the data to the data model as three tables named Clients, Orders, and Products.
Ensure that each table has only the relevant columns. Remove duplicate rows from Clients and Products.
Answer: D

NEW QUESTION NO: 33
You have a Power Pivot data model that contains a table named DimProduct DimProduct has seven columns named ProductKey, ProductLabel, ProductName, ProductDescription, ProductSubCategoryKey, Manufacturer, and Brand.
Only the members of the product team use all the data in the DimProduct table.
You need to simplify the model for other users by hiding all the columns except ProductName.
What should you do?
A. Create a perspective that has only the ProductName field from DimProduct selected.
B. Select all the columns in DimProduct except ProductName, right-click the columns, and then click Hide from Client Tools.
C. Edit the Default Field Set for DimProduct and add ProductName to the Default Field.
D. Edit the Table Behavior settings for DimProduct and add ProductName to the Default Label.
Answer: B
Explanation: https://support.office.com/en-us/article/hide-columns-and-tables-in-power- pivot-ddf5b1f2-2ed2-4bdb-8f78-6f94503ca87a

NEW QUESTION NO: 34
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 PivotTable and PivotChart.
You plane to share SalesResults.slsx to several users outside of your organization.
You need to ensure that the users can see the PivotTable and the PivotChart when they open the file. The data in the model must be removed.
What should you do?
A. Save the workbook as an Excel Binary Workbook (xlsx)
B. Run the Document inspector.
C. Modify the source of the query.
D. From Query Editor, open the Data Source Setting and delete the credentials.
Answer: C

NEW QUESTION NO: 35
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. Install Power BI Publisher for Excel.
B. Select the data, and Then insert a PivotTable.
C. Select the data, and then insert a table.
D. Save the tile as an Excel template.
Answer: A

NEW QUESTION NO: 36
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 goal and answer choices, but the text of the scenario is the same in each question in this series.
Start of repeated scenario
You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Pour workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.
Data Sample:

The data model is shown in the Data Model exhibit.
Data Model

The tables in the model contain the following data:
DailyRepairs has a log of hours and revenue for each day, workshop, and repair type.
Every day, a log entry is created for each workshop, even if no hours or revenue are recorded for that day. Total Hours and Total Revenue are two measures denned in DailyRepairs. Total Hours sums the Hours column, and Total Revenue sums the Revenue column.
Workshops has a list of all the workshops and the current and previous workshop managers. The format of the Workshop Manager column is always FirstnameLastname. A value of 1 in the IsLatest column indicates that the workshop manager listed in the record is the current workshop manager.
RepairTypes has a list of all the repair types.
Dates has a list of dates from 2015 to 2018.
End of repeated scenario.
You create a measure named Average Revenue Per Hour that average revenue per hour.
You need to populate a cell in a worksheet to display the Average Revenue Per Hour where Repair Type is Engine.
Which Excel formula should you use?

A. Option B
B. Option D
C. Option C
D. Option A
Answer: C

NEW QUESTION NO: 37
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 Users.xlsx.
What should you do?
A. From the Data tab in Excel click Connections, and then modify the properties of the connection.
B. From the Linked Table tab in Power Pivot, modify the Update Mode.
C. From the Insert tab in Excel, click My Add-ins, and then manage the add-ins.
D. From Query Editor, modify the Source step.
Answer: B