1)

What data file type can you access only with Power BI Desktop and not Power BI service?

Select an answer:

• SQL

• Excel

• CSV

• XML

2)

When you pin a visualization from a report to a dashboard, what does the visualization become?

Select an answer:

• a tile

• a data field

• a filter

• a link

3)

Suppose your report is going to be used in a PowerPoint presentation at the national sales meeting. With that in mind, what should be the most important consideration when you are creating your report?

Select an answer:

• how to have charts rather than tables appear on different pages

• how you are going to group elements on a page

• how long it will take to export your report to PowerPoint

• how many visualizations you can fit on a PowerPoint page

4)

When you edit interactions, you choose to not have the data filtered. Once you stop editing the interactions, what happens when a user selects an item?

Select an answer:

• The charts change, but the tables do not change.

• The tables change, but the charts do not change.

• The tables and charts redisplay, but nothing changes.

• The inability to filter is displayed as an error message.

5)

What must you do if you want users to see a tile using a QR code you shared with them?

Select an answer:

• Create the QR code on a printed item, not on a presentation screen.

• Open the tile in Focus Mode, and then select Generate QR code.

• Share the report with the users whom you want to see the tile.

• Share your dashboard with users whom you want to see the tile.

6)

You found a thermometer in the Marketplace that you think will add more value to your visualizations than the gauge you are using. Which values will you have when you add the thermometer?

Select an answer:

• All the values contained in the Visualizations pane in Power BI.

• The values that are included in the thermometer you add from the Marketplace.

• The values that were in the gauge you used before you downloaded the thermometer.

• All the values in the Fields list generated from the dataset you used.

6)

You have a slicer and a chart on the same page for your sales data by state. If you use the menu to sort by territory in alphabetical order, what effect will that have on the slicer and the chart?

Select an answer:

• Everything on the page will be sorted alphabetically by territory.

• Only text items will be sorted alphabetically by territory, but chart items must be sorted separately.

• The chart will be sorted alphabetically by territory, but the slicer will be unchanged.

• The slicer will be sorted alphabetically by territory, but the chart will be unchanged.