Exam Name: | Microsoft Power BI Data Analyst | ||
Exam Code: | PL-300 Dumps | ||
Vendor: | Microsoft | Certification: | Microsoft Certified: Power BI Data Analyst Associate |
Questions: | 386 Q&A's | Shared By: | bianca |
You need to create the semantic model.
Which storage mode should you use for the tables in the semantic model?
Options:
live connection
Dual
Import
DirectQuery
You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Options:
Answer:
Explanation:
Box 1: many-to-one
Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
The Suppliers table has a Region column.
Box 2: Suppliers table
You need to create a solution to meet the notification requirements of the warehouse shipping department.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct select is worth one point:
Options:
You need to create a measure that will return the percentage of late orders.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Options:
Answer:
Explanation:
Box 1: CALCULATE
CALCULATE evaluates an expression in a modified filter context.
Syntax: CALCULATE(
Expression - The expression to be evaluated.
filter1, filter2,… (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.
Box 2: FILTER
FILTER returns a table that represents a subset of another table or expression.
Syntax: FILTER(