Valid 70-778 Dumps shared by Lead1pass for Helping Passing 70-778 Exam! Lead1pass now offer the newest 70-778 exam dumps, the Lead1pass 70-778 exam questions have been updated and answers have been corrected get the newest Lead1pass 70-778 with Test Engine here:
http://https://www.lead1pass.com/Microsoft/70-778-practice-exam-dumps.html (100 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 2
You are importing sales data from a Microsoft Excel file named Sales.xlsx into Power BI Desktop.
You need to create a bar chart showing the total sales amount by region.
When you create the bar chart, the regions appear as expected, but the sales amount value displays the count of sales amount instead of the sum of sales amount each region.
You need to modify the query to ensure that the data appears correctly.
What should you do?
A. In Query Editor, add a calculated column that totals the sales amount column.
B. Change the Data Type of sales amount column to Numeric.
C. Delete the query, import the data into Microsoft SQL Server, and then import the data from SQL Server.
D. Refresh the data model.
Answer: A

NEW QUESTION NO: 3
You have a service published to a website.
When you connect to the website, you receive the following data.

You need to create a query that retrieves the Categories data and the Customers data.
Which type of source should you use?
A. XML
B. OData Feed
C. JSON
D. Text/CSV
Answer: A

NEW QUESTION NO: 4
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 an app workspace that contains a report. The report contains sensitive data.
You need to ensure that you can embed the report into a custom application that will be accessed by external users. The external users will NOT have a Microsoft Azure Active Directory user account or Power BI licenses.
Solution: Configure the app workspace to be read-only for members and to run in a shared capacity.
Does this meet the goal?
A. Yes
B. No
Answer: B

NEW QUESTION NO: 5
You plan to develop a Power BI report that has a bar chart to display the number of customers by location.
You have a table named Customer that has the following columns:
CustomerID

CustomerName

Address

City

ProvState

Country

You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City.
How should you configure the drill down in the bar chart?
A. In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
B. In the Value field, add Country at the top, followed by ProvState, and then City.
C. In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
D. In the Axis field, add Country at the top, followed by ProvState, and then City.
Answer: D
Explanation/Reference:
References:
https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18
https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down

NEW QUESTION NO: 6
You have the following tables.

There is a many-to-one relationship from Subscriber to Date that uses Subscriber[StartDate] and Date
[Date]. The Cross filter direction of the relationship is set to Single.
You plan to create a column chart that displays the following two measures:
Count of SubscriberID by Month based on the StartDate

Count of SubscriberID by Month based on the EndDate

What should you do before you create the measures?
A. Create an active one-to-one relationship from Subscriber[StartDate] to Date[Date].
B. Change the Cross filter direction of the active relationship to Both.
C. Change the active relationship for many-to-one.
D. Create an inactive many-to-one relationship from Subscriber[StartDate] to Date[Date].
Answer: B
Explanation/Reference:
References: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

NEW QUESTION NO: 7
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit.
(Click the Exhibit button.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)

You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory[Subcategory] contains NULL values.
End of Repeated Scenario.
You implement the Power BI model.
You add another table named Territory to the model. A sample of the data is shown in the following table.

You need to create a relationship between the Territory table and the Sales table.
Which function should you use in the query for Territory before you create the relationship?
A. Table.Distinct
B. Table.IsDistinct
C. Table.ReplaceMatchingRows
D. Table.RemoveMatchingRows
Answer: A
Explanation/Reference:
References: https://msdn.microsoft.com/en-us/library/mt260775.aspx

NEW QUESTION NO: 8
You have a query that retrieves sales data. A sample of the data is shown in the following table.

You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row.
What should you click on the Transform tab in Query Editor?
A. Format, and then Clean
B. Date, and then Earliest
C. Fill, and then Down
D. Replace Values, and then Replace Errors
Answer: C
Explanation/Reference:
References:
https://www.excelcampus.com/library/fill-down-blank-null-cells-power-query/

NEW QUESTION NO: 9
You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables:
Product (Product_id, Product_Name)

Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)

Salesperson (Salesperson_id, Salesperson_name, address)

The model has the following relationships:
Sales to Product

Sales to Salesperson

You create a new Power BI file and import the Power Pivot model.
You need to ensure that you can generate a report that displays the count of products sold by each salesperson.
What should you do before you create the report?
A. Create a one-to-one relationship between Product and Salesperson.
B. For each relationship, change the Cross filter direction to Both.
C. For each relationship, change the Cardinality to One to one (1:1).
D. Change a many-to-one relationship between Product and Salesperson.
Answer: B
Explanation/Reference:
References: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

NEW QUESTION NO: 10
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 button.)

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. Modify the measure to use the CALCULATE DAX function.
B. Create a relationship between the CustomerVisits table and the Date table.
C. Modify the measure to use the sum DAX function.
D. Create a hierarchy in the Date table.
Answer: B
Explanation/Reference:
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures

NEW QUESTION NO: 11
You have a table named Sales that contains sales data for the United States. A sample of the data in Sales is shown in the following table.

When you attempt to create a map that shows SalesAmount by Zone, you discover that the map shows a bubble based on cities instead of states.
You need to ensure that the map shows bubbles based on states.
What should you do?
A. Add a column named Country that contains United States as the value.
B. Add a column for longitude and a column for latitude.
C. Select the Zone field. From the Modeling tab, change the Data Category.
D. Select the Zone field. From the Modeling tab, change the Data Type.
Answer: C
Explanation/Reference:
References: https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-5

NEW QUESTION NO: 12
You use Power BI Desktop to create a visualization for a Microsoft SQL Server data source.
You need to ensure that you can use R visualization.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Download and install Microsoft R Server.
B. Download and install RStudio Server on the computer that has Power BI Desktop installed.
C. Install SQL Server R Services on the server that runs SQL Server.
D. Enable R Scripting on the computer that has Power BI Desktop installed.
E. Download and install Microsoft R on the computer that has Power BI Desktop installed.
Answer: E
Explanation/Reference:
References: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals