You have a customer service database that has a feedback score from 1 to 5. You create a dashboard with a card visual for the daily feedback score average. The CEO wants to receive an alert if the average score falls below 3.5.

How can he achieve this?

You receive the following requirements: “I want to show the correlation between Quantity and Unit Price. I would like each individual transaction to show on the chart.” Which visualization type would best display the required data?

What is meant by a Live connection in Power BI?

Which of the following is not a necessary step in order to configure row-level security on the Power BI Service?

Power BI’s Vertipaq Engine compresses the data loaded into Power BI to reduce model size and speed up report performance. Which of the following actions will have the largest positive impact on compression?

The RangeStart and RangeEnd parameters must be created in a Power BI Desktop file as the first step to set up incremental refresh.

What are the two options available in Power Query to combine multiple tables together?

If you want to combine two or more existing queries in the query editor together (with the same columns) as a one-off exercise, which of the following features would you use?

Imagine that a user creates an implicit measure in a Power BI report by averaging the Unit Price column. They then filter down the data to only show the Novelty Shop customer category. If you wanted to code this into a DAX measure, which of the following will produce the correct results?

A client requires near-Real time data displayed in their report. Choose the appropriate database connection type.