Test 70-779 Analyzing and Visualizing Data with Microsoft Excel Dumps Online

1. DRAG DROP

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.

2. 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?

3. 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?

4. 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?

5. 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?

6. You have a table named Sales that has three columns named OrderDate, OrderNumber, and SalesAmount.

You need to create the PivotTable as shown in the following table.

What should you use?

7. 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?

8. You have a data model in Excel.

You export the data and the data model into a dataset in the Microsoft Power BI service.

What can you use to modify the data model that is published to the Power BI service?

9. You have a table named Sales that has three columns named Region, Country, and SalesAmount.

You create a PivotTable as shown in the following exhibit.

You need to ensure that the PivotTable appears in three columns as shown in the following exhibit.

10. You have a pie chart.

You need the wedges of the pie chart to be separated as shown in the following exhibit.

11. You need to create a PivotChart that has a filter as shown in the following exhibit.

12. DRAG DROP

You create a new workbook and add a table to a data model. The data is shown in the following table.

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

Witch 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.

13. You have the data model shown in the Data Model exhibit. (Click the Exhibit button.)

You have the PivotChart shown in the Pivot Chart exhibit. (Click the Exhibit button.)

You need to change the current view of the PivotChart to display ProductCategory only.

What should you do?

14. 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?

15. DRAG DROP

You have a data model that contains a table named SalesOrders has four columns named Orderld, SalesAmount, OrderDate, and Territory.

You plan to create a PivotChart that will display the percentage of SalesAmount for each Territory.

You need to create a measure to calculate the percentage of sales of each territory.

How should you complete the DAX formula? To answer, drag the appropriate value to the correct targets. Each value may be used once, more than once, or not at all. You need to drag the split bar between panes or scroll to view content.

16. You add two tables named Date and Invoices to a data model, Invoices contains a column named InvoiceDate that has a Data Type of Date, Date contains a column named DateID that has a Data Type of which Number. DateID is in the format of YYYYMMDD.

You need to create a relationship between Date and Invoices.

What should you do first?

17. 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?

18. You have a table in Power Pivot model that is loaded from a Microsoft SQL Server database.

The source table has four columns named ID, Price, Quantity, and Total. Total is derived by multiplying Price and Quantity. ID is a unique row identifier.

You need to minimize the amount of memory used to load the mode. The solution must ensure that you can create visualizations based on Price, Quantity, and Total.

What should you do?

19. DRAG DROP

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

You have measure named TotalSales that calculates the sum of Line Total.

You plan to create a PivotChart to display TotalSale for each category and the percent of total sales for each category as shown in the following exhibit.

How should you complete the DAX formula for the Percent measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is wroth on point.

20. HOTSPOT

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

You plan to create Pivot Charts 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.