Your customer has three XML files in HDFS with the following contents. Each XML file contains comments made by users on a specific day. Each comment can have zero or more “likes” from other users. The customer wants you to query this data and load it into the Oracle Database on Exadata.
How should you parse this data?
Select an option, then click Submit answer.
-
○
by creating a table in Hive and using MapReduce to parse the XML data by column
-
○
by configuring the Oracle SQL Connector for HDFS and parsing by using SerDe
-
○
by using the XML file module in the Oracle XQuery for Hadoop Connector
-
○
by using the built-in functions for reading JSON in the Oracle XQuery for Hadoop Connector
