Online Access Free 70-779 Exam Questions

You have the following tables.

There is a relationship between the tables.
You need to create a measure that displays how many users have a total TimeInMinutes that is greater than 60.
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.

Correct Answer:

You have the data model shown in the exhibit.

You need to create a hierarchy from
DimProductSubcategory[ProduaSubcategoryName]andDimProduct[ProductName].
What should you do before you create the hierarchy?

• A.To DimProduct, add a calculated column named ProductSubcategoryName that uses the VALUES(DimProductSubcategory[ProductSubcategoryName]) DAX formula.
• B.To DimProduct, add a calculated column named ProductSubcategoryName that uses the LOOKUPVALUE(DimProductSubcategory
  [ProductSubcategoryName],DimProductSubcategory[ProductCategoryKey],[ProductSubcategoryKey]) DAX formula.
• C.Create a relationship between the tables. To DimProductSubcategory, add a calculated column named ProductName that uses the LOOKUPVALUE(DimProduct[ProductName],DimProduct[ProductKey],[ProductKey]) DAX formula.
• D.Create a relationship between the tables. To DimProduct, add a calculated column named ProductSubcategoryName that uses the RELATEDTABLE (DimProductSubcategory[ProductSubcategoryName]) DAX formula.

You have a workbook query that loads data from a table named Products.
Products contains a column named IntemalPrice that has a Data Type of Decimal.
From Query Editor you create a custom column named ResellerPrice that uses a formula to multiply InternalPrice by 1.2, and then you remove the IntemalPrice column.
What will occur when you load the data to a worksheet?

• A.An error message will appear and all the data will fail to load.
• B.All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be null.
• C.All the columns except InternalPrice will load to the worksheet The values in ResellerPrice will be correct.
• D.An error message will appear and all the columns except InternalPnce and ResellerPrice will load to the worksheet.

You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server Database and loads data to the data model. You create a PivotTable and PivotChart.
You plane to share SalesResults.slsx to several users outside of your organization.
You need to ensure that the users can see the PivotTable and the PivotChart when they open the file. The data in the model must be removed.
What should you do?

• A.Save the workbook as an Excel Binary Workbook (xlsx)
• B.Run the Document inspector.
• C.Modify the source of the query.
• D.From Query Editor, open the Data Source Setting and delete the credentials.

You have a table that contains sales data.
You need to create a Pivot Table that will display the sales by country as shown in the following exhibit.

What should you use to display the icons?

• A.conditional formatting
• B.a KPI
• C.a measure
• D.data validation