PBI Quiz 3

Which of the following filters are not available in Power BI reports?

• Drill-through

• Report level

• Page type

• Page level

How can you analyze performance of each of your report elements?

• By using performance analyzer.

• By analyzing your metadata.

• By deleting unnecessary rows and columns to reduce your dataset size.

Can you use bookmarks to create a slide show in Power BI?

• No, you cannot, because bookmarks are not dynamic.

• Yes, you can, by adding buttons as navigation to go between saved bookmarks.

• No, you will require a specific visual to achieve this task.

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.

You build a report analyzing the internal networks of employees based on whom they send emails to.

You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.

What should you do?

• Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

• Remove the Subject and Body columns during the import.

• From Model view, set the Subject and Body columns to Hidden.

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?

• Video

• Custom streaming data

• Text box

• Web content

You create a dashboard by using the Microsoft Power BI Service. The dashboard contains a card visual that shows total sales from the current year.

You grant users access to the dashboard by using the Viewer role on the workspace.

A user wants to receive daily notifications of the number shown on the card visual.

You need to automate the notifications.

What should you do?

• Create a data alert.

• Share the dashboard with the user.

• Create a subscription.

• Tag the user in a comment.

You have a line chart that shows the number of employees in a department over time.

You need to see the total salary costs of the employees when you hover over a data point.

What are two possible ways to achieve this goal?

• Add a salary to the tooltips.

• Add a salary to the visual filters.

• Add salary to the drill-through fields.

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.

You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.

How should the visual interactions be set on the column chart when the bar chart is selected?

• No impact

• Highlight

• Filter

You build a report to help the sales team understand its performance and the drivers of sales.

The team needs to have a single visualization to identify which factors affect success.

Which type of visualization should you use?

• Line and clustered column chart

• Key influencers

• Q&A

• Funnel chart

You have a dataset named Pens that contains the following columns: 'Unit Price', 'Quantity Ordered'.

You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.

Which type of visualization and which feature should you use?

(Answer should be formatted as 1. A/B/C; 2. A/B/C)