ExamsCode shares online exam exercise questions all year round! Microsoft MCSA 70-779 exam “Analyzing and Visualizing Data with Microsoft Excel”
https://www.leads4pass.com/70-779.html (109 Q&As).Continue to study and we provide an updated cisco 70-779 exam practice questions and answers. You can practice the test online!
Watch the Microsoft MCSA 70-779 video tutorial online
Table of Contents:
- Latest Microsoft MCSA 70-779 pdf
- Test your Microsoft MCSA 70-779 exam level
- Related 70-779 Popular Exam resources
- Get Lead4Pass Coupons (12% OFF)
- What are the advantages of Lead4pass?
Latest Microsoft MCSA 70-779 pdf
[PDF] Free Microsoft MCSA 70-779 pdf dumps download from Google Drive: https://drive.google.com/open?id=1rKYauOFwJ2UkXI0L6DoAlcKkh3HrgCP5
Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel：https://www.microsoft.com/en-us/learning/exam-70-779.aspx
Skills measured
This exam measures your ability to accomplish the technical tasks listed below.
- Consume and Transform Data by Using Microsoft Excel (30-35%)
- Model Data (35-40%)
- Visualize Data (30-35%)
Who should take this exam?
Candidates for this exam should have a strong understanding of how to use Microsoft Excel to perform data analysis. Candidates should be able to consume, transform, model, and visualize data in Excel. Candidates should also be able to configure and manipulate data in PowerPivot, PivotTables, and PivotCharts. Candidates may include BI professionals,
data analysts, and other roles responsible for analyzing data with Excel.
Microsoft MCSA 70-779 Exam Practice Questions
QUESTION 1
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
rows.
B. Select the Locations columns and then select Split Column by Delimiter. Use a comma as the delimiter and split into
columns.
C. Select the Customer columns, and then click Unpivot Columns.
D. Select the Customer columns, and then click Unpivot Other Columns.
Correct Answer: A
QUESTION 2
You have a query as shown in the following exhibit.
You need to ensure that the data only contains rows that have a valid date.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions
to the answer are in the correct order.
Select and Place:
Correct Answer:
QUESTION 3
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 Power BI tab in Excel, click Pin.
B. From the File menu in Excel, click Publish.
C. From powerbi.com, upload the excel workbook.
D. From powerbi.com, click Get apps.
Correct Answer: B
QUESTION 4
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.
Hot Area:
Correct Answer:
QUESTION 5
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 chart as shown in the following exhibit.
Which field should you use for each area? To answer, drag the appropriate fields to the correct areas. Each field may be
used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct Answer:
QUESTION 6
You have a pie chart.
You need the wedges of the pie chart to be separated as shown in the following exhibit.
A. Change the chart type to Pie of Pie.
B. Right-click the pie chart, click Expand/Collapse, and then click Expand.
C. Right-click the pie chart, click Expand/Collapse, and Then click Expand Entire Field
D. Select a wedge of the pie chart and then drag the wedge.
Correct Answer: D
QUESTION 7
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.
Your company has sales offices in several cities.
You create a table that the represents the amount of sales in each city by month as shown in the exhibit.
You need to ensure that alt values lower than 250 display a red icon. The solution must ensure that all values greater
than 500 display a green icon.
Solution: You create a new conditional formatting rule that uses the Format only cells that contain rule type.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
QUESTION 8
You have a model that contain data relating to corporate profits. The model contains a measure named Profit.
You need to create a PivoTable to display the Profit measure in three different formats by using the Show Value As
feature. The PivoTable must produce the result shown in the following table.
NOTE: Each correct selections is worth one point.
Hot Area:
Correct Answer:
% Profit of Annual Total: % of Parent Total % Profit of Grand Total: % of Column Total
https://support.office.com/en-us/article/show-different-calculations-in-pivottable-value-fields-014d2777-baaf-480b-a32b-98431f48bfec
QUESTION 9
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. Save the workbook as an Excel Binary Workbook (.xlsb).
C. From Query Editor, open the Data Source Settings and delete the credentials.
D. Modify the source of the query.
Correct Answer: C
QUESTION 10
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 Linked Table tab in Power Pivot, modify the Update Mode.
B. From Query Editor, modify the Source step.
C. From the Insert tab in Excel, click My Add-ins, and then manage the add-ins.
D. From the Data tab in Excel click Connections, and then modify the properties of the connection.
Correct Answer: A
QUESTION 11
You merge several CVS files by using Query Editor.
You need to remove all the leading whitespaces and all the non-printable characters from a column.
What should you do to achieve each task? To answer, drag the appropriate actions to the correct goals. Each action
may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view
content.
NOTE: Each correct selection is worth one point.
Select and Place:
Correct Answer:
QUESTION 12
You install Microsoft Power BI Publisher for Excel.
You need to use Excel to connect and analyze Power BI data.
To which two types of Power BI data can you connect? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. apps
B. datasets
C. reports
D. dashboard
Correct Answer: BC
Analyze in Excel is very useful for datasets and reports that connect to Analysis Services Tabular or Multidimensional
databases, or from Power BI Desktop files or Excel workbooks with data models that have model measures created
using Data Analysis Expressions (DAX).
https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel
QUESTION 13
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 a Power Pivot model that contains the following tables.
There is a relationship between Products and ProductCategory.
You need to create a hierarchy in Products that contains ProductCategoryName and ProductName.
Solution: You create a measure that uses the USERELATIONSHIP DAX function.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
Related 70-779 Popular Exam resources
| title | youtube | Microsoft | lead4pass | Lead4Pass Total Questions | |
|---|---|---|---|---|---|
| Microsoft MCSA | lead4pass 70-779 dumps pdf | lead4pass 70-779 youtube | Analyzing and Visualizing Data with Microsoft Excel | https://www.leads4pass.com/70-779.html | 109 Q&A |
Get Lead4Pass Coupons(12% OFF)
What are the advantages of Lead4pass?
We have a number of Cisco, Microsoft, IBM, CompTIA and other exam experts. We update exam data throughout the year.
Top exam pass rate! We have a large user base. We are an industry leader! Choose Lead4Pass to pass the exam with ease!
Summarize:
The free Microsoft MCSA 70-779 exam dumps can help you improve your skills and exam experience! To pass the cisco 70-779 exam at once: https://www.leads4pass.com/70-779.html We make Microsoft 70-779 videos and 70-779 pdf for you to learn! I hope you can pass the exam easily.
