ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 82 discussion

Actual exam question from Microsoft's PL-300
Question #: 82
Topic #: 2
[All PL-300 Questions]

You are reviewing a Power BI data model.

You have a calculated table that has the following definition.

ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB )

You need to identify the results of the DAX expression.

Which rows will be returned in ProductList?

  • A. all the rows in ProductsGroupB that have a matching row in ProductsGroupA
  • B. all the rows in both tables
  • C. all the rows in ProductsGroupA that have a matching row in ProductsGroupB
  • D. all the rows in ProductsGroupA that have no matching row in ProductsGroupB.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Stehi at Feb. 28, 2024, 12:33 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
INDEAVR
Highly Voted 1 year, 2 months ago
Selected Answer: C
C. all the rows in ProductsGroupA that have a matching row in ProductsGroupB
upvoted 13 times
...
jaume
Most Recent 5 months, 1 week ago
Selected Answer: C
INTERSECT return the row-wise intersection of two tables. This means it retrieves only the rows that are present in both table expressions
upvoted 1 times
...
rcaliandro
8 months, 2 weeks ago
Selected Answer: C
C - all the rows in ProductsGroupA that have a matching row in ProductsGroupB
upvoted 1 times
...
shahrzadkhb
10 months, 2 weeks ago
Selected Answer: C
The answer is correct. INTERSECT(<table_expression1>, <table_expression2>) Duplicate rows are retained. If a row appears in table_expression1 and table_expression2, it and any duplicates in table_expression_1 are included in the result set. Reference: https://learn.microsoft.com/sv-se/dax/intersect-function-dax
upvoted 1 times
...
iamamantrivedi
1 year, 1 month ago
The INTERSECT function in DAX is order-independent. It returns the common rows between two tables, regardless of the order in which you specify the tables. both a and c are correct.
upvoted 4 times
1abcd
1 year, 1 month ago
Intersect is not commutative. In general, Intersect(T1, T2) will have a different result set than Intersect(T2, T1).
upvoted 1 times
...
...
rajukg
1 year, 1 month ago
Intersect is not commutative. In general, Intersect(T1, T2) will have a different result set than Intersect(T2, T1). Duplicate rows are retained. If a row appears in table_expression1 and table_expression2, it and all duplicates in table_expression_1 are included in the result set.
upvoted 2 times
rajukg
1 year, 1 month ago
Answer: C
upvoted 2 times
...
...
Florinuca
1 year, 2 months ago
The correct answer is C. See the example : https://learn.microsoft.com/en-us/dax/intersect-function-dax "Intersect is not commutative. In general, Intersect(T1, T2) will have a different result set than Intersect(T2, T1)."
upvoted 1 times
...
Stehi
1 year, 2 months ago
Would not A and C be both correct? ince INTERSECT finds rows that exist in both tables, the statement is correct from the perspective of either table—whether you're looking for matches in ProductsGroupA against ProductsGroupB or vice versa. The result is a table with rows that are common to both.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago