1z0-449 by Oracle Valid Free Exam Practice Test

Question 1

Your customer's IT staff is made up mostly of SQL developers. Your customer would like you to design a system to analyze the spending patterns of customers in the web store.
The data resides in HDFS.
What tool should you use to meet their needs?

A. Oracle Database 12c B. SQL Developer C. Apache Hive D. Oracle Data Integrator E. MapReduce

Correct Answer: B

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

Question 2

Your customer is spending a lot of money on archiving data to comply with government regulations to retain data for 10 years.
How should you reduce your customer's archival costs?

A. Use Oracle Data Integrator to improve performance. B. Offload the data into Hadoop. C. Move the data into the warehousing database. D. Denormalize the data.

Correct Answer: B

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

Question 3

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. Store the information in an Oracle wallet and configure the wallet location in the configuration file. D. Encrypt the password in the configuration file by using Transparent Data Encryption.

Correct Answer: C

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

Question 4

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. Oracle NoSQL B. Impala C. Oracle database D. HiveQL E. Hadoop cluster

Correct Answer: C,E

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

Question 5

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. the replication factor, which can be set at the file level B. Apache Impala, which can be used to set the duplex level for each file C. Automatic Storage Management, which can be used to multiplex the data D. Apache Scala on top of MapReduce, which allows you to store files at various redundancies

Correct Answer: A

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

Question 6

Your customer's security team needs to understand how the Oracle Loader for Hadoop
Connector writes data to the Oracle database.
Which service performs the actual writing?

A. map tasks B. write tasks C. reduce tasks D. NameNode E. OLH agent

Correct Answer: C

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

Question 7

Your customer needs to analyze large numbers of log files after combining them with customer profile and interaction data. The customer wants to be able to analyze these files back to their go-live date, which was last October.
Which solution should you choose to accomplish this?

A. Oracle NoSQL B. Berkeley DB C. Oracle Database D. Hadoop

Correct Answer: D

Question 8

Identify two features of the Hadoop Distributed File System (HDFS). (Choose two.)

A. It is written to store large amounts of data. B. The file system is written in Java. C. The file system is written in C#. D. It consists of Mappers, Reducers, and Combiners.

Correct Answer: A,B

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

Oracle Big Data 2017 Implementation Essentials - 1z0-449 Exam Practice Test