PL 300 Test

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.