70-465 · Question #159
Drag and Drop Question You define a table by using the following statement. The Teachers table contains one million records. A sample record of the XML data output is as follows: You plan to create…
The correct answer is E. ON F. ONLINE G. REBUILD. For XML columns queried based on a specific element like 'grade', the optimal indexing strategy is to create a Primary XML Index on the XML column first (required as a prerequisite), then create a Secondary XML Index using the PATH type specifically on the grade field. The PATH…
Question
Exhibits
Options
- A1
- BBLOCKERS
- CFILLFACTOR
- DOFF
- EON
- FONLINE
- GREBUILD
- HREORGANIZE
How the community answered
(27 responses)- A4% (1)
- B4% (1)
- D7% (2)
- G70% (19)
- H15% (4)
Explanation
For XML columns queried based on a specific element like 'grade', the optimal indexing strategy is to create a Primary XML Index on the XML column first (required as a prerequisite), then create a Secondary XML Index using the PATH type specifically on the grade field. The PATH secondary XML index is designed to optimize queries that specify a particular XML path/element, minimizing index size compared to VALUE or PROPERTY indexes while maximizing query performance for path-based lookups on a specific element like grade.
Topics
Community Discussion
No community discussion yet for this question.

