You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains

the following columns:

• Customer ID

• Customer Name

• Phone

• Email Address

• Address ID

Address contains the following columns:

• Address ID

• Address Line 1

• Address Line 2

• City

• State/Region

• Country

• Postal Code

Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique

address m the Address table. You need to create a query that has one row per customer. Each row must contain

City. State/Region, and Country for each customer. What should you do?

You need to create a visual that compares profit across 10 product categories for a selected quarter.

What is the best visual to use to achieve the goal? More than one answer choice may achieve the goal Select

the BEST answer.

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection' 

You import a Power Bl dataset that contains the following tables:Date

• Product

• Product Inventory

The Product inventory table contains 25 million rows. A sample of the data is shown in the following table

The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?

You are creating a dashboard by using the Power Bl service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do?