Download Analyzing and Visualizing Data with Microsoft Power BI.prep4sure.70-778.2018-12-14.1e.73q.vcex

You have a workspace that contains 10 dashboards. A dashboard named Sales Data displays data from two datasets. You discover that users are unable to find data on the dashboard by using natural language queries. 
You need to ensure that the users can find data by using natural language queries. 
What should you do?

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

You create a report in the Power BI service that displays the following visualizations:
A KPI that displays the count of customers 
A table that displays the count of customers by country 
A line chart that displays the count of customers by year 
You need to receive an alert when the total number of customers reaches 10,000. 
What should you do first?

You have a Power BI dashboard that displays different visualizations of company sales. 
You enable Q&A on the dashboard. 
You need to provide users with sample questions that they can ask when using Q&A. 
Which settings should you modify form the Power BI Settings?

You have an app workspace named Retail Store Analysis in the Power BI service. 
You need to manage the members that have access to the app workspace using the least amount of administrative effort. 
What should you do?

Your organization has a Microsoft Office 365 subscription. 
When the users attempt to access the Power BI Service, they receive the error message shown in the exhibit. (Click the Exhibit button.) 

  

You need to ensure that all the users can access the Power BI service. 
What should you do first?

You have a Microsoft Excel spreadsheet that contains a table named Sales. 
You need to add the Sales table to a Power BI dashboard as a tile. 
How should you configure the tile?

You are creating a report in Power BI Desktop. 
You are consuming the following tables. 

  

Date[Date] is in the mm/dd/yyyy format. Date[DateKey] is in the ddmmyyyy format. Date[MonthNumber] is in the mm format. Date[MonthName] is in the mmm format. 
You create the report shown in the exhibit. (Click the Exhibit button.) 

  

You need to ensure that the months appear in the order of the calendar. 
How should you sort the MonthName column?

You are creating a report in Power BI Desktop. 
You are consuming the following tables. 

  

You have a new table named Fiscal that has the same schema as the Date table, but contains the fiscal dates of your company. 
You need to create a report that displays the total sales by fiscal month and calendar month. 
What should you do?

You plan to create a Power BI report. You have the schema model shown in the exhibit.

  

The model has the following relationships:
Store to District based on DistrictID 
Sales to Store based on LocationID 
Sales to Date based on PeriodID 
Sales to Item based on ItemID 
You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage. 
When the district managers view the Store by Items report, they see items for all the stores. 
You need to ensure that the district managers can see items for the stores they manage only. 
How should you configure the relationship from Sales to Item?