EXAM NEWEST ACTUAL EXAM WITH
COMPLETE QUESTIONS AND ANSWERS
GRADED A | BRAND NEW!!!
Which statements are true regarding the RegEx tool's Replace
output method? - ✔✔✔ Correct Answer > When the option to
"copy unmatched text" to output is unchecked, unmatched
values will be empty
When configured to "replace", the RegEx tool appends a
column to the output data that contains the replacement text -
✔✔✔ Correct Answer > False, the replace configuration will
replace values in the original column
Select all the ways in which outgoing data can be split when the
RegEx tool is configured to "Tokenize" - ✔✔✔ Correct Answer >
columns and rows
Select the output method:
,Usernames
JoeMChristineBElizabethB
RegEx
\u{1}\l+\u{1}
Usernames 1 2 3
JoeMChristineBElizabethB JoeM ChristineB ElizabethB - ✔✔✔
Correct Answer > Split to Columns
Choose the statement(s) below that are true regarding the
RegEx tool's Tokenize Output Method - ✔✔✔ Correct Answer >
The Tokenize method allows for simple parsing with a single
marked group in the regular expression
Which changes can be applied to output columns from the
RegEx tool when the Parse output method is selected? - ✔✔✔
Correct Answer > Name, Size, Data Type
Select the combination of values that can be output from the
RegEx Match function - ✔✔✔ Correct Answer > -1, 0
, Choose the statements that are true with respect to the
RegEx_Replace function: - ✔✔✔ Correct Answer > Regular
Expressions must be quoted, the function CAN use a marked
group, and case sensitivity can be enforced with a 4th
parameter
Given the xml sample below, select the names of the child
elements
<book>
<title>Harry Potter and the Sorcerer's Stone</title>
<author>J.K. Rowling</author>
<publication>
<country>USA</country>
<year>1998</year>
</publication>
<book> - ✔✔✔ Correct Answer > title, author, publication,
country, year
Which of the following can not be selected as an element to
parse in the XML Parse tool? - ✔✔✔ Correct Answer > Cousin
Element