Online Access Free 1z1-449 Practice Test

Identify two ways to create an external table to access Hive data on the Big Data Appliance by using Big Data SQL. (Choose two.)

• A.Use the Enterprise Manager Big Data SQL Configuration page to create the table.
• B.You can use the dbms_hadoop.create_extdd1_for_hive package to return the text of the
  CREATE TABLE command.
• C.Use Cloudera Manager's Big Data SQL Query builder.
• D.Use a CREATE table statement with ORGANIZATION EXTERNAL and the
  ORACLE_HIVE access parameter.
• E.Use a CREATE table statement with ORGANIZATION EXTERNAL and the
  ORACLE_BDSQL access parameter.

You are attempting to start KVLite but get an error about the "port being in use".
What is the reason for the error?

• A.The listener was not started.
• B.KVStore was also running, and KVStore and KVLite cannot run simultaneously on the same server.
• C.The port was not specified so the default port 3889 (the same port as Enterprise Manager) was used.
• D.KVLite was trying to register on port 5000 when it was already running.

Your customer is worried that the redundancy of HDFS will not meet its needs. The customer needs to store certain files with higher levels of redundancy than other files.
Which architectural feature of HDFS should you choose?

• A.Automatic Storage Management, which can be used to multiplex the data
• B.the replication factor, which can be set at the file level
• C.Apache Impala, which can be used to set the duplex level for each file
• D.Apache Scala on top of MapReduce, which allows you to store files at various redundancies

Your customer wants to architect a system that helps to make real-time recommendations to users based on their past search history.
Which solution should the customer use?

• A.Oracle NoSQL
• B.Oracle Data Integrator
• C.Oracle Container Database
• D.Oracle Exadata

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", "<x><y>123</y><z>456</z></x>") FROM src;

• A.456
• B.xxx
• C.123
• D.x/y
• E.xyz