Microsoft Exam 70-464 Topic 10 Question 3 Discussion

You have a database that contains a user-defined function named Schema1.Udf1 and two tables named Schema1.Table1 and Schema1.Table2.

Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as shown in the following table.

Schema1.Udf1 was defined by using the following code:

You need to write a query that will contain the following columns:

*Country

*CountryID

*CustomerName

The solution must meet the following requirements:

*Rows must be returned only if the function returns data.

*The amount of time it takes the query to execute must be minimized.

Which query should you use?