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

Note: This question is part of a series of questions that use the same scenario, For your convenience 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 measure named [Sales Monthly RT] that calculates a running total of [Sales] for each date within a month as shown in the following exhibit.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

Explanation
SUM [Sales], DATESMTD
The following sample formula creates a measure that calculates the 'Month To Date Total' for the Internet sales.
To see how this works, create a PivotTable and add the fields, CalendarYear, MonthNumberOfYear and DayNumberOfMonth, to the Row Labels area of the PivotTable. Then add a measure, named Month To Date Total, using the formula defined in the code section, to the Values area of the PivotTable.
=CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), DATESMTD(DateTime[DateKey]))
https://msdn.microsoft.com/en-us/query-bi/dax/datesmtd-function-dax

You have an Excel workbook query that loads data to a worksheet and the data model.
You need to ensure that the data is refreshed whenever you open the workbook.
What should you do?

• A.From the File tab, click Options, and then modify the General options.
• B.From the Data tab, click Queries & Connections, and then edit the properties of the query.
• C.From the Power Pivot model, modify the Table Behavior setting.
• D.From the File tab, click Option, and then modify the Data option.

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.From the data tab, click Refresh All.
• B.Close and open the workbook.
• C.Select a cell in the worksheet and pressF5.
• D.From the Power Pivot tab, click Update All.

You have a workbook query that gets a table from an Excel workbook. The table contains a column1.
In the query, you configure Column1 to use a Data Type of Whole Number.
You refresh the data and find several errors in Column1. You discover that new entries in the table contain nonnumeric characters.
You need to ensure that when the data is imported, any fields that contain nonnumeric values are set 1.
What should you do from Query Editor?

• A.Select the table and click Keep Errors.
• B.Select the column and click Replace Values...
• C.Select the column and click Replace Errors...
• D.Select the column and click Remove Errors.

You import the data from two next files into a PowerPivot model to create two tables named Customers and Invoices. Each table contains a column named CustomerID.
When you attempt to create a relationship between the Customers table and the Invoices table by using the CustomerID column from each table, the relationship cannot be created due to duplicate CustomerID values.
You need to ensure that you can create the relationship.
What should you do?

• A.Sort the Invoices query by CustomerID, and then add a Fill Down step
• B.Group the Customers query by CustomerID
• C.Add an index column to the Invoices query
• D.Add an index column to the Customers query