PL-300 Practice Exam Questions and Answers

A.  

an additional date table named ShipDate, a one-to-many relationship fromSales[sales_date_id] to Date[date_id], and a one-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

B.  

an additional date table named ShipDate, a many-to-many relationship fromSales[sales_date_id] to Date[date_id], and a many-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

C.  

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

D.  

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-manyrelationship from Sales[sales_ship_date_id] to Date[date_id]

E.  

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

A.  

Create a security role that has a table filter on the Sales_Manager table whereusername = UserName()

B.  

Create a security role that has a table filter on the Region_Manager table wheresales_manager_id = UserPrincipalName().

C.  

Create a security role that has a table filter on the Sales_Manager table wherename = UserName().

D.  

Create a security role that has a table filter on the Sales_Manager table whereusername = sales_manager_id.

A.  

FORMAT('Date'[date], "MMM YYYY")

B.  

FORMAT('Date' [date], "M YY")

C.  

FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")

D.  

FORMAT('Date' [date_id], "MMM YYYY")

A.  

import that uses a Microsoft account

B.  

DirectQuery that uses the end-user s credentials

C.  

DirectQuery that uses a database credential

D.  

Import that uses a database credential

A.  

Apply row-level security (RLS) to the Region table based on the sales manager username.

B.  

Configure a bi-directional relationship between Region and Sales.Region.

C.  

Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.

D.  

In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

A.  

One to one

B.  

Many to one

C.  

One to many

D.  

Many to many

A.  

two imported datasets

B.  

a single DirectQuery dataset

C.  

two DirectQuery datasets

D.  

a single imported dataset

A.  

Select Column distribution.

B.  

Select the sales_amount column and apply a number filter.

C.  

Select Column profile, and then select the sales_amount column.

D.  

Transform the sales_amount column to replace negative values with 0.