Free Oracle 1z1-449 Exam Dumps Questions & Answers

Your customer receives data in JSON format.
Which option should you use to load this data into Hive tables?

• A.  Sqoop
• B.  Python
• C.  Flume
• D.  a custom Java program
• E.  SerDe

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.  Diagnose the job failure and correct the error.
• B.  Query the table to check the data.
• C.  Copy the table metadata to the Hadoop system.
• D.  Create an XML configuration file.
• E.  Create an OLH metadata file.

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.  Denormalize the data.
• B.  Offload the data into Hadoop.
• C.  Use Oracle Data Integrator to improve performance.
• D.  Move the data into the warehousing database.

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 Container Database
• B.  Oracle Exadata
• C.  Oracle NoSQL
• D.  Oracle Data Integrator

What does the flume sink do in a flume configuration?

• A.  sinks the log file that is transmitted into Hadoop
• B.  hosts the components through which events flow from an external source to the next destination
• C.  forwards events to the source
• D.  removes events from the channel and puts them into an external repository
• E.  consumes events delivered to it by an external source such as a web server