Font size
WorksheetsPL 300 Test
Total questions: 20
Worksheet time: 11mins
Which DAX expression should you use to get the ending balances in the balance sheet reports?
CALCULATE (
SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] )
CALCULATE (
SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] )
FIRSTNONBLANK ( 'Date' [Date]
SUM( BalanceSheet[BalanceAmount] )
)
CALCULATE (
MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] )
)
You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?
stacked area chart
donut chart
waterfall chart
line chart
Your department wants to see a single visual that explains the factors that contribute to revenue growth the most. Which visualization should you use?
Stacked column chart
Funnel chart
Key influencers
Decomposition tree
You have a Power BI tenant. You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted. What should you implement?
dataset certifications
row-level security (RLS)
Microsoft Intune policies
sensitivity labels
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
You have a report page named Sales which contains visual A, showing total sales for each city for the selected year, as shown in the exhibit.
You need to configure an interaction for this visual. When clicking Drill through, it should redirect to a detail page that shows Sales for the selected city by Product Line and will preserve all the filters from the Sales page.
Which four actions should you perform?
Each correct answer presents part of the solution.
On the Detail page, under the drill through option, add City column as the drill through field.
Create a table visual named Visual B to show total sales by city and product line.
On the Sales page, under the drill through option, add City column as the drill through field.
Create a new page named Detail.
On the Detail page, under the drill through option, set Keep all filters to On.
You have a dataset on the bulk orders your company received from across India via different Sales Channels. You have to create a transformation query for the No of days the bulk orders are received from each City and Sales channel. Which of the following options would you choose?
Create an Advanced Group by transform. And set the Group by operation to Count Rows
Create an Advanced Group by transform. And set the Group by operation to All Rows
Create a Basic Group by transform. And set the Group by operation to Count Distinct Rows
Create an Advanced Group by transform. And set the Group by operation to Count Distinct Rows
For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The data model contains several measures. You need to create a Power BI report from the existing data. The solution must minimize development effort. Which type of data source should you use?
Power BI Dataset
SharePoint Folder
Power BI Dataflow
Excel
A query operation that joins two existing tables based on matching values from one or more columns.
Join
Merge
Append
Group
You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?
Add a SQL statement.
Set the Command timeout in minutes setting.
Set Data Connectivity mode to Import.
Set Data Connectivity mode to DirectQuery.
If you have two queries that have different data but the same column headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform?
Append
Merge
Join
Combine
From the AdventureWorks Datawarehouse, you import the below tables into Power BI Desktop. You have to analyze Reseller Sales for each Sales Territory. How would you configure the relationship between Dim Geo and Dim Territory?
Many to one
Both
Many to one
Single
Many to many
Single
One to One
Single
If you want to create a measure that always calculates the total sales for 2015, regardless of which year is selected in any other visual in Power BI, you would create a measure
Total Sales for 2015 = SUM(CALCULATE('Sales OrderDetails'[Total Price]), YEAR('Sales OrderDetails'[orderdate]) = 2015)
Total Sales for 2015 = CALCULATE(SUM('Sales OrderDetails'[Total Price]), DATE('Sales OrderDetails'[orderdate]) = 2015)
Total Sales for 2015 = CALCULATE(SUM('Sales OrderDetails'[Total Price]), YEAR('Sales OrderDetails'[orderdate]) = 2015)
Total Sales for 2015 = CALCULATE(SUM('Sales OrderDetails'[Total Price]), YEAR('Sales OrderDetails'[Year]) = 2015)
Which of the following formulas would make the most sense as a calculated column?
=SUM(Sales[quantity])
=AVERAGE(Products[RetailsPrice])
=DISTINCOUNT(Customer[CustomerName])
=Products[RetailsPrices] * 0.75
What is the purpose of the following function:
=CALCULATE([Profit],Territories[Country]="USA")
Calculate a measure named "Profit" across the entire Territories table
Sums the "Profit" column for rows where Country = "USA"
Creates a new column named "Profit" which is calculated for all rows where country = "USA"
Evaluates the "Profits" measure for rows where Country = "USA" in the Territories table
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 egions. Each sales region 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?
You have a Power BI imported dataset that contains the data model shown in the following exhibit. 2- The data model is organized into a …........
You have the Power BI model shown in the following exhibit. There are four departments in the Departments table. You need to ensure that users can see the data of their respective department only. What should you do?
You have the Power BI data model shown in the following exhibit The Sales table contains records of sales by day from the last five years up until today’s date. You plan to create a measure to return the total sales of March 2021 when March 2022 is selected. Which DAX expression should you use?
You have a Microsoft Power BI 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 AppSource 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?
