Power BI Data Analyst Certification (PL-300) Practice Test 2

Retail and finance teams need to know what sold, what slipped, and what needs action tomorrow. Power BI replaces one-off exports with refreshable scorecards. Data analysts own the model. Data scientists place forecasts beside actuals so commercial leads can see risk without a notebook. The PL-300 certification proves you can prepare and present that story with discipline, which can support credibility and a stronger pay conversation once a portfolio matches the badge. Use this free Microsoft Power BI Data Analyst Associate Certification (PL-300) Practice Test 2 to check readiness. Employers that staff this work include Walmart, JPMorgan Chase, and Accenture. U.S. base pay varies by city and industry: junior data analysts often earn $58,000–$75,000, mid-level analysts commonly earn $78,000–$108,000, and senior data analysts frequently reach $112,000–$145,000. Synergisticit JOPP helps jobseekers get certified, prepared, and hired at top tech companies through our Job Placement programs—Java DevOps Full Stack JOPP and Data Science JOPP.

If you want to learn how to get hired as a Power BI Data Analyst, Data Scientist, Data Engineer, AI or ML engineer, Java developer, or software engineer, contact Synergisticit for expert upskilling and marketing connections to companies. Visit Synergisticit Contact Us and Synergisticit JOPP.

Employers expect candidates to master Power BI and Tableau, query with SQL, and apply statistical analysis using SAS. Data engineering expertise in Snowflake, Databricks, and PySpark is essential, along with data science and AI skills in TensorFlow, PyTorch, LLMs, and Generative AI. Project work is equally important to prove practical expertise.

Welcome to your Microsoft Power BI – Test-2

Name

Phone

Q1. Which of the following tasks cant be performed using the dataset settings option of the Power BI Service?

Select 1 option(s):

A. Modify query editor parameter values

B. Check the cardinality for the columns in the dataset

C. Mark the dataset as certified or promoted

D. Change the credentials used for connecting to the underlying data source

E. Define the sensitivity label for the dataset

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

Select 1 option(s):

A. Private

B. Public

C. Organizational

D. Confidential

Q3. 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?

Select 1 option(s):

A. Creating a separate report for chief executive officer and separate reports for every product category manager using a different product category filter in every report

B. Creating a product_category slicer in the report

C. Implementing Dynamic row-level security

D. None of these

Q4. 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?

Select 1 option(s):

A. Yes

B. No

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

Select 2 option(s):

A. Dashboards can have only a single page while reports can have multiple pages

B. Reports can have only a single page while Dashboards can have multiple pages

C. Both Dashboards and Reports can have multiple pages

D. Both reports and dashboards can be refreshed to display the latest data

E. Dashboards can be refreshed to display the latest data while the reports cant

F. Reports can be refreshed to display the latest data while the Dashboards cant

Q6. 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?

Select 1 option(s):

A. Creating a data alert

B. Sharing the dashboard to the user

C. Creating a subscription

D. Tagging the user in a comment

Q7. What is the unique benefit of using a customized tooltip?

Select 1 option(s):

A. With a customized tooltip, any image or color can be set as the background for the visual

B. It can demonstrate the value and category of the data points

C. It can demonstrate the images, visuals, and any other collection of items that are created by the user on the report page

D. With a customized tooltip, a border can be created around the visual for isolating the visual from other elements on the canvas

Q8. 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?

Select 2 option(s):

A. Add a Scholarship_amount to the Tooltips

B. Add a Scholarship_amount to the drill through fields

C. Add a Scholarship_amount to the Visual Filters

D. None of the above

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

Select 1 option(s):

A. The question box where the question is entered by the users. It also shows the suggestions to the users that help them in completing their questions

B. A pre-populated list of suggested questions

C. An icon that can be selected by the users to convert the Q&A visual into a standard visual

D. An icon that can be selected by the users to automatically create a custom tooltip

E. An icon that can be selected by the users to open Q&A tooling where they can configure the underlying natural language engine

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

Select 1 option(s):

A. Line Chart

B. Scatter Chart

C. Bar chart

D. Donut chart

Q11. 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?

Select 1 option(s):

A. Key influencers

B. Funnel chart

C. Donut Chart

D. Q&A visualization

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

Select 2 option(s):

A. Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset

