oracle 1z0-449 practice test

You want to set up access control lists on your NameNode in your Big Data Appliance. However,
when you try to do so, you get an error stating “the NameNode disallows creation of ACLs.”
What is the cause of the error?
A. During the Big Data Appliance setup, Cloudera's ACLSecurity product was not installed.
B. Access control lists are set up on the DataNode and HadoopNode, not the NameNode.
C. During the Big Data Appliance setup, the Oracle Audit Vault product was not installed.
D. dfs.namenode.acls.enabled must be set to true in the NameNode configuration.

Your customer has an older starter rack Big Data Appliance (BDA) that was purchased in 2013. The
customer would like to know what the options are for growing the storage footprint of its server.
Which two options are valid for expanding the customer’s BDA footprint? (Choose two.)

• A. Elastically expand the footprint by adding additional high capacity nodes.
• B. Elastically expand the footprint by adding additional Big Data Oracle Database Servers.
• C. Elastically expand the footprint by adding additional Big Data Storage Servers.
• D. Racks manufactured before 2014 are no longer eligible for expansion.
• E. Upgrade to a full 18-node Big Data Appliance.

What are three correct results of executing the preceding query? (Choose three.)
A. Values longer than 100 characters for the DESCRIPTION column are truncated.
B. ORDER_LINE_ITEM_COUNT in the HDFS file matches ITEM_CNT in the external table.
C. ITEM_CNT in the HDFS file matches ORDER_LINE_ITEM_COUNT in the external table.
D. Errors in the data for CUST_NUM or ORDER_NUM set the value to INVALID_NUM.
E. Errors in the data for CUST_NUM or ORDER_NUM set the value to 0000000000.
F. Values longer than 100 characters for any column are truncated.

What does the following line do in Apache Pig?
products = LOAD ‘/user/oracle/products’ AS (prod_id, item);
A. The products table is loaded by using data pump with prod_id and item.
B. The LOAD table is populated with prod_id and item.
C. The contents of /user/oracle/products are loaded as tuples and aliased to products.
D. The contents of /user/oracle/products are dumped to the screen.

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

The NoSQL KVStore experiences a node failure. One of the replicas is promoted to primary.
How will the NoSQL client that accesses the store know that there has been a change in the
architecture?
A. The KVLite utility updates the NoSQL client with the status of the master and replica.
B. KVStoreConfig sends the status of the master and replica to the NoSQL client.
C. The NoSQL admin agent updates the NoSQL client with the status of the master and replica.
D. The Shard State Table (SST) contains information about each shard and the master and replica
status for the shard.

Your customer is experiencing significant degradation in the performance of Hive queries. The
customer wants to continue using SQL as the main query language for the HDFS store.
Which option can the customer use to improve performance?
A. native MapReduce Java programs
B. Impala
C. HiveFastQL
D. Apache Grunt

Your customer keeps getting an error when writing a key/value pair to a NoSQL replic
a.
What is causing the error?
A. The master may be in read-only mode and as result, writes to replicas are not being allowed.
B. The replica may be out of sync with the master and is not able to maintain consistency.
C. The writes must be done to the master.
D. The replica is in read-only mode.
E. The data file for the replica is corrupt.

The log data for your customer's Apache web server has seven string columns.
What is the correct command to load the log data from the file 'sample.log' into a new Hive table
LOGS that does not currently exist?
A. hive> CREATE TABLE logs (t1 string, t2 string, t3 string, t4 string, t5 string, t6 string, t7 string) ROW
FORMAT DELIMITED FIELDS TERMINATED BY ' ';
B. hive> create table logs as select * from sample.log;
C. hive> CREATE TABLE logs (t1 string, t2 string, t3 string, t4 string, t5 string, t6 string, t7 string) ROW
FORMAT DELIMITED FIELDS TERMINATED BY ' ';hive> LOAD DATA LOCAL INPATH 'sample.log'
OVERWRITE INTO TABLE logs;
D. hive> LOAD DATA LOCAL INPATH 'sample.log' OVERWRITE INTO TABLE logs;hive> CREATE TABLE
logs (t1 string, t2 string, t3 string, t4 string, t5 string, t6 string, t7 string) ROW FORMAT DELIMITED
FIELDS TERMINATED BY ' ';
E. hive> create table logs as load sample.1og from hadoop;

Your customer’s Oracle NoSQL store has a replication factor of 3. One of the customer’s replica nodes
goes down.
What will be the long-term performance impact on the customer’s NoSQL database if the node is
replaced?
A. There will be no performance impact.
B. The database read performance will be impacted.
C. The database read and write performance will be impacted.
D. The database will be unavailable for reading or writing.
E. The database write performance will be impacted.