Shortcuts To 70-778（3 to 12）

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

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

Q5. 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 u201cNAu201d else [Subcategory] Which command should you use in Query Editor?

A. Column From Examples

B. Custom Column

C. Invoke Custom Function

D. Conditional Column

Q6. You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace. What should you do?

A. From the Power BI Admin portal, click Usage metrics.

B. From the Office 365 Admin center, click Users.

C. From the Office 365 Admin center, click Groups.

D. From the Power BI Admin portal, click Tenant settings.

Q7. You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.

The reports display the data configured as shown in the following table.

You need to ensure that the users of the reports can locate the correct report by using natural language queries.

What should you do?

A. From the properties of the dataset, create four Featured Q&A Questions.

B. From the Format settings of the reports, modify the Page Information.

C. From the properties of the dataset, modify the Q&A and Cortana settings.

D. From the properties of the workspace, modify the Language Settings.

Q8. You have a Power BI dashboard that displays different visualizations of company sales.

You enable Q&A on the dashboard.

You need to provide users with sample questions that they can ask when using Q&A.

Which settings should you modify from the Power BI Settings?

A. Subscriptions

B. Dashboards

C. Datasets

D. Workbooks

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

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

Q11. Note: This question is a 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 have a query for a table named Sales. Sales has a column named CustomerID. The Data type of CustomerID is Whole Number.

You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.

You need to ensure that nonnumeric values in the CustomerID column are set to 0. Solution: From Query Editor, select the CustomerID column and click Remove Errors. Does this meet the goal?

A. Yes

B. No

Q12. Note: This question is a 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.

Your company has 1,000 users in a Microsoft Office 365 subscription.

A Power BI administrator named Admin1 creates 20 dashboards and shares them with 50 users.

You discover that a use name User1 can access all the dashboards. You need to prevent User1 from accessing all the dashboards.

Solution: From Microsoft Azure Active Directory, you remove the Power BI license from User1.

Does this meet the goal?

A. Yes

B. No