Online Access Free 1z0-449 Exam Questions

You need to create an architecture for your customer's Oracle NoSQL KVStore. The customer needs to store clinical and non-clinical data together but only the clinical data is mission critical.
How can both types of data exist in the same KVStore?

• A.Store the two types of data with differing consistency policies.
• B.Store the two types of data in separate partitions on highly available storage.
• C.Store the clinical data on the master node and the non-clinical data on the replica nodes.
• D.Store the two types of data in two separate KVStore units and create database aliases to mimic one KVStore.

What are three correct results of executing the preceding query? (Choose three.)

• A.Values longer than 100 characters for any column are truncated.
• B.ITEM_CNT in the HDFS file matches ORDER_LINE_ITEM_COUNT in the external table.
• C.Values longer than 100 characters for the DESCRIPTION column are truncated.
• D.ORDER_LINE_ITEM_COUNT in the HDFS file matches ITEM_CNT in the external table.
• E.Errors in the data for CUST_NUM or ORDER_NUM set the value to INVALID_NUM.
• F.Errors in the data for CUST_NUM or ORDER_NUM set the value to 0000000000.

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.xxx
• B.456
• C.x/y
• D.xyz
• E.123

During a meeting with your customer's IT security team, you are asked the names of the main OS users and groups for the Big Data Appliance.
Which users are created automatically during the installation of the Oracle Big Data
Appliance?

• A.mapred, bda, and engsys
• B.hbase, cdh5, and oracle
• C.bda, cdh5, and oracle
• D.flume, hbase, and hdfs

Identify two valid steps for setting up a Hive-to-Hive transformation by using Oracle Data
Integrator. (Choose two.)

• A.Create a Logical Schema object.
• B.Ensure that Apache Sentry is configured.
• C.Configure ODI by using the mammoth utility.
• D.Ensure that the Hive server is up and running.