2026 年，Microsoft 原廠認證在業界的含金量依舊有目共睹，Microsoft Analyzing and Visualizing Data with Microsoft Excel 更是履歷上的一大亮點。Fast2test 以 118 道 70-779 練習題，協助您穩紮穩打朝這張證照邁進。

Microsoft 70-779 考試概覽:

Microsoft 70-779 考試大綱主題:

70-779 考試熱門問答集

最新的 Microsoft Excel - Power BI - MCSA 70-779 免費考試真題：

問題 #1

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 Insert tab in Excel, click My Add-ins, and then manage the add-ins.
B. From the Data tab in Excel click Connections, and then modify the properties of the connection.
C. From the Linked Table tab in Power Pivot, modify the Update Mode.
D. From Query Editor, modify the Source step.

問題 #2

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 chokes, 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.
Data Sample exhibit:




The data model is shown in the Data Model exhibit. (Click the Exhibit button.)

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 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 IsLatest column indicates that the workshop manager listed in the record is the current workshop manager.
* RepairTypes has a list of all the repair types
* Dates has a list of dates from 2015 to 2018
End of repeated scenario.
When you attempt to create a relationship between DailyRepairs and Workshops, Power Pivot generates the following error message: "The relationship cannot be created because each column contains duplicate values.
Select at least one column that contains only unique values".
You need to ensure that you can create a valid relationship between the tables.
What should you do?

A. In the workbook query for Workshops, filter [IsLatest] to equal 1
B. In the Power Pivot model, change the data type for Workshop[ID] to General
C. In the workbook query for Workshops, add an index column
D. In the Power Pivot model, change the Table Behavior setting for Workshops

問題 #3

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: From Query Editor, you edit the source of each table query.
Does this meet the goal?

A. No
B. Yes

問題 #4

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, white 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 query named Query1 that retrieves the user information from two Excel files. One of the Excel files does not contain location information. A sample of the data retrieved t]y the query is shown in the following table.

You need to ensure that values in UserName are unique. The solution must ensure that the locations are retained. A sample of desired output is shown in the following table.

Solution: You select the-UserName and Location columns, and then you click Remove Duplicates.
Does this meet the goal?

A. No
B. Yes

問題 #5

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. Create a calculated column in Invoices that uses the Format DAX function.
B. Create a measure in Invoices that uses the Format DAX Function.
C. Change the Data Type of DateID to Date.
D. Change the Data Type of InvoiceDate and DateID to Text.

問題與答案：