Performing Joins Using Merge Queries in Power BI

 

Question:

You are performing a fuzzy merge on two queries in Power BI. At which level of similarity threshold will you only join exact matches?

• 1

Question

:

You are performing a full outer join using a Power BI merge query. Which rows, from the first and second tables, will this join retain in the output?

• All the rows of both the tables

Question

:

This is an image visualizing a kind of join operation between tables. Which is the type of join performed here?

• Left anti join

Question

:

This is an image of a relationship between two tables Products and Orders. Please identify the cardinality and cross-filtering setting for this relationship.

• One-to-many, single

Question

:

You are performing a left anti-join using a Power BI merge query. Which rows, from the first and second tables, will this join retain in the output?

• Only the non-matching rows from the first table

Question

:

This is a table visualizing the sales in different categories for different countries, and you have pivoted this table in Power BI on the Category column, with aggregation SUM for Order Amount. What will the output table look like?

• A

Question

:

This is an image visualizing a kind of join operation between tables. What is the type of join performed here?

Answer D.

• Left outer join

Question

:

You are performing a fuzzy join, and observe that there are some matches, such as Australia and AUS, that cannot be made no matter how much you reduce the similarity threshold. What can you use to fix this issue?

• Transformation tables

Question

:

This is an image visualizing a kind of join operation between tables. What is the type of join performed here?

• Right outer join

Question

:

You have two queries which you are performing a fuzzy join on. What will lowering the similarity threshold for this join achieve?

• There are likely to be more mistakes

• More of the values will be matched

Question

:

You are performing a fuzzy join using a Power BI merge query. Which statement explains how fuzzy joins work?

• A join where the matches are not exact, but rather they account for spelling mistakes etc.

Question

:

You are performing an inner join using a Power BI merge query. Which rows, from the first and second tables, will this join retain in the output?

• Only the matching rows from both the tables

Categories: Power BI