ExamGecko
Home Home / Microsoft / PL-300

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

Question list
Search
Search

List of questions

Search

Related questions











You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

A.

Create a horizontal line that has a fixed value of 24,000.

A.

Create a horizontal line that has a fixed value of 24,000.

Answers
B.

Add a measure to the visual that uses the following DAX expression.

Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)

B.

Add a measure to the visual that uses the following DAX expression.

Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)

Answers
C.

Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

C.

Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

Answers
D.

Add a measure to the visual that uses the following DAX expression.

Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

D.

Add a measure to the visual that uses the following DAX expression.

Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Answers
Suggested answer: C

Explanation:

The analytics feature enables you to show percentiles across groups specified along a specific axis. Example:

1. Click on the analytics tab

2. Select Percentile

3. You can choose a specific percentile along with other formatting options.

4. Drag a date or non-numeric dimension into the Axis of a column chart

Add percentile lines to monitor daily revenue

You have a table that contains sales data and approximately 1,000 rows.

You need to identify outliers in the table. Which type of visualization should you use?

A.

area chart

A.

area chart

Answers
B.

donut chart

B.

donut chart

Answers
C.

scatter plot

C.

scatter plot

Answers
D.

pie chart

D.

pie chart

Answers
Suggested answer: C

Explanation:

Outliers are those data points that lie outside the overall pattern of distribution & the easiest way to detect outliers is though graphs. Box plots, Scatter plots can help detect them easily.

Reference:

https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plotsusing-the-microsoft-power-bi-d7ad16ac9ccc

You have a collection of reports for the HR department of your company.

You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months. Which type of visualization should you use?

A.

scatter chart

A.

scatter chart

Answers
B.

ribbon chart

B.

ribbon chart

Answers
C.

line chart

C.

line chart

Answers
D.

key influences

D.

key influences

Answers
Suggested answer: C

Explanation:

The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart has to have only one line. Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.

Reference:

https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-viewfor-office-365

You have the visual shown in the exhibit. (Click the Exhibit tab.)

You need to show the relationship between Total Cost and Total Sales over time.

What should you do?

A.

Add a play axis.

A.

Add a play axis.

Answers
B.

Add a slicer for the year.

B.

Add a slicer for the year.

Answers
C.

From the Analytics pane, add an Average line.

C.

From the Analytics pane, add an Average line.

Answers
D.

Create a DAX measure that calculates year-over-year growth.

D.

Create a DAX measure that calculates year-over-year growth.

Answers
Suggested answer: A

Explanation:

You can set up a date field in play axis, and then scatter chart will animate how measure values are compared to each other in each point of a time.

Reference:

https://radacad.com/storytelling-with-power-bi-scatter-chart

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

A.

Key influences

A.

Key influences

Answers
B.

Funnel chart

B.

Funnel chart

Answers
C.

Q&A

C.

Q&A

Answers
D.

Line and clustered column chart

D.

Line and clustered column chart

Answers
Suggested answer: A

Explanation:

The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers. The key influencers visual is a great choice if you want to:

See which factors affect the metric being analyzed.

Contrast the relative importance of these factors. For example, do short-term contracts have more impact on churn than long-term contracts?

Reference:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.

What should you recommend?

A.

Merge tables by using Power Query.

A.

Merge tables by using Power Query.

Answers
B.

Hide unused columns in the model.

B.

Hide unused columns in the model.

Answers
C.

Split the model into multiple models.

C.

Split the model into multiple models.

Answers
D.

Transpose.

D.

Transpose.

Answers
Suggested answer: A

Explanation:

Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query. When you have one or more columns that you’d like to add to another query, you merge the queries.

Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression. CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

You have a sales system that contains the tables shown in the following table.

The Date table is marked as a date table.

DatelD is the date data type. You need to create an annual sales growth percentage measure.

Which DAX expression should you use?

A.

SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),

SAMEPERIODLASTYEAR('Date'[DateID])

A.

SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),

SAMEPERIODLASTYEAR('Date'[DateID])

Answers
B.

(SUM(‘Sales’[sales_amount]) - CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))) / CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

B.

(SUM(‘Sales’[sales_amount]) - CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))) / CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

Answers
C.

CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID]))

C.

CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID]))

Answers
D.

CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

D.

CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))

Answers
Suggested answer: B

Explanation:

SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.

Reference:

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.

Which relationship should you use to link the tables?

A.

one-to-many from Customer to Transaction

A.

one-to-many from Customer to Transaction

Answers
B.

one-to-one between Customer and Transaction

B.

one-to-one between Customer and Transaction

Answers
C.

one-to-many from Transaction to Customer

C.

one-to-many from Transaction to Customer

Answers
D.

many-to-many between Customer and Transaction

D.

many-to-many between Customer and Transaction

Answers
Suggested answer: A

Explanation:

Each customer can have many transactions.

For each transaction there is exactly one customer.

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure. Customer Count = DISTINCTCOUNT(Customer[CustomerID])

Users frequently refer to customers as subscribers.

You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model. What should you do?

A.

Add a description of "subscriber count" to the Customer Count measure.

A.

Add a description of "subscriber count" to the Customer Count measure.

Answers
B.

Set Summarize By to None for the CustomerlD column.

B.

Set Summarize By to None for the CustomerlD column.

Answers
C.

Add a description of "Subscriber" to the Customer table.

C.

Add a description of "Subscriber" to the Customer table.

Answers
D.

Add a synonym of "subscriber" to the Customer table.

D.

Add a synonym of "subscriber" to the Customer table.

Answers
Suggested answer: B

Explanation:

You can add synonyms to tables and columns.

Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.

This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.

Reference:

https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 custom visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report. What should you recommend?

A.

Split the visuals onto multiple pages.

A.

Split the visuals onto multiple pages.

Answers
B.

Implement row-level security (RLS).

B.

Implement row-level security (RLS).

Answers
C.

Replace the default visuals with custom visuals.

C.

Replace the default visuals with custom visuals.

Answers
D.

Increase the number of times that the dataset is refreshed.

D.

Increase the number of times that the dataset is refreshed.

Answers
Suggested answer: A
Total 370 questions
Go to page: of 37