B. Promotion needs permission from the dataset owner or admin to access the dataset whereas Certification does not require specific permissions from the admin, whereas Certification

C. In terms of permission, there is no difference between promotion and certificationright

D. Certification is the ideal way to endorse the dataset when the dataset is ready for broad usage

E. Promotion is the ideal way to endorse the dataset when the dataset is ready for broad usage

Q13. Which of the following is not the feature of the Lineage view in Power BI?

Select 1 option(s):

A. It allows the users to troubleshoot the flow of data from its source to its destination

B. It allows the users to manage the workspaces and analyze the impact of a single change in one dataset to dashboards and reports

C. It simplifies the task of identifying the dashboards and reports that haven‘t been refreshed

D. It helps in analyzing the data sets and finding the patterns, trends, and outliers

Q14. 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?

Select 1 option(s):

A. Power BI Desktop

B. Power BI Desktop optimized for Report Server

C. Power BI desktop optimized for Paginated reports

D. Power BI Report Builder

Q15. There is an Azure SQL database having the records for sales transactions. The database is updated on a frequent basis. You need to create reports from the sales data to identify fake transactions. The data needs to be visible within 5 minutes of an update.

How can the data connection be configured to achieve the target?

Select 1 option(s):

A. By adding a SQL statement

B. By setting the data connectivity mode to DirectQuery

C. By setting the Command timeout in minutes setting

D. By setting the data connectivity mode to Import

E. By adding a PL/SQL statement

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

Select 1 option(s):

A. Youre sure about the data that you need in your new column, but you are not sure about the transformation or set of transformations, that will get you the same

B. Youre confirmed about all the transformations that you need using a Custom Column expression in M language, but one (or more) of these expressions are not available in the UI

C. Youre sure about the transformations that you need, but you are not sure what to choose in the UI to let them happen

D. All the above

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

Select 1 option(s):

A. DataFrame

B. List

C. Record

D. Table

E. Type

F. Function

Q18. 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?

Select 1 option(s):

A. Query A to Query C

B. Query A to Query D

C. Query B only

D. Query D only

E. Query B and Query D

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

Select 2 option(s):

A. A relation between two tables must be created using a single field from every table

B. A relation between two tables can be created using multiple fields from every table

C. At least 1 column defined in a table relation needs to have unique values

D. You can create multiple relations between two tables but only one of these relations can be marked as active

E. You can create multiple relations between two tables and all these relations can be marked as active

Q20. 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?

Select 1 option(s):

A. Yes

B. No

Q21. Consider the below given Power BI model.

Microsoft Power BI data model diagram illustrating product categories and SKU relationships.
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?

Select 1 option(s):

A. True

B. False

Q22. 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))

Select 1 option(s):

A. Salary_cost for the Year 2020 as Slicer Selection overrides DAX Filter

B. Salary_cost for the Year 2019 as DAX Filter overrides Slicer Selection

C. Blank. It will return no records

D. It will return Salary_cost records for the year 2019 as well as 2020

Q23. 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)?

Select 1 option(s):

A. TREATAS

B. USERELATIONSHIP

C. CROSSFILTER

D. RELATEDTABLE

E. RELATED

Q24. 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?

Select 1 option(s):

A. Implement row-level security to allow the report recipients to only to view the results depending upon the emails they sent

B. During the import, Remove the columns Subject and Body

C. Through Model view, set the columns Subject and Body to Hidden

D. Implementing Dynamic row-level security

Q25. 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?

Select 1 option(s):

A. Visualization: A column chart for Unit_Price and Quantity_ordered by year and Feature: Automatically finds clusters

B. Visualization: A column chart for Unit_Price and Quantity_ordered by year and Feature: Find where the distribution is different

C. Visualization: A scatter Plot for Unit_price and Quantity_ordered by item and Feature: Automatically Finds Clusters

D. Visualization: A scatter Plot for Unit_price and Quantity_ordered by item and Feature: Find where the distribution is different

E. Visualization: A Line chart for Unit_Price and Quantity_ordered by year and Feature: Automatically Finds Clusters

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

Select 1 option(s):

A. Background color for the report

B. Set of the custom colors that are utilized by the visuals throughout the report

C. Default features of the new visuals which are included in the report

D. All of these

