Oracle Big Data 2017 Implementation Essentials

Question 1

During a meeting with your customer's IT security team, you are asked the names of the main OS users and groups for the Big Data Appliance.
Which users are created automatically during the installation of the Oracle Big Data
Appliance?

A. hbase, cdh5, and oracle

B. bda, cdh5, and oracle

C. mapred, bda, and engsys

D. flume, hbase, and hdfs

Correct Answer: D

Question 2

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

B. native MapReduce Java programs

C. HiveFastQL

D. Apache Grunt

Correct Answer: A

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

Question 3

Your customer wants to architect a system that helps to make real-time recommendations to users based on their past search history.
Which solution should the customer use?

A. Oracle Exadata

B. Oracle Data Integrator

C. Oracle NoSQL

D. Oracle Container Database

Correct Answer: B

Explanation: Only visible for Actualtests4sure 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. Impala

B. Hadoop cluster

C. HiveQL

D. Oracle database

E. Oracle NoSQL

Correct Answer: B,D

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

Question 5

Your customer has a Big Data Appliance and an Exadata Database Machine and would like to extend security. Select two ways that security works in Big Data SQL. (Choose two.)

A. On the Big Data Appliance, data is encrypted by using Oracle Transparent Data
Encryption (TDE).

B. On the Big Data Appliance, Oracle Advanced Hadoop Security is used for fine grained access control.

C. On the Big Data Appliance, Oracle Identity Management is used.

D. On the Exadata Database Machine, Oracle Advanced Security is used for fine-grained access control.

E. On the Big Data Appliance, Hadoop's native security is used.

Correct Answer: A,D

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

Question 6

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. Move the data into the warehousing database.

B. Use Oracle Data Integrator to improve performance.

C. Offload the data into Hadoop.

D. Denormalize the data.

Correct Answer: C

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

Question 7

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 flume agent to capture the transactions and write them to HDFS.

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

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

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

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

Correct Answer: A

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

Question 8

You need to place the results of a PigLatin script into an HDFS output directory.
What is the correct syntax in Apache Pig?

A. place D into './output';

B. hdfsstore D into './output';

C. update hdfs set D as './output';

D. write D as './output';

E. store D into './output';

Correct Answer: E

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

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

Latest Update

Useful Links

Contact Us