Free Microsoft 70-779 Exam Dumps Questions & Answers

You have a Power Pivot data model that contains a table named DimProduct DimProduct has seven columns named ProductKey, ProductLabel, ProductName, ProductDescription, ProductSubCategoryKey, Manufacturer, and Brand.
Only the members of the product team use all the data in the DimProduct table.
You need to simplify the model for other users by hiding all the columns except ProductName.
What should you do?

• A.  Create a perspective that has only the ProductName field from DimProduct selected.
• B.  Select all the columns in DimProduct except ProductName, right-click the columns, and then click Hide from Client Tools.
• C.  Edit the Default Field Set for DimProduct and add ProductName to the Default Field.
• D.  Edit the Table Behavior settings for DimProduct and add ProductName to the Default Label.

You open C:\Data\Data,xlsx m Excel.
When you attempt to publish the file to Microsoft Power BI, you receive the following error message: "We couldn't publish to Power BI. Make sure your workbook is saved as an Excel file (.xlsx or .xlsm) and is not password protected.* You need to ensure that you can publish the file to Power BI.
What should you do first?

• A.  Decrypt the workbook.
• B.  Disable iterative calculation for the workbook.
• C.  Copy the file to a network share.
• D.  Add a digital signature to the workbook.

You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1.
You need to modify Goal to multiply the sales from the previous year by 1.15.
What should you do?

• A.  From the properties of the KPI, modify the KPI base field.
• B.  From Power Pivot, modify the measure.
• C.  From Power Pivot, create a new calculated column, and then modify the KPI.
• D.  From the properties of the KPI, modify the absolute value.

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 a data model that contains a table named SalesOrders has four columns named Orderld, SalesAmount, OrderDate, and Territory.
You plan to create a PivotChart that will display the percentage of SalesAmount for each Territory.
You need to create a measure to calculate the percentage of sales of each territory.
How should you complete the DAX formula? To answer, drag the appropriate value to the correct targets.
Each value may be used once, more than once, or not at all. You need to drag the split bar between panes or scroll to view content.

Correct Answer:

Explanation
SUM([SalesAmount) / ALL(SalesOrders) /(FILTER , ALL(SalesOrders))