Home / Microsoft / PL-300

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

Question list

List of questions

Question 61

(0)

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of

Question 62

(0)

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two action

Question 63

(0)

You have a Microsoft Power Bl dashboard. You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard. What should you use?

Question 64

(0)

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturi

Question 65

(0)

You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the

Question 66

(0)

You import a large dataset to Power Query Editor. You need to identify whether a column contains only unique values. Which two Data Preview options can you use? Each correct answer presents a comp

Question 67

(0)

Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains emplo

Question 68

(0)

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 q

Question 69

(0)

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date. You need to reduce the size of the data model. What should you do?

Question 70

(0)

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report ana

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 61

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company. You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data. Which report setting should you configure?

Don't allow end user to save filters on this report.

Change default visual interaction from cross highlighting to cross filtering.

Enable the updated filter pane, and show filters in the visual header for this report.

Allow users to add comments to this report.

Choose the type of data you allow your end users to export.

Show Answer Comment (0)

Question 62

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Add the same slicer to each page and configure Sync slicers.

Edit the interactions of the KPI visualization.

Configure a page-level filter.

Edit the interactions of the slicer that is on the same page as the KPI visualization.

Configure a report-level filter.

Show Answer Comment (0)

Question 63

You have a Microsoft Power Bl dashboard.

You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard. What should you use?

Feedback

Comments

Mark as favorite

Show Answer Comment (0)

Question 64

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to load only the manufacturing reports to a table for analysis.

What should you do in Microsoft Power Bl Desktop?

Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.

Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

Show Answer Comment (0)

Question 65

You create the following step by using Power Query Editor.

= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

1318

1319

21318 Lasalle Street

21319 Lasalle Street

Show Answer Comment (0)

Question 66

You import a large dataset to Power Query Editor.

You need to identify whether a column contains only unique values.

Which two Data Preview options can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point

Show whitespace

Column distribution

Column profile

Column quality

Monospaced

Show Answer Comment (0)

Question 67

Your company has employees in 10 states.

The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state.

You need to view the employees by region as quickly as possible.

What should you do?

Create a new aggregation that summarizes by employee.

Create a new group on the state column and set the Group type to List.

Create a new group on the state column and set the Group type to Bin.

Create a new aggregation that summarizes by state.

Show Answer Comment (0)

Question 68

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?

=Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".

Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")

= Table.Unpivot(Source, {"classes"}, "Attribute", "Value")

= Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),

{"classes.1"})

= Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

Show Answer Comment (0)

Question 69

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date. You need to reduce the size of the data model.

What should you do?

Round the hour of the Date column to startOfHour.

Change the data type of the Date column to Text.

Trim the Date column.

Split the Date column into two columns, one that contains only the time and another that contains only the date.

Show Answer Comment (0)

Question 70

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to.

You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?

Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Remove the Subject and Body columns during the import.

From Model view, set the Subject and Body columns to Hidden.

Show Answer Comment (0)

Total 370 questions

5 6 7 8 9

Go to page: of 37