March Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia

PL-300 Sample Questions Answers

Questions 4

Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.

You need to shape the query to display the following three columns:

* Month

* Sales

* Year

‘What should you select in Power Query Editor?

Options:

A.

Pivot column

B.

Merge columns

C.

Unpivot columns.

D.

Transpose

Buy Now
Questions 5

You plan to use Power BI to create a quarterly profit report that meets the following requirements:

• Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage

• Compares profit margins across sales regions

Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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.

Options:

Buy Now
Questions 6

You are creating a column chart visualization.

You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)

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

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 7

You have the dashboard shown in the following exhibit.

You need to modify the dashboard to display as shown in the following exhibit.

What should you do?

Options:

A.

Create and apply a custom dashboard theme.

B.

Change the colors of the visuals in the report.

C.

Apply the Dark dashboard theme.

D.

Upload a snapshot image of the dashboard.

Buy Now
Questions 8

You have more than 100 published datasets.

Ten of the datasets were verified to meet your corporate quality standards.

You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets.

What should you do?

Options:

A.

Publish the datasets in an app.

B.

Promote the datasets.

C.

Feature the dataset on the home page.

D.

Certify the datasets.

Buy Now
Questions 9

You need to create a Power Bl theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart

formatting.

What should you do?

Options:

A.

Create a theme as a PBIVIZ file and import the theme into Power Bl Desktop.

B.

Create a theme as a JSON file and import the theme into Power Bl Desktop.

C.

From Power Bl Desktop, use a built-in report theme.

D.

From Power Bl Desktop, customize the current theme.

Buy Now
Questions 10

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.

Buy Now
Questions 11

You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.

You have a Power Bl dashboard named DashboardA that has Q&A enabled.

You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to DashboardA. The solution must minimize development time.

Which three 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.

Options:

Buy Now
Questions 12

You have a Power Bl report named Orders that supports the following analysis:

• Total sales over time

• The count of orders over time

• New and repeat customer counts

The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit.

Options:

Buy Now
Questions 13

You use Power Query Editor to preview customer feedback data.

You need to use Al Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:

• What the customers most often provide feedback about

• Whether the customers like your company’s product

• The language of the feedback

Which Al Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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.

Options:

Buy Now
Questions 14

You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.

What should you do?

Options:

A.

Add a Top N filter to the visual.

B.

Configure the Sales Profit measure to use the RANKX function.

C.

Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.

D.

Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the

calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.

Buy Now
Questions 15

You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?

Options:

A.

decomposition tree

B.

Q&A

C.

smart narrative

D.

key influences

Buy Now
Questions 16

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables.

The auto date/time option for the data model enabled.

You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

Which two actions should you perform?

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Buy Now
Questions 17

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You assign all the users the Viewer role to the workspace.

Does this meet the goal?

Options:

A.

Yes

B.

No

Buy Now
Questions 18

Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015.

Product Subcategory [Subcategory] contains NULL values.

End of repeated scenario.

You implement the Power BI model.

You need to edit the Product Category table query to match the desired Power BI model.

How should you complete the advanced query? 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 frag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 19

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?

Options:

A.

Round the hour of the Date column to startOfHour.

B.

Change the data type of the Date column to Text.

C.

Trim the Date column.

D.

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

Buy Now
Questions 20

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.

Options:

A.

Sync the slicers across the pages.

B.

Replace the slicers with page-level filters.

C.

Replace the slicers with visual-level filters.

D.

Create a bookmark for each slicer value.

E.

Replace the slicers with report-level filters.

Buy Now
Questions 21

The data model must support the following analysis:

  • Total sales by product by month in which the order was placed
  • Quantities sold by product by day on which the order was placed
  • Number Of sales transactions by quarter in Which the order was placed

For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.

Options:

Buy Now
Questions 22

You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.

You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.

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

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 23

You plan to use Power B1 to create sales invoices for customers. The solution must meet the following requirements:

• Sales invoices must be exported in a PDF format

• The PDF exports must show all columns and rows clearly.

What should you create?

Options:

A.

a paginated report that contains a table

B.

an interactive report that contains a matrix

C.

a dashboard that contains a table

D.

an inlet active report that contains a table

Buy Now
Questions 24

You have a Power BI workspace named BI Data that contains a dataset named BI Finance.

You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace,

You need to connect to BI Finance and create a report.

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

NOTE: Each correct selection is worth one point.

Options:

A.

From the Power BI service, create a dataflow to the dataset by using DirectQuery.

B.

From Power BI Desktop, connect to a Dataverse data source.

C.

From the Power BI service, create a new report and select a published dataset

D.

From Power Bl Desktop, connect to a shared dataset

Buy Now
Questions 25

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?

Options:

A.

Active Directory groups

B.

tiles

C.

data classifications

D.

comments

Buy Now
Questions 26

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.

You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.

What should you recommend?

Options:

A.

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.

B.

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

C.

Create a workspace for development and a workspace for production. From the production workspace,

publish an app.

D.

In one 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.

Buy Now
Questions 27

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?

Options:

A.

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.

B.

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.

C.

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

D.

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

Buy Now
Questions 28

You have the data lineage 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.

Options:

Buy Now
Questions 29

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 30

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

Options:

A.

Change lite OrderlD column in the Orders table to the text data type.

B.

Filter out discontinued products while importing the Product table.

C.

Remove the QuantityPerUnit column from the Products table

D.

Group the Categories table by the CategorylD column.

Buy Now
Questions 31

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

Options:

A.

bar chart

B.

scatterplot

C.

pie chart

Buy Now
Questions 32

You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

Options:

A.

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.

B.

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

C.

From Power Bl Desktop, use the Auto date/time option when creating the reports.

D.

From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

Buy Now
Questions 33

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.

Options:

Buy Now