Weekend Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

PL-300 Questions and Answers

Question # 6

You publish the dataset to powerbi.com.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Full Access
Question # 7

You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

A.

Create a column by example that starts with 2018-12-31.

B.

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date

C.

Apply the parse function from the Date transformations options to the Logged column.

D.

Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

Full Access
Question # 8

You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 9

A manager can represent only a single country.

You need to use row-level security (RLS) to meet the following requirements:

The managers must only see the data of their respective country.

The number of RLS roles must be minimized.

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.

B.

Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.

C.

For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

D.

Create one role for each country.

E.

For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

Full Access
Question # 10

You have a Power BI model that contains a table named Sales. Sales has the following three measures:

    A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.

    A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.

    A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] – Sales[This Year].

You need to create the following visualization.

How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Full Access
Question # 11

Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:

    Access a published Power BI app

    Modify reports in an app workspace

    Share dashboards created in My Workspace

You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.

Which license should you identify for each task? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 12

You use Power 81 Desktop to load data from a Microsoft SQL Server database.

While waiting for the data to load, you receive the following error.

You need to resolve the error.

What are two ways to achieve the goal? Each correct answer presents a complete solution

NOTE: Each correct selection is worth one point.

A.

Split long running queries into subsets Of columns and use power Query to the queries

B.

Disable query folding on long running queries

C.

Reduce number of rows and columns returned by each query.

D.

Use Power Query to combine long running queries into one query.

Full Access
Question # 13

You plan to create a report that will display sales data from the last year for multiple regions

You need to restrict access to individual rows of the data on a per region-basis by using roles.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Full Access
Question # 14

You need to create the dataset. Which dataset mode should you use?

A.

DirectQuery

B.

Import

C.

Live connection

D.

Composite

Full Access
Question # 15

You need to create a solution to meet the notification requirements of the warehouse shipping department.

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

NOTE: Each correct select is worth one point:

Full Access
Question # 16

You need to create a relationship in the dataset for RLS.

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 17

You need to minimize the size of the semantic model. The solution must meet the report requirements.

What should you do?

A.

Filter out discontinued products while importing the Products table.

B.

Group the Categories table by the CategorylD column.

C.

Change the OrderlD column in the Orders table to the Text data type.

D.

Remove the QuantityPerUnit column from the Products table.

Full Access
Question # 18

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

A.

Add the sales department as a member of the reports workspace

B.

Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

C.

Distribute an app to the users in the Azure Active Directory group of the sales department.

D.

Share each report to the Azure Active Directory group of the sales department.

Full Access
Question # 19

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 20

You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access