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 change the semantic model mode. Does this meet the goal? 

You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection. You need to ensure that users can use Q&A from the Power BI service for the dataset. What should you do?

You have a Power B1 report named ReportA. You have a Power B1 tenant that allows users to export data. You need to ensure that consumers of ReportA cannot effort any data from visuals. Which two actions should you perform? Each correct answer presents a complete solution. NOTE Each correct selection is worth one point.

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?

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 Monthly_returns table and Date[Date_ID]. What should you do before you create the relationship?