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 part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: You modify the source step of the queries to use DataSourceExcel as the file path.

Does this meet the goal?

A. Yes

B. No

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?

A. Use default visuals or custom visuals uploaded from a .pbiviz file.

B. Use only default visuals.

C. Use default or any custom visuals from the marketplace.

D. Use default or certified custom visuals.

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.