Where do I find a 70-779 PDF or any dump to download? Here you can easily get the latest Microsoft MCSA 70-779 exam dumps and 70-779 pdf! We’ve compiled the latest Microsoft 70-779 exam questions and answers to
help you save most of your time. Microsoft 70-779 exam “Analyzing and Visualizing Data with Microsoft Excel” https://www.pass4itsure.com/70-779.html (Q&As:109). All exam dump! Guaranteed to pass for the first time!
Microsoft MCSA 70-779 Exam pdf
[PDF] Free Microsoft 70-779 pdf dumps download from Google Drive: https://drive.google.com/open?id=1oOIaUL-EWdBiEeYnprFysY64u9LJg3ZQ
Microsoft exam certification information
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 Online Exam Practice Questions
QUESTION 1
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 2
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.
Select and Place:
Correct Answer:
SUM([SalesAmount) / ALL(SalesOrders) /(FILTER , ALL(SalesOrders))
QUESTION 3
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. Four workbook
queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.
The data model is shown in the Data Model exhibit.
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 defined 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 Firstname Lastname. 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 alt the repair types.
Dates has a list of dates from 2015 to 2018.
End of repeated scenario.
You plan to analyze The average revenue per hour by combinations of day, repair type, and workshop name.
You need to create a measure to support the planned analysis.
Which DAX formula should you use? To answer, drag the appropriate values to the correct targets. Each value 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 4
You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data
model.
You discover that new rows were added to the tables in Azure SQL Database.
You need to ensure that the workbook has the new data.
Why should you do?
A. Select a cell in the worksheet and pressF5.
B. From the data tab, click Refresh All.
C. Close and open the workbook.
D. From the Power Pivot tab, click Update All.
Correct Answer: C
QUESTION 5
You have a workbook query that gets data from a table in a Microsoft Azure SQL database. The table has a column
named Phone. The values in Phone are in a format of 999-999-9999. The first three digits of each phone number
represent
the area code, and the rest of the digits represent the local phone number.
You need to split the Phone column into two columns. The first column must contain the area code, and the second
column must contain the local phone number.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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 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?
A. Change the Data Type of InvoiceDate and DateID to Text.
B. Create a measure in Invoices that uses the Format DAX Function.
C. Change the Data Type of DateID to Date.
D. Create a calculated column in Invoices that uses the Format DAX function.
Correct Answer: C
QUESTION 7
Start of repeated scenario
You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook
queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.
The data model is shown in the Data Model exhibit.
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 defined 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 Firstname Lastname, A value of 1 in the IsLatest column indicates that the
workshop
manager listed in the record is the current workshop manager.
Repair types has a list of all the repair types.
Dates has a list of all the repair types.
Dates has a list of dates from 2015to 2018.
End of repeated scenario.
You need to create a PivotChart that displays the month, the hours of the month, and the hours of the previous month,
as shown in the following exhibit.
Which DAX formula should you use for the Total Hours Last Month 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 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 8
You need to create a PivotChart as shown in the 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 9
You have the Excel worksheet shown in the exhibit.
You need to transform the data by using Query Editor. What should you do first?
A. From the Data tab, click From Table/Range.
B. From the Data tab, click Flash Fill.
C. From the Data tab, click Consolidate.
D. From the Insert tab, click Store.
Correct Answer: A
QUESTION 10
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 the following data.
You need to retrieve a list of the unique ProductName entries.
Solution: Open the Advanced Filter dialog box, select Filter the list, in-place, and then select Unique records only.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
QUESTION 11
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 an Excel workbook that contains a table named Table1. A sample of the data inTable1 is shown in the
following table.
You need to create a PivotTable in PowerPivot as shown in the exhibit.
Solution: You create a hierarchy named Products that contains ProductCategory,
Solution: You create a measure named Products the uses the DataTable DAX Function. You add a PivotTable. You
drag products to the Rows field. You drag Price to the Values field.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
QUESTION 12
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 file source, and then use the Count Values command on the Transform tab.
B. Create a query that uses a folder source, and then use the Group By command on the Home tab.
C. Create a query that uses a file source, and then use the Group By command on the Home tab.
D. Create a query that uses a folder source, and then use the Count Values command on the Transform tab.
Correct Answer: B
QUESTION 13
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?
A. Microsoft Power BI Desktop
B. Excel and the Microsoft Power BI service
C. Excel only
D. the Microsoft Power BI service only
Correct Answer: A
Share Pass4itsure discount codes for free
The benefits of Pass4itsure!
Pass4itsure offers the latest exam practice questions and answers free of charge! Update all exam questions throughout the year,
with a number of professional exam experts! To make sure it works! Maximum pass rate, best value for money! Helps you pass the exam easily on your first attempt.
Summarize:
Get the full Microsoft MCSA 70-779 exam dump here: https://www.pass4itsure.com/70-779.html (Q&As:109). Follow my blog and we regularly update the latest effective exam dumps to help you improve your skills!
This maybe you’re interested
