70-433 Question #82: Real Exam Question with Answer & Explanation

You create and populate a table named SiteNavigation by using the following statements: CREATE TABLE SiteNavigation ( SiteNavigationId INT PRIMARY KEY, Linktext VARCHAR(10), LinkUrl VARCHAR(40), ParentSiteNavigationId INT NULL REFERENCES SiteNavigation(SiteNavigationId) ) You are tasked to write a query to list all site references that are more than two levels from the root node. The query should produce the following results: LinkText LinkUrl DistanceFromRoot You have written the following query: WITH DisplayHierarchy AS (SELECT LinkText, LinkUrl, SiteNavigationId, ParentSiteNavigationId, 0 AS DistanceFromRoot FROM SiteNavigation WHERE ParentSiteNavigationId IS NULL UNION ALL SELECT SiteNavigation.LinkText, SiteNavigation.LinkUrl, SiteNavigation.SiteNavigationId, SiteNavigation.ParentSiteNavigationId, dh.DistanceFromRoot + 1 AS DistanceFromRoot FROM SiteNavigation INNER JOIN DisplayHierarchy dh ON SiteNavigation.ParentSiteNavigationId = dh.SiteNavigationId) SELECT LinkText, LinkUrl, DistanceFromRoot FROM DisplayHierarchy You need to append a WHERE clause to the query. Which clause should you use?