Ace Your PL-300 Microsoft Certified: Power BI Data Analyst Associate Exam

You have the visual shown in the exhibit. (Click the Exhibit tab.)

You need to show the relationship between Total Cost and Total Sales over time.

What should you do?

You are creating reports in Power BI Desktop. The model has the following tables.

There is a relationship between the tables.

You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.

You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the dataset that is published.

How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a query that contains customer data in Power Query Editor as shown in the following exhibit.

You have an Azure SQL database that contains sales transactions. The database is updated frequently.

You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.

How should you configure the data connection?