Q27. 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?

Select 1 option(s):

A. Text box

B. Video

C. Web content

D. Custom streaming Data

E. Image

Q28. 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?

Select 1 option(s):

A. Using only the default visuals

B. Using default or custom visuals from the .pbiviz file

C. Using default visuals or custom visuals from the marketplace

D. Using default visuals or certified custom visuals

Q29. 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.

Select 1 option(s):

A. Page Order

B. Tab Order

C. Layer Order

D. Field Hierarchy

E. Bookmark Order

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

Select 4 option(s):

A. Aggregate the data to reduce the number of rows. For example, the transactions can be grouped by the month rather than showing them by date

B. Restrict the number of data points shown in a visual for example in a table with the help of the Top N filter

C. Optimize the DAX expressions to iterate through fewer rows

D. Split out the dimensions and associated attributes into their own tables minimizing the number of columns within a fact tables

E. Reduce the number of bookmarks applied to a report.

F. Use FILTER as parts of CALCULATE measure instead of writing the filter condition directly within the function

Q31. 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.

Select 1 option(s):

A. a-b-c-f-g

B. a-c-b-g-h

C. a-b-c-e-g

D. g-a-f-d

E. a-g-f-d

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

Select 3 option(s):

A. Adding a new data source

B. Adding a new DAX measure

C. Configure Scheduled Refreshes

D. View the refresh history

E. Creating a new table relationship

F. If you are not the current owner, you can take over the dataset.

Q33. 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?

Select 3 option(s):

A. Use Incremental Refresh feature only for the data sources supporting query folding

B. RangeStart and RangeEnd are two PowerQuery parameters that are needed for the incremental Refresh

C. Use Incremental Refresh feature for all data sources

D. A date field is needed on a table in the dataset

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

Select 1 option(s):

A. Workspaces can be used to house dashboards and reports for use by multiple teams

B. Workspaces allow you to share and present dashboards and reports in a single environment

C. Workspaces allow you to view and edit the data model, create visualizations and transform the data

D. Workspaces ensure the highest level of security by controlling who can access the dashboards, reports, and datasets

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

Select 2 option(s):

A. Writing measures back to the data model

B. See the data model in Relationships or model view in Power BI Desktop

C. Edit or simply view the DAX measures existing in the data model

D. Writing report level measures (specific only to that report, not written back to the Data Model)

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

Power BI DAX code snippet illustrating data modeling and transformation for analytics.
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?

Select 1 option(s):

A. Delete the Remove Duplicates steps

B. Modify the query to use Direct Query mode

C. Modify the query to use the Import Connection mode

D. From Power Query, choose the Unpivot Columns command

E. Use Rename Column

Q37. 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?

Select 1 option(s):

A. Append queries and delete the queries

B. Append queries as new and disable loading the query to the data model

C. Append queries and disable loading the query to the data model

D. Merge queries and delete the queries

E. Merge queries and disable loading the query to the data model

F. Merge queries as new and disable loading the query to the data model

Q38. 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

Select 1 option(s):

A. 1-2-3-4-5

B. 5-4-3-2-1

C. 1-5-4-3-2

D. 1-2-5-4-3

E. 1-3-2-4-5

Q39. Consider the below given Power BI model.

Data model relationship diagram showing Product linked to Product Category by SKU.
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?

Select 1 option(s):

A. True

B. False

Q40. 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?

Select 1 option(s):

A. A new measure can be created by clicking the New Measure button present in the Home tab of Power BI Desktop

