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 #33

Your customer is worried that the redundancy of HDFS will not meet its needs. The customer needs to store certain files with higher levels of redundancy than other files.
Which architectural feature of HDFS should you choose?

A. Apache Impala, which can be used to set the duplex level for each file

B. Apache Scala on top of MapReduce, which allows you to store files at various redundancies

C. the replication factor, which can be set at the file level

D. Automatic Storage Management, which can be used to multiplex the data

Discussion 0

Correct Answer: C Vote an answer

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

Question #34

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 #35

You are working with a client who does not allow the storage of user or schema passwords in plain text.
How can you configure the Oracle Loader for Hadoop configuration file to meet the requirements of this client?

A. Configure the configuration file to prompt for the password during remote job executions.

B. Store the password in an Access Control List and configure the ACL location in the configuration file.

C. Encrypt the password in the configuration file by using Transparent Data Encryption.

D. Store the information in an Oracle wallet and configure the wallet location in the configuration file.

Discussion 0

Correct Answer: D Vote an answer

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

Question #36

What two actions do the following commands perform in the Oracle R Advanced Analytics for Hadoop Connector? (Choose two.) ore.connect (type="HIVE") ore.attach ()

A. Connect to NoSQL via Hive.

B. Connect to Hive.

C. Attach the current environment to the search path of R.

D. Attach the Hadoop libraries to R.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #37

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 #38

What is the main purpose of the Oracle Loader for Hadoop (OLH) Connector?

A. provides a SQL-like interface to data that is stored in HDFS

B. runs transformations expressed in XQuery by translating them into a series of
MapReduce jobs that are executed in parallel on a Hadoop cluster

C. accesses and analyzes data in place on HDFS by using external tables

D. is the single SQL point-of-entry to access all data

E. performs scalable joins between Hadoop and Oracle Database data

F. pre-partitions, sorts, and transforms data into an Oracle ready format on Hadoop and loads it into the Oracle database

Discussion 0

Correct Answer: F Vote an answer

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

Question #39

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 #40

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

A. ORDER_LINE_ITEM_COUNT in the HDFS file matches ITEM_CNT in the external table.

B. Values longer than 100 characters for the DESCRIPTION column are truncated.

C. Values longer than 100 characters for any column are truncated.

D. Errors in the data for CUST_NUM or ORDER_NUM set the value to 0000000000.

E. Errors in the data for CUST_NUM or ORDER_NUM set the value to INVALID_NUM.

F. ITEM_CNT in the HDFS file matches ORDER_LINE_ITEM_COUNT in the external table.

Discussion 0

Correct Answer: B,E,F 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.