The latest Microsoft 70-779 dumps by Lead4Pass helps you pass the 70-779 exam for the first time! Lead4Pass Latest Update Microsoft 70-779 VCE Dump and 70-779 PDF Dumps, Lead4Pass 70-779 Exam Questions Updated, Answers corrected! Get the latest LeadPass 200 -301 dumps with Vce and PDF: https://www.leads4pass.com/70-779.html (Q&As: 115 dumps)
[Free 70-779 PDF] Microsoft 70-779 Dumps PDF can be collected on Google Drive shared by Lead4Pass: https://drive.google.com/file/d/1eya9rudoHjL_pmpk1Z4LHiSSivpusD-d/
[Lead4pass 70-779 Youtube] Microsoft 70-779 Dumps can be viewed on Youtube shared by Lead4Pass.
Microsoft 70-779 Online Exam Practice Questions
QUESTION 1
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 have 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 latest column indicates that the
workshop
The manager listed in the record is the current workshop manager.
Repair types have a list of all the repair types.
Dates have a list of all the repair types.
Dates have 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:
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 on 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 edit the source of each table query.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
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 answers choices, but the text of the scenario is
the
same in each question in this series.
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 simplified view of the workbook for some users. The simplified view must only display data from
FactSales, DimProduct, and DimDate.
What should you do in the data model?
A. Click Hide from Client Tolls for all the tables except FactSales, DimProduct, and DimDate.
B. Create a new perspective.
C. Modify the Table Behavior settings for FactSales, DimProduct, and DimDate.
D. Add the columns from FactSales, DimProduct, and DimDate to the Default Field Set.
Correct Answer: A
QUESTION 4
You have a model that contains the following table named Sales.
You have a 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.
Select and Place:
QUESTION 5
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.
Select and Place:
QUESTION 6
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
the 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:
QUESTION 7
You have a Power Pivot data model that contains a table named DimProduct DimProduct has seven columns named
ProductKey, ProductLabel, ProductName, ProductDescription, ProductSubCategoryKey, Manufacturer, and Brand.
Only the members of the product team use all the data in the DimProduct table.
You need to simplify the model for other users by hiding all the columns except ProductName.
What should you do?
A. Create a perspective that has only the ProductName field from DimProduct selected.
B. Select all the columns in DimProduct except ProductName, right-click the columns, and then click Hide from Client
Tools.
C. Edit the Default Field Set for DimProduct and add ProductName to the Default Field.
D. Edit the Table Behavior settings for DimProduct and add ProductName to the Default Label.
Correct Answer: B
https://support.office.com/en-us/article/hide-columns-and-tables-in-power-pivotddf5b1f2-2ed2-4bdb-8f78-6f94503ca87a
QUESTION 8
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 9
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 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 an Excel workbook that contains a table named Table1. A sample of the data in Table1 is shown in the
following table.
You need to create a PivotTable in PowerPivot as shown in the exhibit.
Solution: You create a measure named Products the uses the CONCATENATEX 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
Get more exam practice questions and Led4pass 70-779 exam discounts: https://www.exampdfdownload.com/latest-updates-to-microsoft-mcsa-70-779-brain-dump-and-practical-and-effective-practice-testing/
latest updated Microsoft 70-779 exam questions from the Lead4Pass 70-779 dump! 100% pass the 70-779 exam! Download Lead4Pass 70-779 VCE and PDF dumps: https://www.leads4pass.com/70-779.html (Q&As: 115 dumps)
Get free Microsoft 70-779 dumps PDF online: https://drive.google.com/file/d/1eya9rudoHjL_pmpk1Z4LHiSSivpusD-d/
