070-779 試験問題を無料オンラインアクセス

You have two visualizations as shown in the following exhibit.


Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

正解：

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 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.Add the columns from FactSales, DimProduct, and DimDate to the Default Field Set.
• B.Create a new perspective.
• C.Click Hide from Client Tolls for all the tables except FactSales, DimProduct, and DimDate.
• D.Modify the Table Behavior settings for FactSales, DimProduct, and DimDate.

You have a workbook query that loads data from a table in a Microsoft Azure SQL database. The table has a column named LineTotal. The following is a sample of the data in LineTotal:
* 40
* 1
* 999
* 7658
* 883432
You need to ensure that when you load the data to the model, LineTotal is set as currency.
What should you do from Query Editor?

• A.Split the column by delimiter.
• B.Configure the Data Type
• C.Split the column by characters.
• D.Round the column.

You have a query that retrieves the following data.

You need to configure the query to ensure that the data appears as shown in the following table.

What should you do?

• A.From the Transform tab, use the sum function on the Vendor_ID column
• B.Pivot the table on the Vendor_ID column
• C.Group by Vendor_ID and add a SUM aggregation
• D.Unpivot the table on the Vendor_ID column

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, add an index column
• B.In the Power Pivot model, change the Table Behavior setting for Workshops
• C.In the workbook query for Workshops, filter [IsLatest] to equal 1
• D.In the Power Pivot model, change the data type for Workshop[ID] to General