New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

Legit PL-300 Exam Download

Page: 3 / 13
Question 12

You build a Power Bl report that displays 10T temperature data streaming from a refrigerator.

You publish the report to the Bl service.

You need to be notified when the temperature rises above four degrees Celsius.

What should you do?

Options:

A.

Pin a report page to a dashboard and set an alert on the page.

B.

Set an alert on a KPI visual in the report.

C.

Pin a card visual to a dashboard and set an alert on the tile.

D.

Pin a card visual to a dashboard and create a subscription.

Question 13

You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month.

You need to create an ad analytics system to meet the following requirements:

    Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.

    Minimize the data model size.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

A.

Group the impressions by Ad_id, Site_name, and Impression_date.

Aggregate by using the CountRows function.

B.

Create one-to-many relationships between the tables.

C.

Create a calculated measure that aggregates by using the COUNTROWS function.

D.

Create a calculated table that contains Ad_id, Site_name, and Impression_date.

Question 14

You have a semantic model that has the permissions shown in the following exhibit.

Use the drop-down menus to select the answer choice the that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Options:

Question 15

You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:

    CustomerID

    Customer City

    Customer State

    Customer Name

    Customer Address 1

    Customer Address 2

    Customer Postal Code

The Invoice table contains the following fields:

    Order ID

    Invoice ID

    Invoice Date

    Customer ID

    Total Amount

    Total Item Count

The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.

The Power BI model must provide the following information:

    The number of customers invoiced in each state last month

    The average invoice amount per customer in each postal code

You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Page: 3 / 13
Exam Code: PL-300
Exam Name: Microsoft Power BI Data Analyst
Last Update: Dec 23, 2024
Questions: 386
PL-300 pdf

PL-300 PDF

$28.5  $94.99
PL-300 Engine

PL-300 Testing Engine

$33  $109.99
PL-300 PDF + Engine

PL-300 PDF + Testing Engine

$43.5  $144.99