Home / Microsoft / PL-300

Microsoft PL-300 Practice Test - Questions Answers, Page 6

Question list

List of questions

Question 51

(0)

You have four sales regions. Each region has multiple sales managers. You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role. You have sales

Question 52

(0)

You have five sales regions. Each region is assigned a single salesperson. You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales tr

Question 53

(0)

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ens

Question 54

(0)

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl. You need to recommend an application lifecycle strategy.

Question 55

(0)

You are creating a visual to show the ranking of product categories by sales revenue. Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant Which

Question 56

(0)

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the E

Question 57

(0)

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all

Question 58

(0)

You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users ca

Question 59

(0)

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using th

Question 60

(0)

You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). T

Related questions

Adding an index key and normalizing casing in the data source would help resolve issues with undefined values and errors in a case-sensitive column. The index key can provide a unique identifier, and normalizing casing ensures consistency in the data, which would likely prevent the errors you encountered in the Power BI semantic model. You have a Power BI data model that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys. * Due Date * Order Date * Delivery Date You need to support the analysis of sales over time based on all three dates at the same time. Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the inactive relationships between sales table and the date table. Does this meet the goal?

You have a Power BI data model that contains a table named Employees. The table has the following columns: * Employee Name * Email Address * Start Date * Job Title You are implementing dynamic row-level security (RLS). You need to create a table filter to meet the following requirements: * Users must see only their own employee data * The DAX expression must work in both Power 81 Desktop and the Power BI service. Which expression should you use?

You need to create relationships to meet the reporting requirements of the customer service department. What should you create?

You are profiling data by using Power Query Editor. You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is shown in the following exhibit. 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.

You have a query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you use in the query?

HOTSPOT 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.

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

DRAG DROP You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent. How should you complete the calculation? To answer, drag the appropriate values to the correct targets. 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.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys: * Due Date * Order Date * Delivery Date You need to support the analysis of sales over time based on all three dates at the same time. Solution; You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table. Does this meet the goal?

You have a Power Bl report that contains a page. The page contains the following: • A shape named Shape 1 • A card named Sales Summary • A clustered bar chart named Sales by Region You need to ensure that Sales Summary renders on top of Shape 1. What should you modify?

Question 51

You have four sales regions. Each region has multiple sales managers.

You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role. You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions. A sales manager changes to a different region.

You need to ensure that the sales manager can see the correct sales data.

What should you do?

From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.

Change the Microsoft Power Bl license type of the sales manager.

Manage the permissions of the underlying dataset

Request that the sales manager be added to the correct Azure Active Directory group.

Show Answer Comment (0)

Question 52

You have five sales regions. Each region is assigned a single salesperson.

You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson. Salespeople must see only the data from their region.

You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople. A salesperson reports that she believes she should see more data.

You need to verify what data the salesperson currently sees.

What should you do?

Use the Test as role option to view data as the salesperson's user account.

Use the Test as role option to view data as the Sales role.

Instruct the salesperson to open the report in Microsoft Power Bl Desktop.

Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

Show Answer Comment (0)

Question 53

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.

Publish the reports to a different workspace other than the one hosting the datasets.

Publish the reports in an app and grant the HR managers access permission.

Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Show Answer Comment (0)

Question 54

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl. You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end users from viewing the development assets. What should you recommend?

Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.

In the same workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.

Create separate workspaces for development and production. Grant the end users access to the production workspace.

Create one workspace for development. From the workspace, publish an app for production.

Show Answer Comment (0)

Question 55

You are creating a visual to show the ranking of product categories by sales revenue.

Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant Which approach provides the widest variety of visuals while adhering to the security policy?

Use default visuals or custom visuals uploaded from a .pbiviz file.

Use only default visuals.

Use default or any custom visuals from the marketplace.

Use default or certified custom visuals.

Show Answer Comment (0)

Question 56

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

A user pressed F5

A new transaction was added to the data source.

A user added a comment to a tile.

The dashboard tile cache refreshed.

Show Answer Comment (0)

Question 57

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Sync the slicers across the pages.

Replace the slicers with page-level filters.

Replace the slicers with visual-level filters.

Create a bookmark for each slicer value.

Replace the slicers with report-level filters.

Show Answer Comment (0)

Question 58

You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order. What should you configure in Microsoft Power Bl Desktop?

the bookmark order

the layer order

the tab order

the X position

Show Answer Comment (0)

Question 59

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?

Share the dashboard to the user.

Create a subscription.

Create a data alert.

Tag the user in a comment.

Show Answer Comment (0)

Question 60

You have multiple dashboards.

You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?

Active Directory groups

tiles

data classifications

comments

Show Answer Comment (0)

Total 370 questions

4 5 6 7 8

Go to page: of 37