Fast2testでは、070-779対策に印刷できるPDF、Desktop Test Engine、Online Test Engineの3形式をご用意しています。Microsoft Analyzing and Visualizing Data with Microsoft Excelの118問の練習問題を、自宅でも外出先でもライフスタイルに合わせて学べます。

070-779試験対策に選べる3つの学習形式

• PDF版：印刷して持ち運べる形式で、専門家が作成した内容をすぐにダウンロードして確認できます。学習場所を選ばず、365日間の無料更新と無料PDFサンプルに対応しています。
• Desktop Test Engine：インストールして使用するソフトウェアで、実際の試験環境を再現した2つの練習モードを利用できます。オフライン学習に対応し、Windowsで動作します。
• Online Test Engine：ブラウザーからすぐにアクセスでき、学習履歴と成績を確認できます。Windows、Mac、Android、iOSで利用できます。

Fast2testの安心な購入・利用サポート

• McAfeeのセキュリティサービスにより、お客様の情報を安全に取り扱います。
• ご購入後365日間は無料で更新版をご利用いただけます。更新期間の終了後も、50%割引で継続更新が可能です。
• ご入金確認後はすぐにダウンロードでき、通常1分以内にメールでもお届けします。2時間経っても届かない場合は、カスタマーサポートへご連絡ください。
• インストール可能なパソコン台数に制限はありません。

Microsoft Analyzing and Visualizing Data with Microsoft Excelの試験情報

Microsoft 070-779 試験概要:

070-779試験の出題範囲

Microsoft 070-779 試験シラバストピック:

070-779試験の疑問を解消するFAQ

Microsoft Analyzing and Visualizing Data with Microsoft Excel 認定 070-779 試験問題：

問題 #1

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. dashboard
B. apps
C. datasets
D. reports

問題 #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 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 calculated column that uses the RELATED DAX function Does this meet the goal?

A. Yes
B. No

問題 #3

You have an Excel workbook that has the following two workbook queries:
* A query named Consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database
* A query named Employees that retrieves a table named Employee_Contact from a Microsoft Azure SQL database Both tables have the same columns.
You need to combine all the data from Consultants and Employees into one table.
Which command should you use?

A. Merge Queries
B. Append Queries
C. Transpose
D. Combine Binaries

問題 #4

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?

A. Select the data, and Then insert a PivotTable.
B. Save the tile as an Excel template.
C. Install Power BI Publisher for Excel.
D. Select the data, and then insert a table.

問題 #5

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

解説：