Oracle Big Data 2017 Implementation Essentials - 1z1-449 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What kind of workload is MapReduce designed to handle?

A. computational B. batch processing C. commodity D. interactive E. real time

Discussion 0

Correct Answer: B Vote an answer

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

Question 2

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 Container Database D. Oracle NoSQL

Discussion 0

Correct Answer: B Vote an answer

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

Question 3

You are helping your customer troubleshoot the use of the Oracle Loader for Hadoop
Connector in online mode. You have performed steps 1, 2, 4, and 5.
STEP 1: Connect to the Oracle database and create a target table.
STEP 2: Log in to the Hadoop cluster (or client).
STEP 3: Missing step
STEP 4: Create a shell script to run the OLH job.
STEP 5: Run the OLH job.
What step is missing between step 2 and step 4?

A. Copy the table metadata to the Hadoop system. B. Query the table to check the data. C. Diagnose the job failure and correct the error. D. Create an OLH metadata file. E. Create an XML configuration file.

Discussion 0

Correct Answer: E Vote an answer

Question 4

What are three correct results of executing the preceding query? (Choose three.)

A. Errors in the data for CUST_NUM or ORDER_NUM set the value to 0000000000. B. Values longer than 100 characters for any column are truncated. C. ITEM_CNT in the HDFS file matches ORDER_LINE_ITEM_COUNT in the external table. D. Errors in the data for CUST_NUM or ORDER_NUM set the value to INVALID_NUM. E. Values longer than 100 characters for the DESCRIPTION column are truncated. F. ORDER_LINE_ITEM_COUNT in the HDFS file matches ITEM_CNT in the external table.

Discussion 0

Correct Answer: C,D,E Vote an answer

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

Question 5

Your customer's Hadoop cluster displays an error while running a MapReduce task by using Yarn. The error states that a container could not be created.
Which resource in Yarn creates containers?

A. NameNode B. MasterNode C. Node Manager D. Task Tracker E. Resource Manager

Discussion 0

Correct Answer: C Vote an answer

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

Question 6

What access driver does the Oracle SQL Connector for HDFS use when reading HDFS data by using external tables?

A. ORACLE_BDSQL B. ORACLE_HDP C. ORACLE_DATA_PUMP D. ORACLE_HIVE_LOADER E. HADOOP_LOADER F. ORACLE_LOADER

Discussion 0

Correct Answer: F Vote an answer

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

Question 7

For Oracle R Advanced Analytics for Hadoop to access the data stored in HDFS, what must the input files comply with?

A. Oracle R Advanced Analytics does not have any restrictions on input files. B. Only input files with an underscore (_) are processed. C. All the input files for a MapReduce job must be stored in one directory as part of one logical file. D. Only files with tab delimiters are supported.

Discussion 0

Correct Answer: C Vote an answer

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

Question 8

Your customer has a requirement to use Oracle Database to access and analyze the data that resides in Apache Hadoop.
What is the result of executing the following command when using Oracle SQL Connector for Hadoop?

A. Hadoop is configured over JDBC to connect to the Oracle database by using Big Data
SQL. B. A Hive table called SALES_HIVE_XTAB is created. C. An external table called SALES_HIVE_XTAB is created to read data from a Hive table. D. An external table called SALES_HIVE_XTAB is created to write data from a Hadoop table.

Discussion 0

Correct Answer: C Vote an answer

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