070-779 by Microsoft Valid Free Exam Practice Test

Question 1

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 Count Values command on the Transform tab. B. Create a query that uses a file source, and then use the Count Values command on the Transform tab. C. Create a query that uses a folder 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 Group By command on the Home tab.

Correct Answer: C

Question 2

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 configure the Data source settings.
Does this meet the goal?

A. Yes B. No

Correct Answer: A

Question 3

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?

A. VLOOKUP B. LOOKUP C. CUBESET D. CUBEVALUE

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

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 frequently.
You need to transform the data as shown in the following table.

What should you do?

A. Select the Locations columns and then select Split Column by Delimiter. Use a comma as the delimiter and split into columns. B. Select the Locations columns and then select Split Column by Delimiter. Use a comma as the delimiter and split into rows. C. Select the Customer columns, and then click Unpivot Columns. D. Select the Customer columns, and then click Unpivot Other Columns.

Correct Answer: B

Question 5

You have the following table named SalesOrder Detail in a model.

You need to calculate the sum of SalesTotal for all the rows that have a quantity greater than 1.

Correct Answer:

Explanation

CALCULATE(SUMX('SalesOrdersDetail'[SalesTotal]),'SalesOrderDetail'[Quantity] > 1)

Question 6

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 a PivotChart.
You plan to share SalesResults.xlsx 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. Run the Document Inspector. B. From Query Editor, open the Data Source Settings and delete the credentials. C. Modify the source of the query. D. Save the workbook as an Excel Binary Workbook (.xlsb).

Correct Answer: B

Question 7

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 chronologically be default.
What should you do?

A. Change the Data Type of [Month Name] to Date. B. Sort the [Month Name] column by [Month Name]. C. Sort the [Month Name] column by [Month Name]. D. Add a calculated column named [ID] that use the [Month Name] & [Month Number] DAX formula

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

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. From Query Editor, open the Data Source Setting and delete the credentials. B. Run the Document inspector. C. Modify the source of the query. D. Save the workbook as an Excel Binary Workbook (xlsx)

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Microsoft Analyzing and Visualizing Data with Microsoft Excel - 070-779 Exam Practice Test