Free Microsoft 70-779 Exam Dumps Questions & Answers

You have a table named Date that contains the following data.

You have a table named Sales that contains the following data.

You plan to create a PivotCharts that will be sliced by MonthName.
You need to create a relationship between Sales and Date.
Which columns should you use to create the relationship? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
DATE: DateKey
SALES: OrderDate
Refer below

https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

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

What should you do?

• A.  Select the Location columns and then select split column by delimiter. Use a comma as the delimiter and split into columns.
• B.  Select the Customer columns, and then click
• C.  Select the Customer columns, and then click
• D.  Select the Locations columns and the select split column by delimiter. Use a comma as the delimiter and split into rows.

You have 12 sales reports stored in a folder as CSV files. Each report represents one month of sales data for a year. The reports have the same structure.
You need to analyze the entire year of sales data.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation
Click From CSV, and then select the first file in the folder.
Edit the query, and then click Append Queries.
From the Power Pivot tab, click Add to Data Model.

You have a data model that has the following tables.

You create a PivotTable. The data displayed in the PivotTable is shown in the following table.

You need to ensure that the correct data is displayed.
What should you do?

• A.  Modify the workbook connections
• B.  Modify the relationships
• C.  Refresh the data connection
• D.  Configure the PivotTable Options

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