Q4. You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category.

You need to ensure that when you select a year on the bar chart, the donut remains unchanged.

What should you do?

A. Set a visual level filter on the bar chart.

B. Edit the interactions form the Format menu.

C. Set a visual level filter on the donut chart.

D. Add a slicer to the page that uses the year column.

View Answer

Q5. You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular named SalesDB in Microsoft SQL Server Analysis Services (SSAS). The report will be published to the Power BI service.

You need to ensure that the report published to the Power BI service will access the current data in SalesDB.

What should you do?

A. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Import Data Connectivity mode.

B. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live option.

C. Deploy an on-premises data gateway (personal mode) and configure to SalesDB to use the DirectQuery Data Connectivity mode.

D. Deploy an on-premises data gateway and configure the connection to SalesDB to use the DirectQuery Data Connectivity mode.

View Answer

Q6. 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 measure to rank total sales by product. The results must appear as shown in the following table.

Which DAX formula should you use?

A. Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)

B. Product Ranking= RANKX (ALL, (u2021Productu2021), [SalesAmount], , DESC, Dense)

C. Product Ranking= RANKX (ALL, (u2021Productu2021), [SalesAmount], , DESC, Skip)

D. Product Ranking= RANKX (ALL (u2021Productu2021), [SalesAmount], , Asc, Dense

View Answer

Q7. 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. From the app workplace, click Update app, and then configure the Access settings.

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

C. Configure security for the dataset used by the app.

D. Modify the members of the app workspace.

View Answer

Q8. You have a table named Sales. A sample of the data in Sales is shown in the following table.

You created a stacked column chart visualization that displays ProductName by Date. You discover that the axis for the visualization displays all the individual dates.

You need to ensure that the visualization displays ProductName by year and that you can drill down to see ProductName by week and day.

What should you do first?

A. Configure a visual filter for the Date column that uses an advanced filter.

B. Create a new table that has columns for the date, year, week, and day.

C. Create a new hierarchy in the Sales table.

D. Format the virtualization and set the type of the X-Axis to Categorical.

View Answer

Q9. You have a Power BI report that is configured to use row-level security (RLS).

You have the following roles:

u2711 A manager role that limits managers to see only the sales data from the stores they manage.

u2711 A region role that limits users to see only the data from their respective region

You plan to use Power BU Embedded to embed the report into an application. The application will authenticate the users.

You need to ensure that RLS is enforced when accessing the embedded report. What should you do?

A. In the access token for the application, include the user name and the role name.

B. In the access token for the application, include the report URL and the Microsoft Azure Active Directory Domain name.

C. From dev.powerbi.com/apps, register the new application and enable the Read All Reports API access.

D. From dev.powerbi.com/apps, register the new application and enable the Read All Groups API access.

View Answer

Q10. 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.

View Answer

Q11. Your organization has a team of power users who recently created 20 Power BI dashboards.

The power users share the dashboards with other users in the organization.

When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

You need to ensure that all the users can access the dashboards. What should you do first?

A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

B. From the Power BI Admin portal, modify the Privacy Settings.

C. From the properties of each dashboard, modify the Share dashboard settings.

D. Instruct each user to install Microsoft Office 2021.

View Answer

Q12. You plan to use Power BI Desktop optimized for Power BI Report Server to create a report.

The report will be published to Power BI Report Server.

You need to ensure that all the visualization in the report can be consumed by users. Which two types of visualizations should you exclude from the report? Each correct answer

presents part of the solution.

NOTE: Each correct selection is worth one point.

A. Funnel charts

B. Custom visuals

C. Bubble maps

D. Breadcrumbs

E. R visuals

View Answer

Q13. You have an on-premises Power BI Report Server.

You plan to create a report in Power BI Desktop and publish the report to the report server. Which data source should the report use?

A. Microsoft Azure SQL Database

B. a Microsoft SQL Server database

C. a Microsoft SQL Server Analysis Services (SSAS) database

D. Microsoft Excel

View Answer