Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
C. all the rows in ProductsGroupA that have a matching row in ProductsGroupB Explanation: The INTERSECT function returns the rows that appear in both tables. The result contains only the rows from the first table (ProductsGroupA) that also exist in the second table (ProductsGroupB). It does not return rows from both tables combined, only the matching ones from the first table.
INTERSECT return the row-wise intersection of two tables. This means it retrieves only the rows that are present in both table expressions
C - all the rows in ProductsGroupA that have a matching row in ProductsGroupB