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

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

Exam Questions: 72
Updated On: Jul 10, 2026

Question #25

You are helping your customer troubleshoot the use of the Oracle Loader for Hadoop
Connector in online mode. You have performed steps 1, 2, 4, and 5.
STEP 1: Connect to the Oracle database and create a target table.
STEP 2: Log in to the Hadoop cluster (or client).
STEP 3: Missing step
STEP 4: Create a shell script to run the OLH job.
STEP 5: Run the OLH job.
What step is missing between step 2 and step 4?

A. Diagnose the job failure and correct the error.

B. Copy the table metadata to the Hadoop system.

C. Query the table to check the data.

D. Create an OLH metadata file.

E. Create an XML configuration file.

Discussion 0

Correct Answer: E Vote an answer

Question #26

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:6001","oracle.kv.hadoop.hosts"=
"localhost","oracle.kv.tab1eName"="MOVIE");

B. 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");

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:5001","oracle.kv.hadoop.hosts"="localhost","oracle.kv.tab1eN ame"="MOVIE");

D. 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");

Discussion 0

Correct Answer: B Vote an answer

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

Question #27

Your customer needs to access Hive tables, HDFS, and Data Pump format files as the data source.
When installing and configuring the Oracle SQL Connector for HDFS, which two locations must be installed or configured to fulfill this requirement? (Choose two.)

A. Hadoop cluster

B. Oracle NoSQL

C. Impala

D. HiveQL

E. Oracle database

Discussion 0

Correct Answer: A,E Vote an answer

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

Question #28

How does the Sqoop Server handle a job that was discontinued by a restart?

A. by rolling back the load

B. by stopping the loading of data

C. by continuing the loading of data

D. by sending an alert and waiting to resume the job

Discussion 0

Correct Answer: C Vote an answer

Question #29

Which parameter setting will force Impala to execute queries only on the coordinator node?

A. NUM_NODES=1

B. SYNC_DDL=TRUE

C. NUM_SCANNER_THREADS=1

D. DISABLE_UNSAFE_SPILLS=TRUE

Discussion 0

Correct Answer: A Vote an answer

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

Question #30

Which statement is true about the NameNode in Hadoop?

A. If the NameNode goes down and a secondary NameNode has not been defined, the cluster is still accessible.

B. When loading data, the NameNode tells the client or program where to write the data.

C. All data passes through the NameNode; so if it is not sized properly, it could be a potential bottleneck.

D. A query in Hadoop requires a MapReduce job to be run so the NameNode gets the location of the data from the JobTracker.

Discussion 0

Correct Answer: A Vote an answer

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

Question #31

Your customer needs the data that is generated from social media such as Facebook and
Twitter, and the customer's website to be consumed and sent to an HDFS directory for analysis by the marketing team.
Identify the architecture that you should configure.

A. multiple flume agents with collectors that output to a logger that writes to the Oracle
Loader for Hadoop agent

B. a single HDFS agent that collects data from the customer's website, which ls connected to both Facebook and Twitter, and writes via the Hive to the customer's HDFS directory

C. a single flume agent that collects data from the customer's website, which is connected to both Facebook and Twitter, and writes via the collector to the customer's HDFS directory

D. multiple flume agents with sinks that write to a consolidated source with a sink to the customer's HDFS directory

E. multiple HDFS agents that write to a consolidated HDFS directory

Discussion 0

Correct Answer: D Vote an answer

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

Question #32

Your customer wants to implement the Oracle Table Access for a Hadoop Connector
(OTA4H) to connect the Hadooop cluster to the Oracle database. The customer's Oracle
Database is a Real Application Clusters database.
How should you configure the database listener?

A. The database listener is configured to route requests to the designated "hadoop" node in the listener's service definition.

B. The database listener is configured to route the Hadoop connection requests to the first node the RAC cluster because clustered environments are not inherently supported.

C. Connecting to a RAC database is not supported.

D. The database listener is configured to route the Hadoop connection requests to the available nodes randomly, provided that the RAC-aware service name is specified in the
JDBC URL.

Discussion 0

Correct Answer: D Vote an answer

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

Download Free Oracle 1z1-449 Demo

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