Oracle 1z0-449 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z0-449
Exam Name/Title: Oracle Big Data 2017 Implementation Essentials
Certification Provider: Oracle
Corresponding Certification: Oracle Big Data Appliance

Exam Questions: 72
Updated On: Jun 26, 2026

Question #9

How does increasing the number of storage nodes and shards impact the efficiency of
Oracle NoSQL Database?

A. Having more shards reduces the write throughput because of increased node forwarding.

B. The number of shards or storage nodes does not impact performance.

C. Having more shards increases the write throughput because more master nodes are available for writes.

D. Having more shards results in reduced read throughput because of increased node forwarding.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #10

Your customer has a requirement to use Oracle Database to access and analyze the data that resides in Apache Hadoop.
What is the result of executing the following command when using Oracle SQL Connector for Hadoop?

A. A Hive table called SALES_HIVE_XTAB is created.

B. An external table called SALES_HIVE_XTAB is created to write data from a Hadoop table.

C. Hadoop is configured over JDBC to connect to the Oracle database by using Big Data
SQL.

D. An external table called SALES_HIVE_XTAB is created to read data from a Hive table.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #11

Your customer has 10 web servers that generate logs at any given time. The customer would like to consolidate and load this data as it is generated into HDFS on the Big Data
Appliance.
Which option should the customer use?

A. Set up a zookeeper agent to capture the transactions and write them to HDFS.

B. Set up a flume agent to capture the transactions and write them to HDFS.

C. Write a hive query to listen for new logs and save them in a Hive table.

D. Set up an hbase agent to capture the transactions and write them to HDFS.

E. Set up a web server agent in Apache Oozie to write the data to HDFS.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #12

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. HiveFastQL

B. Impala

C. Apache Grunt

D. native MapReduce Java programs

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #13

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 is the streaming script that creates a database directory.

B. It is the preprocessor script for the Impala table.

C. It is the preprocessor script for the Oracle partitioned table.

D. It is the preprocessor script for the HDFS external table.

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

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #14

Your customer needs to move data from Hive to the Oracle database but does have any connectors purchased.
What is another architectural choice that the customer can make?

A. Use Apache Sentry.

B. Use Apache Pig.

C. Use Apache Sqoop.

D. Export data from Hive by using export/import.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #15

How should you control the Sqoop parallel imports if the data does not have a primary key?

A. by indicating the split size by using the --direct-split-size option

B. by specifying no primary key with the --no-primary argument

C. by specifying the number of maps by using the -m option

D. by choosing a different column that contains unique data with the --split-by argument

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #16

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 as load sample.1og from hadoop;

B. 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 ' ';

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> create table logs as select * from sample.log;

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 ' ';

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Download Free Oracle 1z0-449 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z0-449 exam.