You have a Power Bl report that contains the table shown in the following exhibit.

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

• A.Move the conditional formatting icons to a tooltip report
• B.Change the icons to use a different shape for each color.
• C.Remove the icons and use red, yellow, and green background colors instead
• D.Add alt text that lists the values in the table.

Comment: *

Name: *

Email: *

Verification: *

You have a Power Bl report that contains a page. The page contains the following:
* A shape named Shape 1
* A card named Sales Summary
* A clustered bar chart named Sales by Region
You need to ensure that Sales Summary renders on top of Shape 1. What should you modify?

• A.Tab order in the Selection pane
• B.Layer order in the Selection pane
• C.Maintain layer order in the General visual settings
• D.Vertical alignment in the Canvas settings

Correct Answer: B

You use Power Query Editor to preview the data shown in the following exhibit.
You confirm that the data will always start on row 3, and row 3 will always contain the column names.
You use Power Query Editor to preview the data shown in the following exhibit.

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 repeated 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 columns 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.
The 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.TrasformColumnTypes function.
• B.In the Store table query, use the Table.TrasformColumnTypes function.
• C.In the Store table query, use the Table.TrasformRows function.
• D.In the Order table query, use the Table.TrasformRows function.

Comment: *

Name: *

Email: *

Verification: *

You have a table that contains the following three columns:
* City
* Total Sales
* Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

How should you configure the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Box 1: Total Sales
Box 2: Occupation
Box 3: City
You can use Expand By to add fields you want to use for setting the level of the analysis without looking for new influencers.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?

• A.Change any DAX measures to use iterator functions.
• B.Replace the default visuals with AppSource visuals.
• C.Change the imported dataset to DirectQuery.
• D.Remove unused columns from tables in the data model.

Comment: *

Name: *

Email: *

Verification: *