PL-300 Exam – Practice 2

Which of the following is the right DAX function to modify a single directional relationship to a bi-directional relationship on the fly (within the measure)?

You have a Consumer Sales Revenue monthly report. You analyze and notice that the attrition Rate metric is sharply increased.
You are interested in understanding the variables that might affect this result.
Which of the following visuals can you use to understand and explore the potential causes in Power BI Desktop?

Consider that you want to split your query into two parts. Which of the following options would you use in Power BI?

Which of the following chart is the great choice to identify or display the outliers?

You are publishing a report to “Consumer Services” Workspace. The report basically identifies the consumers having data quality problems that need to be investigated by the consumer services department of the company. You want to allow the consumer service managers to create the task lists in Microsoft Excel depending upon the data. How would you configure the report setting?

What is the use of Row Level Security (RLS) in Power BI?

Select the types from the below-given list which is not valid in the M Programming language?

You develop a Power BI Report for a huge dataset. You are looking to enhance the performance of dataset refresh through an incremental refresh. Which of the following statements are true regarding this scenario?

You are creating a complex report having a lot of visuals in Power BI. You want to ensure that the users read it in a logical way when they use the keyboard. From the following list, select the right option which you need to work on.

Which of the following is a potential way to improve the performance while getting the data in Power BI?

Which of the following is the possible outcome of removing the unnecessary columns and rows?

You have the responsibility to configure the Microsoft Power BI dashboard. You need to add the feature that the users of the dashboard can provide you with feedback and that feedback should be visible to the other users of the dashboard? In this case, what would you use?

Consider the statement below:

A Microsoft SQL Server Analysis Services (SSAS) cube has been connected to Power BI Desktop, producing the following query:

The query returns 18,550 records. After going through the data source, you find that source is having a total of 21,550 records.  Which of the following can you do to ensure that the query returns all 21,550 records?

You want to develop some visualizations in Power BI Desktop using R Scripting. Which of the following actions do you need to perform to use R scripting in Power BI Desktop?

What is the unique benefit of using a customized tooltip?

You are modelling the data with the help of Microsoft Power BI. The data model consists of a large Microsoft SQL Server table titled Transactions with records higher than 120 million.
During the development phase, it is required to import a sample of data from the Transactions table.
You decide to write a DAX expression that utilizes a filter function.  Will this help you in achieving the goal?

You need to import a dataset into the Power BI Desktop from an Excel document. While performing the tables profiling, you notice that two columns require some fixings where Column1 is having many values starting with space and column2 is having a number of non-printable characters.
Which of the following commands can help you in fixing the errors in Column1 and Column2?

Select the capabilities from the given list that you can use while connected to a data model via Live Connection.

There is a dashboard named Salary_Cost having Q&A enabled on it.  When a user tries to get the count of Employees, the query gets failed. On the other hand,  when the user asks for the count of workers, the query returns the expected result.
You need to ensure that the same result is returned by both queries. Which of the following actions would you perform?

Choose the correct return type for the FILTER function in DAX.

Which of the following is not the feature of the “Lineage view” in Power BI?

Which of the following options is not a privacy level in Power BI desktop?

You are developing a visual to demonstrate the ranking of the product types by sales revenues. As per your company‘s security policies, you can‘t send the data outside of your Power BI tenant. Which of the following approach would provide the widest variety of visuals while sticking to the security policies?

Which of the following are the benefits of Power BI Reports over Power BI Dashboards?

You develop a dataset named from the flat files that will use incremental refresh. The dataset with other related reports is deployed to the Premium Power BI. You notice that the incremental refresh for the dataset gets failed due to the lack of resources.  Which of the following might be a potential reason for the problem?

Which of the following statements are true for dashboards and reports?

Which of the following is not a core component of Q & A Visualization?

Your team manager has asked you to print some Power BI reports and distribute them among the team members during the Review meeting. Before starting the printing of reports, you notice that some tables are showing fewer rows as compared to the actual rows present there. Which of the following is the right method to resolve this issue?

Which of the below-given settings are possible to be managed in a dataset in Power BI Service?

You have 2 Azure SQL databases having the same tables and columns. For every database, you create a query to retrieve the data from the EMPLOYEES table. You want to combine both EMPLOYEES tables into a single table. The solution needs to minimize the data model size and support the scheduled refresh in powerbi.com. Which of the following actions would you perform respectively; to combine the EMPLOYEES tables and on the original two SQL database queries?

You want to create a calculated column in DAX that returns a value if the word “Admin” is present in the corresponding “Role” Column. Which of the following DAX functions can be used for the purpose?

You have created a dashboard with the help of Microsoft Power BI Service. The dashboard has a card visual that displays the total sales from the last year.
You provide users access to the dashboard through the Viewer role on the workspace.
A user is interested in receiving daily notifications for the number displayed on the card visual. Which of the following is the right choice to automate the notifications?

Consider the two tables: Courses and Teachers with the following snapshots

You desire to set a relationship between the tables courses and teachers with many-to-one cardinality, but it is not available in the relationship settings (as demonstrated in the below picture).

What should you do before creating the Many-to-One relationship?

Consider the below given Power BI model.

This model shows the relationship of the Product table with the Product category on column SKU.
Here is the sample of the data that both the tables have:
Product Table
SKU: E-01, Product: Lenovo Ideapad Slim 5i, Color: Grey
SKU: E-02, Product – Sony headset, Color: Red
SKU: E-03, product- Samsung TVs, Color: Black
Product Category
SKU: E-01, Category: laptops
SKU: E-02, Category: Headsets
SKU: E-03, category: Televisions
You need to utilize a Hierarchy in your Power BI report that demonstrates two levels i.e product and category.
To achieve the goal, you decide to create a DAX expression with the CONCATENATEX function between the Product and Category columns.
Will it really help you in achieving the goal?

