Free Microsoft 070-778 Exam Dumps Questions & Answers

You have a Power BI model that contains the following two tables:
* Sales(Sales_ID, sales_date, sales_amount, CustomerID)
* Customer(CustomerID, First_name, Last_name)
There is a relationship between Sales and Customer.
You need to create a measure to rank the customers based on their total sales amount.
Which DAX formula should you use?

• A.RANK.EQ(Sales[sales_amount], Customer[CustomerID])
• B.RANKX(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
• C.TOPN(ALL(customer), SUMX(RELATEDTABLE(Sales), [Sales_amount]))
• D.RANKX(ALL(Sales), SUMX(RELATEDTABLE(Customer), [Sales_amount]))

You have two tables named CustomerVisits and Date in a Power BI model.
You create a measure to calculate the number of customer visits. You use the measure in the report shown in the exhibit. (Click the Exhibit.)

You discover that the total number of customer visits was 60,000, and that there were only 5,000 customer visits in August.
You need to fix the report to display the correct data for each month.
What should you do?

• A.Create a hierarchy in the Date table.
• B.Create a relationship between the CustomerVisits table and the Date table.
• C.Modify the measure to use the SUM DAX function.
• D.Modify the n=measure to use the CALCULATE DAX function.

You have a table in Power BI Desktop as shown in the following exhibit.

You pivot the columns as shown in the following exhibit.

You need to resolve the error in row 3. The solution must preserve all the data.
What should you do?

• A.Change the Data Type of the Value column.
• B.Select the Score column, and then click Remove Errors.
• C.Change the Aggregate Value Function of the pivot.
• D.Select the Key column, and then click Remove Duplicates

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, while 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 for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number.
You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
You need to ensure that nonnumeric values in the CustomerlD column are set to 0.
Solution: From Query Editor, open Advanced Editor and add the following query step.
#"Replaced Errors" - Table.ReplaceErrorValues(s"Changed Type", {{"CustomerlD", 0}}) Does this meet the goal?

• A.No
• B.Yes

You have an app workspace named Retail Store Analysis in the Power Bl service.
You need to manage the members that have access to the app workspace using the least amount of administrative effort.
What should you do?

• A.From the Office 365 Admin center, click Groups.
• B.From the Power Bl Admin portal, click Tenant settings.
• C.From the Office 365 Admin center, click Users.
• D.From the Power Bl Admin portal, click Usage metrics .