Deal of the Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 70-461 Topic 4 Question 6 Discussion

Actual exam question for Microsoft's 70-461 exam
Question #: 6
Topic #: 4
[All 70-461 Questions]

You generate a daily report according to the following query:

The Sales.ufn.GetLastOrderDate user-defined function (UDF) is defined as follows:

You need to improve the performance of the query.

What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: B

We use a Common Table Expression (TBE) to optimize the query with a predicate pushdown.

Predicate pushdown is an optimization that applies conditions (predicates) as early as possible --- ideally preventing any loading of unneeded rows.



Currently there are no comments in this discussion, be the first to comment!

Save Cancel