Consider the below given Power BI model.

This model shows the relationship of Product table with Product category on column SKU.
Here is the sample of the data that both the tables have:
Product Table
SKU: E-01, Product: Lenovo Ideapad Slim 5i, Color: Grey
SKU: E-02, Product – Sony headset, Color: Red
SKU: E-03, product- Samsung TVs , Color : Black
Product Category
SKU: E-01, Category: laptops
SKU: E-02, Category: Headsets
SKU: E-03, category: Televisions
In your Power BI report, you need to create a Hierarchy that demonstrates two levels i.e. Product and Category.
Solution: From Power Query, merge the tables and then create the hierarchy.
Will the given solution help in achieving the goal?

You need to create a report that will demonstrate the sales performance of the company. The sales team has requested you to add a single visualization (if possible) that might help them in identifying the factors that drive the sales and affect the success.   Which of the following visualization would you use?

There is a dataset containing the survey results for the percentage of Facebook usage by Gender, year, and age.  The age of the survey respondents lies between 10 and 70 years. You need to build a bar chart demonstrating the percentage of Facebook usage for equal age ranges of 15 years.
Here is the list of some actions that might be performed.
a. Set the group type to Bin
b. Set the Bin size to 4
c. Set the Bin Count to 15
d. Set the Bin count to 4
e. Set Group type to list
f. Set the Bin type to the number of Bins
g. Right-click on the column Age and Choose New Group
Choose the correct sequence of the actions (you may choose some or all actions from the given list) that you would perform.

Which of the following are the potential ways to enhance the performance of a report?

What does “Assume Referential Integrity” mean in Power BI Desktop while developing the relationships between the tables?

What will be the result of the following DAX formula if the year 2020 is chosen on a slicer of a report?
2019 Salary_Cost = CALCULATE([Total Salary_cost], Filter (Date, Date[Year]=2019))

Where is it possible to configure and set data alerts?

Which of the following tasks can’t be performed using the dataset settings option of the Power BI Service?

You need to register an app for embedding Power BI content. You are thinking of using an account which does not have a Power BI Pro license. Will it work for you?

You need to ensure that the managers of each product category can view the sales records for their product category only while the Chief executive officer should be able to view all sales records in the same report.  Which of the following is the potential solution with minimal efforts?

You have 3 queries in Power BI Desktop: Query A, Query B and Query C. You are developing Query D that will be appended to query B. Which of the queries will get refreshed while loading the data?

Which of the following tasks can be done only by the workspace admin, not by the users with lesser authorities and privileges?

You work for a Bike company and create a report of Sales and Category. You build a measure for the Sales % of Categories and want to add conditional formatting such that the colors for low values are red, center values are orange and high values are green.
How would you achieve this goal?

You can create some very powerful data analysis solutions with the help of measures. Which of the following statement is true about the measures in Power BI? 

You need to create Power BI reports which are to be deployed to Power BI Report Server. Which of the following tools would you use?

There is a product dataset with the columns Unit_Price and ordered_quantity. You have been asked to build a visualization that displays the relationship between Unit_Price and Ordered_Quantity and the orders having similar unit price and ordered_quantity should be highlighted. Which of the following visualization and feature would you use?

Which of the following might be the possible considerations for using the “Add Column From Examples” feature in the query editor?

Promotion and certification are two ways to endorse dataset. Which of the following statements are true about Promotion and Certification?

You need to create some visualizations in Power BI Desktop using Python Scripting. After installing and configuring Python for Power BI Desktop, you run the below-given code:

In the response, you get the following error message.

How would you fix this issue?

There are some health and safety videos of your organization that are deployed to Microsoft (MS) Stream. You want to surface these videos directly in a Power BI dashboard.
Which of the following tile would be suitable to add?

You need to create a dimension table from the data source which is a single flat table (For example, create an item dimension from a list of transactions of item details).  Choose the correct sequence of the following steps that you will perform.
Connect to the data source  (Staging Query)
Develop a surrogate key (index column) if needed and link back to the fact table
Eliminate the duplicates from the table to have a unique list of items
Delete all the columns other than the ones having item details from the new query for the dimension
Make references to the staging query. One reference for the fact table and one reference for every dimension you desire to create

For the custom column Formula:
            =if[state]= “LA” then “Los Angeles” else[state]
Select the statement that rightly describes the value for the custom column formula.

Select the correct Power BI report settings that you can customize with the help of a report theme?

Which of the below-given statements correctly define the rules for creating the table relationships while designing a data model?

You have a custom connector that returns email-ID, From, To, Body and attachments for each email sent in a specified year and more than 10 million records have been returned by this connector. Your manager has asked you to build a report to analyze the internal network of employees depending upon whom they send mails to. Also, the report recipients should not be able to read the analyzed emails. The solution is supposed to minimize the size of the model. What would you do?

Your team is working on a project where they will come across different scenarios to use the decomposition tree. The team is confused and wants to be assured of where to use the decomposition tree. For which of the following purposes, you won‘t recommend them to use decomposition tree?

You have created a line visual that displays the number of students getting scholarships over time. Now, you are interested in seeing the total scholarship cost of the students when you hover over a data point. Which of the following are the possible options to accomplish this goal?

You are creating a sales report that is supposed to have multiple pages.  Each page would be specific to the answer for a specific business query.
You decide to have a menu page that will demonstrate all the business queries. Users should be able to click any business query and after that directed to the page having the answer for the clicked query.  Also, you need to ensure that the menu page works when published to any workspace.
What would you do to make this work?

Which of the following is not a benefit offered by the workspaces?