You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI

semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined

values and errors. You need to resolve the issue.

Solution: You add an index key and normalize casing in the data source.

Does this meet the goal?

You have a collection of reports for the HR department of your company.

You need to create a visualization for the HR department that shows a historic employee counts and predicts

trends during the next six months.

Which type of visualization should you use?

You are creating a visual to show the ranking of product categories by sales revenue. Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant Which approach provides the widest variety of visuals while adhering to the security policy?

You are creating a report in Power BI Desktop. You load a data extract that includes a free text field named coll. You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model. What should you do?

You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

The report will facilitate the following analysis: • The count of orders and the sum of total sales by Order Date • The count of customers who placed an order • The average quantity per order You need to reduce data refresh times and report query times. Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.