Microsoft PL-300 Practice Test - Questions Answers, Page 5
List of questions
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?
Create a horizontal line that has a fixed value of 24,000.
Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)
Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
Add a measure to the visual that uses the following DAX expression.
Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
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?
area chart
donut chart
scatter plot
pie chart
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?
scatter chart
ribbon chart
line chart
key influences
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?
Add a play axis.
Add a slicer for the year.
From the Analytics pane, add an Average line.
Create a DAX measure that calculates year-over-year growth.
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?
Key influences
Funnel chart
Q&A
Line and clustered column chart
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?
Merge tables by using Power Query.
Hide unused columns in the model.
Split the model into multiple models.
Transpose.
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?
SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),
SAMEPERIODLASTYEAR('Date'[DateID])
(SUM(‘Sales’[sales_amount]) - CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))) / CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))
CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID]))
CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))
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?
one-to-many from Customer to Transaction
one-to-one between Customer and Transaction
one-to-many from Transaction to Customer
many-to-many between Customer and Transaction
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?
Add a description of "subscriber count" to the Customer Count measure.
Set Summarize By to None for the CustomerlD column.
Add a description of "Subscriber" to the Customer table.
Add a synonym of "subscriber" to the Customer table.
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?
Split the visuals onto multiple pages.
Implement row-level security (RLS).
Replace the default visuals with custom visuals.
Increase the number of times that the dataset is refreshed.
Question