Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
INDEAVR
Highly Voted 8 months, 3 weeks ago
Selected Answer: C
C. all the rows in ProductsGroupA that have a matching row in ProductsGroupB
upvoted 12 times
...
jaume
Most Recent 1 day, 10 hours 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
3 months ago
Selected Answer: C
C - all the rows in ProductsGroupA that have a matching row in ProductsGroupB
upvoted 1 times
...
shahrzadkhb
5 months, 1 week 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
8 months, 2 weeks 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
8 months, 2 weeks ago
Intersect is not commutative. In general, Intersect(T1, T2) will have a different result set than Intersect(T2, T1).
upvoted 1 times
...
...
rajukg
8 months, 3 weeks 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
8 months, 3 weeks ago
Answer: C
upvoted 1 times
...
...
Florinuca
8 months, 3 weeks 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
8 months, 3 weeks 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
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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