Online Access Free 70-779 Exam Questions

You add two tables named Date and Invoices to a data model, Invoices contains a column named InvoiceDate that has a Data Type of Date, Date contains a column named DateID that has a Data Type of which Number.
DateID is in the format of YYYYMMDD.
You need to create a relationship between Date and Invoices.
What should you do first?

• A.Create a calculated column in Invoices that uses the Format DAX function.
• B.Create a measure in Invoices that uses the Format DAX Function.
• C.Change the Data Type of DateID to Date.
• D.Change the Data Type of InvoiceDate and DateID to Text.

You have a query as shown in the following exhibit.

You need to ensure that the data only contains rows that have a valid date.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

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

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

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, white 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 query named Quety1 that retrieves the user information from two Excel files. One of the Excel files does not contain location information. A sample of the data retrieved by the query is shown in the following table.

You need to ensure that values in UserName are unique. The solution must ensure that the locations are retained. A sample of desired output is shown in the following table.

Solution: You sort the UserName column in ascending order. You select the UserName column, and then you click Remove Duplicates. Does this meet the goal?

• A.No
• B.Yes