PL-300 Exam – Practice 3

You have a time series chart for your sales and you need to display a line to show the direction the data has moved over your selected period.
How would you add this black dotted line? See the exhibit below.

Your company is considering Power BI Report Server and you are asked if certain features are available.
Which of the following three features are NOT available in Power BI Report Server?

You work at a bike company and have two tables that use DirectQuery – Product and Category (see the below exhibit.) These two tables are joined with a relationship from Product to Category using the CategoryID column. To increase the efficiency in your join you decide to check "Assume referential integrity" in the relationship.
Will this help the join between your tables?

You are designing a data model and have a Date table and a Sales table as per the below exhibit. You create an active relationship between Date[Date] and Sales[Delivery Date]. You also create an inactive relationship between Date[Date] and Sales[Order Date].
How would you create a measure with the inactive Order Date by filling in the correct DAX function in [VALUE]?
CALCULATE (
[Sales Amount],
[VALUE] ( Sales[Delivery Date], ‘Date‘[Date] )
)

You are a Power BI consultant and you are doing some remote work for a mining company in Western Australia. You need to build a date table that starts from November 2010 and ends in December 2025. You decide you will use DAX to create a table.
How should you create the DAX expression?

You import a TXT file that contains package delivery times. The format in the DeliveryDate column is in datetime format. For example, the first row is 2022-03-20 0831 EST. You want to analyze the dates, but you are not interested in the time stamp.
How could you easily extract the date into a new column?

You work for an established mobile App game company, and you have a large dataset for in-app purchases. The dataset contains over 300k rows.
What visual should you use to identify outliers in the data?

One of your queries in Power Query Editor seems to be taking a lot longer to refresh than you expect. You need to understand what Power Query is doing at authoring and at refresh time.
How would you go about this?

You have created a supplier quality report and are asked to add row-level security to your data model. You decide to add dynamic row-level security that uses a user’s email address. You have a column for a user’s email address called UserEmail.
What DAX function would you use to create a new role using the UserEmail field?

You work for a bank and have a large dataset for credit card transactions for a city. The data is in a Microsoft SQL Server database and has over 15 million rows. Before you use the dataset, you want to import a sample of the credit card data.
How could you achieve this goal?

You have a slicer for categories in a vertical list. How can you get the same slicer into a horizontal list of buttons that automatically adapts to size changes, as per the below exhibit?

CASE 1
You have built a report with many pages for a manufacturing company. Your client’s feedback is that it is hard to navigate to the important pages of the report. You suggest creating a homepage with links to help guide users to important pages on the report.
How would you go about building the homepage?
Solution:
· Add pictures that describe the report page
· Set the image action type to "Q&A."
Can this technique be used for the homepage?

You have a customer service database that has a feedback score from 1 to 5. You create a dashboard with a card visual for the daily feedback score average. The CEO wants to receive an alert if the average score falls below 3.5.
How can he achieve this?

CASE 1
You have built a report with many pages for a manufacturing company. Your client’s feedback is that it is hard to navigate to the important pages of the report. You suggest creating a homepage with links to help guide users to important pages on the report.
How would you go about building the homepage?
Solution:
· Create a bookmark for each page
· On the homepage, create buttons to link to those pages
· On the button, change the action type to bookmark for the corresponding page
Can this technique be used for the homepage?

CASE 1
You have built a report with many pages for a manufacturing company. Your client’s feedback is that it is hard to navigate to the important pages of the report. You suggest creating a homepage with links to help guide users to important pages on the report.
How would you go about building the homepage?
Solution:
· Create shapes e.g. square, circle
· Assign the shape’s action to page navigation
Can this technique be used for the homepage?

CASE 2
You have a dataset for a market basket analysis as per the below exhibit. Each row represents a transaction, and each column contains an item purchased. For instance, in TransactionID 8 there are 3 products: Product1 = ‘peanut butter‘, Product2 = frozen pizza‘ and Product3 =‘ ice cream‘.

You need to transform your data into the below exhibit. The first column is TransactionID, the second is Attribute and the third column is Value.
How would you transform the data into these 3 columns?

CASE 2
For your Market Basket Analysis, you now need to create a new table with all possible combinations of products as per the below exhibit.
What DAX function would you use in the [VALUE] position in the expression?
Basket Analysis =
FILTER(
[VALUE] (
VALUES(‘MarketBasket‘[Value]),
SELECTCOLUMNS(VALUES(MarketBasket[Value]),“Value2“, [Value])
),
[Value]>[Value2] )

CASE 2
You want to use a custom network chart to display your market basket analysis called “Network and add the Advanced Network Visual.” However, your company policy is to not allow custom visuals as a default.
How could you enable this specific custom visual?

CASE 3
You are a Supply Chain analytics manager and have data on customer fill rates. A fill rate is a KPI of the fraction of customer demand that is met through immediate stock availability. See the below exhibit for a sample of the ‘FillRate’ table.
You need to restrict a visual to show the bottom 5 customers with the lowest fill rates.
Solution: Create a measure of the bottom five customers using the TOPN function.
Does this solution meet your goal?

CASE 3
You are a Supply Chain analytics manager and have data on customer fill rates. A fill rate is a KPI of the fraction of customer demand that is met through immediate stock availability. See the below exhibit for a sample of the ‘FillRate’ table.
You need to restrict a visual to show the bottom 5 customers with the lowest fill rates.
Solution: Create a measure of the bottom five customers using the RANKX function.
Does this solution meet your goal?

