Free Microsoft PL-300 Exam Questions

You have a Power Bl report that will be rendered on a vertical display. You need to maximize the portion of the screen area used by the report. What should you do?

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?

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 historical employee counts and predicts trends during the next six months. Which type of visualization should you use?

What is the minimum number of datasets and storage modes required to support the reports?