You need to create a visual as shown in the following exhibit.

Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?

A.

video

B.

custom streaming data

C.

text box

D.

web content

In the Power BI service, you create an app workplace that contains several dashboards.
You need to provide a user named user1@contoso.com with the ability to edit and publish
dashboards.
What should you do?

A.

Modify the members of the app workspace.

B.

Configure security for the dataset used by the app.

C.

Share the dashboard, and then modify the Access settings of the dashboard.

D.

From the app workspace, click Update app, and then configure the Access settings

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 need to create a relationship between the Territory table and the Sales table.
Which function should you use in the query for Territory before you create the relationship?

A.

Table.RemoveMatchingRows

B.

Table.Distinct

C.

Table.InDistinct

D.

Table.ReplaceMatchingRows

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 are modeling data by using Microsoft Power Bl. Part of the data model is a large
Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order
table.
Solution: You write a DAX expression that uses the FILTER function.
Does this meet the goal?

A.

Yes

B.

No

You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

A.

SQL Server Profiler

B.

Performance Analyzer in Power BI Desktop

C.

Query Diagnostics in Power BI

D.

Microsoft Edge DevTools

You have a Power BI app named App1. The privacy for the App1 workspace is set to Private. A user named User1 reports that App1 does not appear in the My organization AppSource.
App1 appears in the My organization AppSource for your account.
You need to ensure that User sees App1 from the My organization AppSource.
What should you do?

A.

From the app workspace, click Update app, configure the Content settings, and then click Update app.

B.

From the app workspace settings, add a member.

C.

From the app workspace, click Update app, configure the Access setting, and then click Update app.

D.

From the app workspace, share the dashboard.

Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding
affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions
for each affiliate. You have a data model that contains the following tables.

You have the following three versions of an Azure SQL database:
Test
Production
Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between
the development, test, and production database servers from powerbi.com.
Which should you do?

A.

Create a JSON file that contains the database server names. Import the JSON file to the dataset.

B.

Create a parameter and update the queries to use the parameter.

C.

Create a query for each database server and hide the development tables.

D.

Set the data source privacy level to Organizational and use the ReplaceValue Power
Query M 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 add a Power Apps custom visual to the report.Does this meet the goal?

A.

Yes

B.

No