Microsoft Power BI
PL-300 Exam
Data Analyst
Associate Graded
A+
,Questions and Answers PDF 1/101
Question: 1
You are a Power BI specialist at your organization. In your finance table, you have a column called
margin, which is defined as 'margin = revenue – cost of goods sold.' In your company, there are several
different ways people refer to margin. Some people call margin by other terms such as income, profit or
profit margin.
To use the Q&A feature successfully in your dashboard, you need to configure your dataset columns to
enable users to type in variations for margin.
Solution: Add Synonyms to the finance table
Does this solution meet the goal?
A. Yes
B. No
Answer: A
Explanation:
In the modelling tab in Power BI Desktop, you can add synonyms to a column. When a user uses Q&A,
Power BI will check for synonyms when interpreting the question.
Question: 2
CASE 1
You are a Power BI specialist at your organization. In your finance table, you have a column called
margin, which is defined as 'margin = revenue – cost of goods sold.' In your company, there are several
different ways people refer to margin. Some people call margin by other terms such as income, profit or
profit margin.
To use the Q&A feature successfully in your dashboard, you need to configure your dataset columns to
enable users to type in variations for margin.
Solution: Add a detailed description of how you defined margin
Does this solution meet the goal?
A. Yes
B. No
Answer: B
Explanation:
In the modelling section, you can add a description within the properties of a column. A description is
helpful for other modellers to understand the purpose of the column. However, this description does not
have any impact on how Q&A interprets synonyms.
Question: 3
CASE 1
You are a Power BI specialist at your organization. In your inventory table, there are several different
ways people refer to inventory. Some people call inventory by other terms such as stock, supply, parts or
supply.
To use the Q&A feature successfully in your dashboard, you need to configure your inventory table and
columns.
Solution: Set the row label on the inventory table
Does this solution meet the goal?
,Questions and Answers PDF 2/101
A. Yes
B. No
Answer: A
Explanation:
When you click on the table name in the modelling view, you can assign a row label to the column. A role
label allows you to define which column best identifies a row in the table. This label assists Q&A to
generate better visualisations as it knows the best column that identifies a table.
Question: 4
CASE 1
You are a Power BI specialist at your organization. In your inventory table, there are several different
ways people refer to inventory. Some people call inventory by other terms such as stock, supply, parts or
supply.
To use the Q&A feature successfully in your dashboard, you need to configure your inventory table and
columns.
Solution: Use Teach Q&A
Does this solution meet the goal?
A. Yes
B. No
Answer: A
Explanation:
When you click on the Q&A setup button in the home ribbon on Power BI Desktop, one of the options is
to Teach Q&A. Teach Q&A allows you to enter in a question in the language that someone in your
organization may use such as 'What was my stock at the end of August.' If Power BI does not know
understand a word such as 'stock', you are promted to define what 'stock' refers to. This way, when
someone asks a similar question, Power BI will interpret the question correctly.
Question: 5
CASE 2
You have the below relationship between sales, product and employees. The employees table is joined
to the product table by 'category', and the product table is joined to the sales table by 'ProductKey.'
Your boss asks you to build a visual for each Manager's sales by Subcategory.
What do you need to configure to solve that problem?
, Questions and Answers PDF 3/101
A. Create a hierarchy in the product table for subcategory
B. In the employees table, change EmployeeID to type text
C. Set the cross-filter between product and employees to both
D. In the Model view, change the product table's toggle 'is hidden' to True
Answer: C
Explanation:
The current filter direction on the employees table does not allow you to select manager and the sales
and category fields. You need to alter the cross-filter direction to enable the filter to flow from the
employees table to the product table.
Creating a hierarchy in the product table does not help with the cross-filter direction issue in the
employees table.
Changing the EmployeeID to type text is not relevant. The key used to join the employees and product
tables is 'category.'
Toggling the product's table to hidden will prevent users from seeing the product table. We want to use
the fields in the products table to create visuals. This will not help solve our issue.
Question: 6
CASE 2
You want to create a hierarchy in the products table for Category and Subcategory. You will then use the
hierarchy as a drill down for a sales by product visualization as per the below exhibit.
What three actions should you perform in sequence?
PL-300 Exam
Data Analyst
Associate Graded
A+
,Questions and Answers PDF 1/101
Question: 1
You are a Power BI specialist at your organization. In your finance table, you have a column called
margin, which is defined as 'margin = revenue – cost of goods sold.' In your company, there are several
different ways people refer to margin. Some people call margin by other terms such as income, profit or
profit margin.
To use the Q&A feature successfully in your dashboard, you need to configure your dataset columns to
enable users to type in variations for margin.
Solution: Add Synonyms to the finance table
Does this solution meet the goal?
A. Yes
B. No
Answer: A
Explanation:
In the modelling tab in Power BI Desktop, you can add synonyms to a column. When a user uses Q&A,
Power BI will check for synonyms when interpreting the question.
Question: 2
CASE 1
You are a Power BI specialist at your organization. In your finance table, you have a column called
margin, which is defined as 'margin = revenue – cost of goods sold.' In your company, there are several
different ways people refer to margin. Some people call margin by other terms such as income, profit or
profit margin.
To use the Q&A feature successfully in your dashboard, you need to configure your dataset columns to
enable users to type in variations for margin.
Solution: Add a detailed description of how you defined margin
Does this solution meet the goal?
A. Yes
B. No
Answer: B
Explanation:
In the modelling section, you can add a description within the properties of a column. A description is
helpful for other modellers to understand the purpose of the column. However, this description does not
have any impact on how Q&A interprets synonyms.
Question: 3
CASE 1
You are a Power BI specialist at your organization. In your inventory table, there are several different
ways people refer to inventory. Some people call inventory by other terms such as stock, supply, parts or
supply.
To use the Q&A feature successfully in your dashboard, you need to configure your inventory table and
columns.
Solution: Set the row label on the inventory table
Does this solution meet the goal?
,Questions and Answers PDF 2/101
A. Yes
B. No
Answer: A
Explanation:
When you click on the table name in the modelling view, you can assign a row label to the column. A role
label allows you to define which column best identifies a row in the table. This label assists Q&A to
generate better visualisations as it knows the best column that identifies a table.
Question: 4
CASE 1
You are a Power BI specialist at your organization. In your inventory table, there are several different
ways people refer to inventory. Some people call inventory by other terms such as stock, supply, parts or
supply.
To use the Q&A feature successfully in your dashboard, you need to configure your inventory table and
columns.
Solution: Use Teach Q&A
Does this solution meet the goal?
A. Yes
B. No
Answer: A
Explanation:
When you click on the Q&A setup button in the home ribbon on Power BI Desktop, one of the options is
to Teach Q&A. Teach Q&A allows you to enter in a question in the language that someone in your
organization may use such as 'What was my stock at the end of August.' If Power BI does not know
understand a word such as 'stock', you are promted to define what 'stock' refers to. This way, when
someone asks a similar question, Power BI will interpret the question correctly.
Question: 5
CASE 2
You have the below relationship between sales, product and employees. The employees table is joined
to the product table by 'category', and the product table is joined to the sales table by 'ProductKey.'
Your boss asks you to build a visual for each Manager's sales by Subcategory.
What do you need to configure to solve that problem?
, Questions and Answers PDF 3/101
A. Create a hierarchy in the product table for subcategory
B. In the employees table, change EmployeeID to type text
C. Set the cross-filter between product and employees to both
D. In the Model view, change the product table's toggle 'is hidden' to True
Answer: C
Explanation:
The current filter direction on the employees table does not allow you to select manager and the sales
and category fields. You need to alter the cross-filter direction to enable the filter to flow from the
employees table to the product table.
Creating a hierarchy in the product table does not help with the cross-filter direction issue in the
employees table.
Changing the EmployeeID to type text is not relevant. The key used to join the employees and product
tables is 'category.'
Toggling the product's table to hidden will prevent users from seeing the product table. We want to use
the fields in the products table to create visuals. This will not help solve our issue.
Question: 6
CASE 2
You want to create a hierarchy in the products table for Category and Subcategory. You will then use the
hierarchy as a drill down for a sales by product visualization as per the below exhibit.
What three actions should you perform in sequence?
