Online Access Free 1z1-449 Practice Test

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?

• A.It defines the jar file that points to the directory where Hive is installed.
• B.It is the preprocessor script for the HDFS external table.
• C.It is the preprocessor script for the Oracle partitioned table.
• D.It is the preprocessor script for the Impala table.
• E.It is the streaming script that creates a database directory.

Which user in the following set of ACL entries has read, write and execute permissions? user::rwx group::r-x other::r-x
default:user::rwx
default:user:bruce:rwx #effective:r-x
default:group::r-x
default:group:sales:rwx #effective:r-x
default:mask::r-x
default:other::r-x

• A.user
• B.sales
• C.all users
• D.hdfs
• E.bruce

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.The database read and write performance will be impacted.
• B.The database will be unavailable for reading or writing.
• C.There will be no performance impact.
• D.The database write performance will be impacted.
• E.The database read performance will be impacted.

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> 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 ' ';
• B.hive> create table logs as load sample.1og from hadoop;
• C.hive> create table logs as select * from sample.log;
• D.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;
• E.hive> CREATE TABLE logs (t1 string, t2 string, t3 string, t4 string, t5 string, t6 string, t7 string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ';

The Hadoop NameNode is running on port #3001, the DataNode on port #4001, the
KVStore agent on port #5001, and the replication node on port #6001. All the services are running on localhost.
What is the valid syntax to create an external table in Hive and query data from the NoSQL
Database?

• A.CREATE EXTERNAL TABLE IF NOT EXISTSMOVIE( id INT,original_title
  STRING,overview STRING)STORED BY
  'oracle.kv.hadoop.hive.table.TableStorageHandler'TBLPROPERTIES ("oracle.kv.kvstore
  "=" kvstore
  ","oracle.kv.hosts"="localhost:5001","oracle.kv.hadoop.hosts"="localhost","oracle.kv.tab1eN ame"="MOVIE");
• B.CREATE EXTERNAL TABLE IF NOT EXISTSMOVIE( id INT,original_tit1e
  STRING,overview STRING)STORED BY
  'oracle.kv.hadoop.hive.table.TableStorageHandler'TBLPROPERTIES
  ("oracle.kv.kvstore"="kvscore","oracle.kv.hosts"="localhost:3001","oracle.kv.hadoop.hosts"
  = "localhost","oracle.kv.tableName"= MOVIE");
• C.CREATE EXTERNAL TABLE IF NOT EXISTSMOVIE( id INT,original_title
  STRING,overview STRING)STORED BY
  'oracle,kv.hadoop.hive.table.TableStorageHandler'TBLPROPERTIES
  ("oracle.kv.kvstore"="kvstore","oracle.kv.hosts"="localhost:4001","oracle.kv.hadoop.hosts"=
  "localhost","oracle.kv.tab1eName"="MOVIE");
• D.CREATE EXTERNAL TABLE IF NOT EXISTSMOVIE( id INT,original_title
  STRING,overview STRING)STORED BY
  'oracle,kv.hadoop.hive.table.TableStorageHandler'TBLPROPERTIES
  ("oracle.kv.kvstore"="kvstore","oracle.kv.hosts"="localhost:6001","oracle.kv.hadoop.hosts"=
  "localhost","oracle.kv.tab1eName"="MOVIE");