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

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
Note: Each correct selection is worth one point.

Correct Answer:

Explanation:
Graphical user interface, text Description automatically generated with medium confidence

Comment: *

Name: *

Email: *

Verification: *

You need to create a visualization to meet the reporting requirements of the sales managers.
HOW Should create the Visualization? TO answer, select the appropriate options in the answer are a.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?

• A.Add a Top N filter to the visual.
• B.Configure the Sales Profit measure to use the RANKX function.
• C.Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
• D.Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
  D18912E1457D5D1DDCBD40AB3BF70D5D

Comment: *

Name: *

Email: *

Verification: *

You manage a Power BI model has a table named Sales and product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?

• A.From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= "United States" && [ProductCategory]= "Clothing"
• B.Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing
• C.From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]=
  "United States"
• D.Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

Comment: *

Name: *

Email: *

Verification: *

You have the following three versions of an Azure SQL database:
* Test
* Production
* Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?

• A.Create a query for each database server and hide the development tables.
• B.Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
• C.Create a parameter and update the queries to use the parameter.
• D.Create a JSON file that contains the database server names. Import the JSON file to the dataset.

Comment: *

Name: *

Email: *

Verification: *