You are developing a sales report that will have multiple pages. Each page will answer a different business question.

You plan to have a menu page that will show all the business questions.

You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.

What should you include on the menu page?

A. Create a text box for each business question and insert a link.

B. Create a button for each business question and set the action type to Bookmark.

C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.

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:

1.

Date[Month] in the mmyyyy format

2.

Date[Date_ID] in the ddmmyyyy format

3.

Date[Date_name] in the mm/dd/yyyy format

4.

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 Order table and the Store table on the Store_ID column.

What should you do before you create the relationship?

A. In the Order table query, use the Table.TrasformRows function.

B. In the Store table query, use the Table.TrasformRows function.

C. In the Store table query, use the Table.TrasformColumnTypes function.

D. In the Order table query, use the Table.TrasformColumnTypes function.

Note: This question is a part of a series of questions that present 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

exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015.

Product Subcategory [Subcategory] contains NULL values.

End of repeated scenario.

You implement the Power BI model.

You need to add a new column to the Product Subcategory table that uses the following formula.

=if [Subcategory] =null then "NA" else [Subcategory]

Which command should you use in Query Editor?

A. Column From Examples

B. Custom Column

C. Invoke Custom Function

D. Conditional Column

You are creating a dashboard by using the Power Bl service.

You have an existing report page that contains three charts.

You need to add the charts to the dashboard while maintaining the interactivity between the charts.

What should you do?

A. Pin each chart as a tile.

B. Edit interactions in the report and set all interactions to Filter

C. Edit the dashboard theme and pin each chart as a file.

D. Pin the report page as a live tile.

HOTSPOT

You have the Azure SQL databases shown in the following table.

You plan to build a single PBIX file to meet the following requirements:

1.

Data must be consumed from the database that corresponds to each stage of the development lifecycle.

2.

Power Bl deployment pipelines must NOT be used.

3.

The solution must minimize administrative effort.

What should you do? To answer, select the appropriate options in the answer area.

Hot Area: