You have a dataset named Pens that contains the following columns:
Item
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

Comment: *

Name: *

Email: *

Verification: *

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is rep eated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following co lumns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
Th e Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Order table and the Store table on the Store_ID column.
What should you do before you create the relationship?

• A.In the Order table query, use the Table.TrasformRows function.
• B.In the Store table query, use the Table.TrasformRows function .
• C.In the Store table query, use the Table.TrasformColumnTypes function.
• D.In the Order table query, use the Table.TrasformColumnTypes function.

Comment: *

Name: *

Email: *

Verification: *

You use Power Bi Desktop to create a Power Bl data model and a blank report You need to add the Word Cloud visual shown in the following exhibit to the report.

The solution must minimize development effort
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:

1 - From a web browser, download the PBIVIZ file for the Word Cloud visual from Microsoft AppSource.
2 - Populate the drillthrough fields.
3 - Formate the data colors and title.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Remove the relationship between Date and Product Inventory.
• B.Change the data type of UnitCost to Integer.
• C.Change Summarization for DateKey to Don't Summarize.
• D.Remove MovementDate.

Comment: *

Name: *

Email: *

Verification: *

You have a Power B1 data model that contains two tables named Products and Sales.
A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.
How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content NOTE: Each correct selection is worth one point

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *