1z0-449 by Oracle Actual Free Exam Q&As

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. Apache Hive B. MapReduce C. SQL Developer D. Oracle Database 12c E. Oracle Data Integrator

Discussion 0

Correct Answer: C Vote an answer

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

Question 2

You need to create an architecture for your customer's Oracle NoSQL KVStore. The customer needs to store clinical and non-clinical data together but only the clinical data is mission critical.
How can both types of data exist in the same KVStore?

A. Store the clinical data on the master node and the non-clinical data on the replica nodes. B. Store the two types of data in separate partitions on highly available storage. C. Store the two types of data with differing consistency policies. D. Store the two types of data in two separate KVStore units and create database aliases to mimic one KVStore.

Discussion 0

Correct Answer: B Vote an answer

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

Question 3

Identify two ways to create an external table to access Hive data on the Big Data Appliance by using Big Data SQL. (Choose two.)

A. Use Cloudera Manager's Big Data SQL Query builder. B. You can use the dbms_hadoop.create_extdd1_for_hive package to return the text of the
CREATE TABLE command. C. Use a CREATE table statement with ORGANIZATION EXTERNAL and the
ORACLE_BDSQL access parameter. D. Use a CREATE table statement with ORGANIZATION EXTERNAL and the
ORACLE_HIVE access parameter. E. Use the Enterprise Manager Big Data SQL Configuration page to create the table.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question 4

How is Oracle Loader for Hadoop (OLH) better than Apache Sqoop?

A. OLH performs a great deal of preprocessing of the data on the Oracle database before loading it into NoSQL. B. OLH does not use MapReduce to process any of the data, thereby increasing performance. C. OLH is fully supported on the Big Data Appliance. Apache Sqoop is not supported on the Big Data Appliance. D. OLH performs a great deal of preprocessing of the data on the Oracle database before loading it into Hadoop. E. OLH performs a great deal of preprocessing of the data on Hadoop before loading it into the database.

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for PassTestking 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, Oracle Advanced Hadoop Security is used for fine grained access control. B. On the Exadata Database Machine, Oracle Advanced Security is used for fine-grained access control. C. On the Big Data Appliance, data is encrypted by using Oracle Transparent Data
Encryption (TDE). D. On the Big Data Appliance, Hadoop's native security is used. E. On the Big Data Appliance, Oracle Identity Management is used.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question 6

What is the output of the following six commands when they are executed by using the
Oracle XML Extensions for Hive in the Oracle XQuery for Hadoop Connector?
1 . $ echo "xxx" > src.txt
2 . $ hive --auxpath $OXH_HOME/hive/lib -i $OXH_HOME/hive/init.sql
3 . hive> CREATE TABLE src (dummy STRING);
4 . hive> LOAD DATA LOCAL INPATH 'src.txt' OVERWRITE INTO TABLE src;
5 . hive> SELECT * FROM src;
OK
xxx
6. hive> SELECT xml_query ("x/y", "<x><y>123</y><z>456</z></x>") FROM src;

A. xyz B. 123 C. x/y D. xxx E. 456

Discussion 0

Correct Answer: B Vote an answer

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

Question 7

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. Connecting to a RAC database is not supported. C. 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. D. 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.

Discussion 0

Correct Answer: C Vote an answer

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

Question 8

What is the result when a flume event occurs for the following single node configuration?

A. The event is written to the netcat process. B. The event output is not defined in this section. C. The event is written to memory. D. The event is sent out on port 44444. E. The event is logged to the screen.

Discussion 0

Correct Answer: E Vote an answer

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

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