← Back to exam page

1z0-449 – Oracle Big Data 2016 Implementation Essentials

Loading demo links...

Showing 7–9 of 10 questions

Question 7

What is the output of the following six commands when they are executed by using the Oracle XML Extensions for Hive in the Oracle XQuery for Hadoop Connector?

1. $ echo "xxx" > src.txt

2. $ hive --auxpath $OXH_HOME/hive/lib -i $OXH_HOME/hive/init.sql

3. hive> CREATE TABLE src (dummy STRING);

4. hive> LOAD DATA LOCAL INPATH 'src.txt' OVERWRITE INTO TABLE src;

5. hive> SELECT * FROM src;

OK

xxx

6. hive> SELECT xml_query ("x/y", "123456") FROM src;

Select an option, then click Submit answer.

  • ○

    xyz
  • ○

    123
  • ○

    456
  • ○

    xxx
  • ○

    x/y
Question 8

Your customer needs to analyze large numbers of log files after combining them with customer profile and interaction data. The customer wants to be able to analyze these files back to their go-live date, which was last October.

Which solution should you choose to accomplish this?

Select an option, then click Submit answer.

  • ○

    Oracle Database
  • ○

    Hadoop
  • ○

    Berkeley DB
  • ○

    Oracle NoSQL
Question 9

The hdfs_stream script is used by the Oracle SQL Connector for HDFS to perform a specific task to access data.

What is the purpose of this script?

Select an option, then click Submit answer.

  • ○

    It is the preprocessor script for the Impala table.
  • ○

    It is the preprocessor script for the HDFS external table.
  • ○

    It is the streaming script that creates a database directory.
  • ○

    It is the preprocessor script for the Oracle partitioned table.
  • ○

    It defines the jar file that points to the directory where Hive is installed.