B. A measure can be referenced in a DAX expression by writing the [ bracket

C. Whenever you do interact with the report, the context in which the measure calculates and shows its results changes

D. All of the above

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

Select 1 option(s):

A. Setting Assume referential integrity makes queries utilize INNER JOIN statements instead of OUTER JOIN, which increases the query efficiency

B. It considers that there are no null or blank values in any data table in the relationships

C. It automatically considers the relationship as one to one (instead of one to many or many to one)

D. It permits the calculated columns to be considered as the relationship column between the tables

E. Setting Assume referential integrity makes queries to utilize OUTER JOIN statements instead of INNER JOIN, which increases the query efficiency

Q42. 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?

Select 1 option(s):

A. Decomposition tree visuals

B. Funnel Visual

C. Key Influencer Visual

D. Combo visual

E. Waterfall Visual

Q43. 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?

Select 1 option(s):

A. R scripting is by default available in Power BI Desktop. You dont need to perform any special action to use R scripting

B. You need to install RStudio on your system at which Power BI Desktop is already installed

C. You need to install Microsoft R on your system at which Power BI Desktop is already installed

D. You need to install R Plug-in for Power BI Desktop

Q44. 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?

Select 1 option(s):

A. Comments

B. Mark as favorite

C. Subscribe

D. Feedback

E. Bookmark

Q45. 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?

Select 1 option(s):

A. Add a text box for every business query and insert a link

B. Add a button for every business query and set the action type to Bookmark

C. Build a Power Apps visual containing a drop-down list. This list will consist of all business queries

D. Add filters to the menu page

E. None of the above

Q46. 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?

Select 1 option(s):

A. Editing synonyms from the Power BI service

B. Editing Relationships from the Power BI Desktop

C. Editing synonyms from the Power BI Desktop

D. Editing tables from the Power Query in Power BI Desktop

Q47. 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?

Select 2 option(s):

A. To conduct root cause analysis

B. To automatically analyze the chosen dimensions to check where the measure is having the lowest or highest value

C. To conduct what-if analysis with built-in parameters

D. To visualize the data across multiple dimensions

E. To show the beginning and ending headcount for the organization in a year

Q48. 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?

Select 1 option(s):

A. You chose only to refresh the complete periods

B. Query folding is not happening

C. No filter is applied to the file

D. Data type for the column that is utilized for data partition has changed

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

Select 1 option(s):

A. Creating, editing, or deleting the content in the workspace

B. Publishing workspace content in the app

C. Adding or removing the other users from the workspace

D. Creating a report in another workspace depending upon the dataset of this workspace

E. Scheduling the data refreshes

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

Select 1 option(s):

A. Combining the date and time columns in a single column

B. Pulling the data only into Power BI Service, nor Power BI Desktop

C. Performing some calculations in the original data source

D. Using SELECT SQL statement in SQL queries while pulling the data from a relational database

Q51. 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 1 option(s):

A. Column1: Capitalize Each Word Column2: Clean

B. Column1: Clean White Spaces Column2: Trim

C. Column1: Clean White Spaces Column2: Clean

D. Column1: Length Column2: TRIM

E. Column1: Trim Column2: Clean

F. Column1: Capitalize Each Word Column2: Trim

Q52. Consider the statement below:

Select 1 option(s):

Queries in the Query editor dont need to be loaded to the data model. You can decide and select whether to load them or not.

A. True

B. False

Q53. Consider the two tables Courses and Teachers with the following snapshots

Table showing course names, IDs, total paid and teacher contact details.
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).

Warning banner: 'The cardinality you selected isn't valid for this relationship.'
What should you do before creating the Many-to-One relationship?

Select 1 option(s):

A. Use the “Remove Errors“ command for the Courses table

B. Filter out the blank values from the Teachers table

C. Add a new index column Teacher Name to the table Courses

D. Use the “Remove Duplicates“ command for the Teachers table

E. Use the “Remove Duplicates“ command for the Courses table

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

Select 1 option(s):

A. Assigning the security permissions for the underlying Power BI Azure SQL Database

B. Adding the ability to link Power BI Log-in to organizational Active Directory or Window Login through Single Sign On (SSO)

C. Restricting data access for the given users ( By assigning users to roles)

D. Restrictions to specific measures within Power BI reports to some specific users

E. All the above

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

Select 1 option(s):

A. Row

B. Column

C. Table

D. Integer

E. Character

Q56. 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?

Select 4 option(s):

A. TRIM

B. REPT

C. FIND

D. SEARCH

E. CONTAINSSTRING

F. CONTAINSSTRINGEXACT

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

Select 1 option(s):

A. Format Query

B. Split Query

C. Extract previous

D. Mark Query

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

Select 1 option(s):

A. You should not delete unnecessary columns and rows as its always a preferable practice to all the metadata intact

B. Removing unnecessary columns and rows can damage the structure of your data model

C. Removing necessary columns and rows will result in reducing the dataset size and its always a preferable practice to load only the necessary data in your data model

D. All of the above

