Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 82 discussion

Actual exam question from Microsoft's PL-300

Question #: 82
Topic #: 2

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

Suggested Answer: C 🗳️

by Stehi at Feb. 28, 2024, 12:33 p.m.

Comments

Submit Cancel

INDEAVR

Highly Voted 1 year, 4 months ago

Selected Answer: C

C. all the rows in ProductsGroupA that have a matching row in ProductsGroupB

upvoted 13 times

...

jaume

Most Recent 7 months, 3 weeks 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

10 months, 3 weeks ago

Selected Answer: C

C - all the rows in ProductsGroupA that have a matching row in ProductsGroupB

upvoted 1 times

...

shahrzadkhb

1 year 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, 3 months 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, 3 months 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, 4 months 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, 4 months ago

Answer: C

upvoted 2 times

...

Florinuca

1 year, 4 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, 4 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

...