PL-300: Microsoft Power BI Data
Analyst part 2 Exam Questions &
Answers (Grade A+)
How many inactive relationships are there in the model shown
above?
1
2
3
None -
correct answer ✅1
The dotted line connecting the Calendar and Sales tables is an
inactive one-to-many relationship. The other two relationships are
active.
Which of these functions can be used to activate inactive
relationships?
RELATED
RELATEDTABLE
USERELATIONSHIP
,PL-300: Microsoft Power BI Data
Analyst part 2 Exam Questions &
Answers (Grade A+)
ACTIVATE -
correct answer ✅USERELATIONSHIP
The USERELATIONSHIP function allows you to determine which
relationship to use between to tables, including inactive
relationships.
If you import or create your own date table, which of these
requirements must it meet?
Must contain all the days for all years represented in the model
Cannot contain duplicate dates
Must have at least one field set as a Date or DateTime datatype
All of the above -
correct answer ✅All of the above
,PL-300: Microsoft Power BI Data
Analyst part 2 Exam Questions &
Answers (Grade A+)
To import or create your own date table, it must meet all 3 of these
requirements, and all times must be identical (i.e. 12:00).
You are creating a report in Power BI Desktop.
You are consuming the following tables.
You have a new table named Fiscal that has the same schema as
the Date table, but contains the fiscal dates of your company.
You need to create a report that displays the total sales by fiscal
month and calendar month.
What should you do?
Union Fiscal and Date as one table.
Add Fiscal to the model and create a one-to-many relationship by
using Date[Year] and Fiscal[Year].
, PL-300: Microsoft Power BI Data
Analyst part 2 Exam Questions &
Answers (Grade A+)
Add Fiscal to the model and create a one-to-one relationship by
using Date[Year] and Fiscal[Year].
Merge Fiscal into the Date table. -
correct answer ✅Merge Fiscal into the Date table.
Same schema.
You have a Microsoft Excel 2016 workbook that has a Power Pivot
model. The model contains the following tables:
- Product (Product_id, Product_Name)
- Sales (Order_id, Order_Date, Product_id, Salesperson_id,
Sales_Amount)
- Salesperson (Salesperson_id, Salesperson_name, address)
The model has the following relationships:
- Sales to Product
- Sales to Salesperson
Analyst part 2 Exam Questions &
Answers (Grade A+)
How many inactive relationships are there in the model shown
above?
1
2
3
None -
correct answer ✅1
The dotted line connecting the Calendar and Sales tables is an
inactive one-to-many relationship. The other two relationships are
active.
Which of these functions can be used to activate inactive
relationships?
RELATED
RELATEDTABLE
USERELATIONSHIP
,PL-300: Microsoft Power BI Data
Analyst part 2 Exam Questions &
Answers (Grade A+)
ACTIVATE -
correct answer ✅USERELATIONSHIP
The USERELATIONSHIP function allows you to determine which
relationship to use between to tables, including inactive
relationships.
If you import or create your own date table, which of these
requirements must it meet?
Must contain all the days for all years represented in the model
Cannot contain duplicate dates
Must have at least one field set as a Date or DateTime datatype
All of the above -
correct answer ✅All of the above
,PL-300: Microsoft Power BI Data
Analyst part 2 Exam Questions &
Answers (Grade A+)
To import or create your own date table, it must meet all 3 of these
requirements, and all times must be identical (i.e. 12:00).
You are creating a report in Power BI Desktop.
You are consuming the following tables.
You have a new table named Fiscal that has the same schema as
the Date table, but contains the fiscal dates of your company.
You need to create a report that displays the total sales by fiscal
month and calendar month.
What should you do?
Union Fiscal and Date as one table.
Add Fiscal to the model and create a one-to-many relationship by
using Date[Year] and Fiscal[Year].
, PL-300: Microsoft Power BI Data
Analyst part 2 Exam Questions &
Answers (Grade A+)
Add Fiscal to the model and create a one-to-one relationship by
using Date[Year] and Fiscal[Year].
Merge Fiscal into the Date table. -
correct answer ✅Merge Fiscal into the Date table.
Same schema.
You have a Microsoft Excel 2016 workbook that has a Power Pivot
model. The model contains the following tables:
- Product (Product_id, Product_Name)
- Sales (Order_id, Order_Date, Product_id, Salesperson_id,
Sales_Amount)
- Salesperson (Salesperson_id, Salesperson_name, address)
The model has the following relationships:
- Sales to Product
- Sales to Salesperson
