Oracle Big Data 2017 Implementation Essentials - 1z1-449 Exam Questions [2026]

QUESTION NO: 1
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. sales B. user C. all users D. hdfs E. bruce

Correct Answer: B

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

QUESTION NO: 2
Your customer keeps getting an error when writing a key/value pair to a NoSQL replica.
What is causing the error?

A. The replica is in read-only mode. B. The replica may be out of sync with the master and is not able to maintain consistency. C. The master may be in read-only mode and as result, writes to replicas are not being allowed. D. The writes must be done to the master. E. The data file for the replica is corrupt.

Correct Answer: D

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

QUESTION NO: 3
Your customer is setting up an external table to provide read access to the Hive table to
Oracle Database.
What does hdfs:/user/scott/data refer to in the external table definition for the Oracle SQL
Connector for HDFS?

A. the location of the Oracle data file for SALES_DP_XTAB B. the location for the log directory C. the default directory for the Oracle external table D. the local file system location for the data E. the location of the HDFS input data

Correct Answer: E

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

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

A. by choosing a different column that contains unique data with the --split-by argument 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 indicating the split size by using the --direct-split-size option

Correct Answer: A

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

QUESTION NO: 5
What are two reasons that a MapReduce job is not run when the following command is executed in Hive? (Choose two.) hive> create view v_consolidated_credit_products as select hcd.customer_id, hcd.credit_card_limits, hcd.credit_balance, hmda.n_mortgages, hmda.mortgage_amount from mortgages_department_agg hmda join credit_department hcd on hcd.customer_id=hmda.customer_id;
OK
Time taken: 0.316 seconds

A. The MapReduce job is run when the view is accessed. B. MapReduce is run in the background. C. MapReduce is not run with Hive. Hive bypasses the MapReduce layer. D. MapReduce is run; the command output is incorrect. E. A view only defines the metadata in the RDBMS store.

Correct Answer: A,E

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

QUESTION NO: 6
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. Access control lists are set up on the DataNode and HadoopNode, not the NameNode. B. During the Big Data Appliance setup, Cloudera's ACLSecurity product was not installed. C. dfs.namenode.acls.enabled must be set to true in the NameNode configuration. D. During the Big Data Appliance setup, the Oracle Audit Vault product was not installed.

Correct Answer: C

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

QUESTION NO: 7
Your customer wants you to set up ODI by using the IKM SQL to Hive module and overwrite existing Hive tables with the customer's new clinical data.
What parameter must be set to true?

A. OVERWRITE_HIVE_TABLE B. CREATE_HIVE_TABLE C. OVERWRITE_HDFS_TABLE D. SQOOP_ODI_OVERWRITE

Correct Answer: B

QUESTION NO: 8
Which command should you use to view the contents of the HDFS directory,
/user/oracle/logs?

A. hadoop fs -listfiles /user/oracle/logs B. hadoop fs -ls /user/oracle/logs C. cd /user/oraclehadoop fs -ls logs D. cd /user/oracle/logshadoop fs -ls * E. hive> select * from /user/oracle/logs F. hadoop fs -cat /user/oracle/logs

Correct Answer: B

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