Q59. 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:

Code snippet showing matplotlib usage: dataset.plot.line(...)
In the response, you get the following error message.

Error message: 'Can't display this visual. No image was created. Make sure your Python script results in a plot' with buttons Copy Details and Close.
How would you fix this issue?

Select 1 option(s):

A. By refreshing the IDE settings

B. By adding the command pyplot.show() to the script

C. By refreshing the dataset origin connection

D. By enabling the python visuals before code is run

Q60. 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?

Select 1 option(s):

A. Modify the default visual interaction from cross highlighting to cross-filtering

B. Dont permit the end users to save filters on the report

C. Permit the users to include the comments in the report

D. Enable the modified filter pane and display the filters in the visual header of the report

E. Select the type of data you want to allow the end-users to export

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

Select 3 option(s):

A. Report offers storytelling capability with the help of bookmarks

B. Reports offer a better real-time experience while showing data from a streaming dataset

C. Report definitions are possible to save using PBIX, an external file format, and checked into source control

D. Reports offer a better interactive drill down and filtering experience

E. Reports update automatically whenever the data of the underlying dataset is updated

Q62. Where is it possible to configure and set data alerts?

Select 1 option(s):

A. You can set Data alerts in both Power BI Desktop and Power BI Service on any type of visual

B. You can set data alerts only in the Power BI service on some specific type of visuals like gauges, KPI and cards

C. You can set data alerts only in the Power BI desktop on some specific type of visuals like gauges, KPI and cards

D. You can set Data alerts only in the Power BI service on any type of visual

E. You can set Data alerts only in the Power BI desktop on any type of visual

Q63. 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?

Select 1 option(s):

A. Change the visual from the table to Matrix

B. Create a paginated report

C. Create a customize tooltip

D. Reduce the table size by grouping the rows

E. Expand the table to the whole page

Q64. 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 1 option(s):

A. The value of the formula will be “Los Angeles“

B. The value of the formula will be “LA“

C. The value of the formula will either be “Los Angeles“ or whatever the value for the State column is

D. The value of the formula will be the same value as the State column

Q65. 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?

Table showing category, sales total and sales percentage

Select 1 option(s):

Use conditional formatting with a Color scale using default settings

Use conditional formatting with Rules

Use conditional formatting with a Color scale and check the diverging setting

Use conditional formatting with Field values

Power BI Data Analyst Certification (PL-300) Practice Test 2

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

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

Q3. 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?

Q4. 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?

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

Q6. 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.

Q7. What is the unique benefit of using a customized tooltip?

Q8. 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?

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

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

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

Q13. Which of the following is not the feature of the Lineage view in Power BI?

Q14. 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?

Q15. There is an Azure SQL database having the records for sales transactions. The database is updated on a frequent basis. You need to create reports from the sales data to identify fake transactions. The data needs to be visible within 5 minutes of an update.

Q16. Which of the following might be the possible considerations for using the Add Column From Examples feature in the query editor?

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

Q18. 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?

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

Q20. 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.

Q21. Consider the below given Power BI model.

Q22. What will be the result of the following DAX formula if the year 2020 is chosen on a slicer of a report?

Q23. 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)?

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

Q27. 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.

Q29. 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.

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

Q31. 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.

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

Q33. 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?

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

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

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

Q38. 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.

Q39. Consider the below given Power BI model.

Q40. 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?

Q41. What does Assume Referential Integrity mean in Power BI Desktop while developing the relationships between the tables?

Q42. You have a Consumer Sales Revenue monthly report. You analyze and notice that the attrition Rate metric is sharply increased.

Q43. 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?

Q44. 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?

Q45. 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.

Q46. 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.

Q47. 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?

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

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

Q51. 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.

Q52. Consider the statement below:

Q53. Consider the two tables  Courses and Teachers with the following snapshots

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

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

Q56. 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?

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

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

Q59. 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:

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

Q62. Where is it possible to configure and set data alerts?

Q64. For the custom column Formula:

Q65. 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.

Q1. Which of the following tasks cant be performed using the dataset settings option of the Power BI Service?

Q13. Which of the following is not the feature of the Lineage view in Power BI?

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

Q18. 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?

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

Q53. Consider the two tables Courses and Teachers with the following snapshots

Q56. 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?