Create Next App

Exam contains 69 questions

Page 5 of 12

Question 25 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

D. performs scalable joins between Hadoop and Oracle Database data

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 26 🔥

Your customer has three XML files in HDFS with the following contents. Each XML file contains comments made by users on a specific day. Each comment can have zero or more "likes" from other users. The customer wants you to query this data and load it into the Oracle Database on Exadata.How should you parse this data?

Which database solution meets these requirements?

A. by creating a table in Hive and using MapReduce to parse the XML data by column

Highly voted

B. by configuring the Oracle SQL Connector for HDFS and parsing by using SerDe

Highly voted

C. by using the XML file module in the Oracle XQuery for Hadoop Connector

Highly voted

D. by using the built-in functions for reading JSON in the Oracle XQuery for Hadoop Connector

Highly voted

Discussion of the question

Question 27 🔥

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

Which database solution meets these requirements?

A. Use Cloudera Manager's Big Data SQL Query builder.

Highly voted

B. You can use the dbms_hadoop.create_extdd1_for_hive package to return the text of the CREATE TABLE command.

Highly voted

C. Use a CREATE table statement with ORGANIZATION EXTERNAL and the ORACLE_BDSQL access parameter.

Highly voted

D. Use a CREATE table statement with ORGANIZATION EXTERNAL and the ORACLE_HIVE access parameter.

Highly voted

E. Use the Enterprise Manager Big Data SQL Configuration page to create the table.

Highly voted

Discussion of the question

Question 28 🔥

What are two of the main steps for setting up Oracle XQuery for Hadoop? (Choose two.)

Which database solution meets these requirements?

A. unpacking the contents of oxh-version.zip into the installation directory

Highly voted

B. installing the Oracle SQL Connector for Hadoop

Highly voted

C. configuring an Oracle wallet

Highly voted

D. installing the Oracle Loader for Hadoop

Highly voted

Discussion of the question

Question 29 🔥

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

Which database solution meets these requirements?

A. It is written to store large amounts of data.

Highly voted

B. The file system is written in C#.

Highly voted

C. It consists of Mappers, Reducers, and Combiners.

Highly voted

D. The file system is written in Java.

Highly voted

Discussion of the question

Question 30 🔥

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

Which database solution meets these requirements?

A. update hdfs set D as ‘./output’;

Highly voted

B. store D into ‘./output’;

Highly voted

C. place D into ‘./output’;

Highly voted

D. write D as ‘./output’;

Highly voted

E. hdfsstore D into ‘./output’;

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_449

Exam contains 69 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us