CASE 3
You are a Supply Chain analytics manager and have data on customer fill rates. A fill rate is a KPI of the fraction of customer demand that is met through immediate stock availability. See the below exhibit for a sample of the ‘FillRate’ table.
You need to restrict a visual to show the bottom 5 customers with the lowest fill rates.
Solution: Apply a Basic Filter on the visual (Visual level filter)
Does this solution meet your goal?

You have a dashboard that is an important part of collaborative planning in your organization. Since the team is remote, you have been asked to allow users to provide feedback on the dashboard that will be visible to other team members.
How would you achieve this goal?

You have an HR dataset divided into regions. You use row-level security to ensure each manager can only see their region’s data. After you publish your report to Power BI Service, an HR manager calls and complains they cannot see all their data in the APAC region.
How would you verify what the HR manager is seeing in Power BI Desktop?

Your company has a Microsoft SharePoint site with all your manufacturing Bill of Materials (BOM) files in a subfolder. These files are all stores as Excel documents and have the same schema. As part of your analysis for the procurement team, you need to load all the Bill of Materials files together into a table in Power BI for analysis. You also need to edit some of the columns after the data has been loaded.
How would you achieve this goal?

You have a Date table with a date field called Date. You want to create a new column with the full month name and the year e.g. 03 October 2022.
How would you create this DAX expression?

You have sales data for a bike company and you calculate a measure of the sales percentage within each category.
You need to format the visualization to match the one shown in the exhibit.
How should you configure the visual?

You work for an airline company and have a dataset with a DirectQuery storage mode. You have built a report with several visuals on the page.
Users complain of performance issues when using the visuals in the Power BI report.
How would you optimize the report?

What data preview type would give you the below exhibit when you click on the Standard cost column?

Your company is looking to expand your Power BI resources. Some of the feedback from your team is that it is hard to test Power BI Service dashboards fully prior to release. Is there a better way to handle the lifecycle of your Power BI report and dashboard creation?
What is the best solution to achieve this goal?

You work for a cryptocurrency exchange and have a report of crypto transactions showing monthly trends. Your crypto transaction table has over 60 million rows. You need to optimize the report’s performance.
Which TWO actions should you perform?

You work for a sports company, and you build a Power BI data set with row-level security in the data model. The company is divided into three categories: footwear, apparel and equipment.
In Power BI desktop, you create roles for each category and you add a DAX filter expression for each role on the product table. You add the Azure Active Directory security group for the category to each role.
A new user starts in the equipment category. What is the best practice to ensure that the new user can only view equipment data?

You lead a Power BI team for a turbine manufacturer. Your boss has asked your team to develop a custom ‘pbiviz’ visual in Power BI that shades the turbine areas according to the number of defects. Before you put together a team to develop the custom visual, you look into the steps to develop a custom visual to understand the skills required.
When setting up an environment for developing a Power BI visual, what software do you first need to install?

You have recently set up Power BI Service at your company. One of the senior managers expresses concern about publishing reports to the web with sensitive data.
What can you do to prevent users from publishing content on the web?

Using the bookmarking features in the report designer in Power BI Desktop, there is a limitation of creating only one bookmark per page in a report.
Is this statement correct?

Which of the following statements are true with regard to using the Slicer visual in a Power BI report?

Which of the following visuals is not included as part of Power BI and must be added as a custom visual?

What is the file format used to define a theme for a Power BI report?

In Power BI Desktop Report view, which three options will create a measure in the Sales table?

What are the three reasons for which you might use calculated tables?

Which three fields are available when creating a Pie chart visualization?

By default, which filter level behaves the same as a slicer in a report in Power BI Desktop?

Which two field options are available when creating a waterfall chart?

Months are sorted alphabetically in Stacked bar chart. What can you do to sort it by month number?

What is true about using variables in DAX?

You’re creating a fancy little dashboard using Power BI Service. The dashboard shows the accumulative increase in the global population over the last several decades. The dashboard will contain an introductory YouTube video that you have uploaded to the YouTube website. After uploading the video you copy the embedded HTML code and paste it into your dashboard.
Unfortunately the video is fixed to 560 pixels wide and you would like it to expand to fit the tile size. What should you do?

How can you make sure that each category manager can see sales of their category only and CEO to see all sales in the same report?

In order to use the Power BI web part in SharePoint Online, the report author as well as all the report consumers require a Power BI Pro license.
Is this statement true ?

Which of the following types of real-time data set in Power BI always store their data in Azure SQL Database?

Which of the following are advantages that Power BI dashboards have over Power BI reports?

Which of the following are advantages that Power BI reports have over Power BI dashboards?

Which three properties of a tile can be edited in the Power BI dashboard from the Tile details window?

What do you need to append to the URL of a Power BI dashboard in order to open it with the navigation pane collapsed by default?

Which feature is used to create alternative name for fields in tables. It will make it much easier for users to ask Questions on dashboards?

Which page view types are available in Power BI Report View?

What is the primary purpose of the on-premises data gateway?

Which feature allows different users to view the same report but access different subsets of data?

You possess a Power BI Report with 5 tables arranged in a star schema. The data set is approximately 50 megabytes in size. Your report currently connects to the SQL Server backend using DirectQuery. What would you do to enable Quick Insights?

You encounter the 1 GB size limitation when uploading and refreshing your PBIX files. What is one way to work around this limitation?

Which option describes when you categorize a numerical identifier into specific ranges?

What does the Manage Relationships button accomplish?