Free Oracle 1z1-449 Exam Dumps Questions & Answers

Your customer needs the data that is generated from social media such as Facebook and
Twitter, and the customer's website to be consumed and sent to an HDFS directory for analysis by the marketing team.
Identify the architecture that you should configure.

• A.  multiple flume agents with collectors that output to a logger that writes to the Oracle
  Loader for Hadoop agent
• B.  multiple HDFS agents that write to a consolidated HDFS directory
• C.  a single flume agent that collects data from the customer's website, which is connected to both Facebook and Twitter, and writes via the collector to the customer's HDFS directory
• D.  multiple flume agents with sinks that write to a consolidated source with a sink to the customer's HDFS directory
• E.  a single HDFS agent that collects data from the customer's website, which ls connected to both Facebook and Twitter, and writes via the Hive to the customer's HDFS directory

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.  Resource Manager
• B.  Task Tracker
• C.  MasterNode
• D.  NameNode
• E.  Node Manager

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

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

Your customer is setting up an external table to provide read access to the Hive table to
Oracle Database.
What does hdfs:/user/scott/data refer to in the external table definition for the Oracle SQL
Connector for HDFS?

• A.  the location for the log directory
• B.  the local file system location for the data
• C.  the location of the Oracle data file for SALES_DP_XTAB
• D.  the default directory for the Oracle external table
• E.  the location of the HDFS input data

What are two reasons that a MapReduce job is not run when the following command is executed in Hive? (Choose two.) hive> create view v_consolidated_credit_products as select hcd.customer_id, hcd.credit_card_limits, hcd.credit_balance, hmda.n_mortgages, hmda.mortgage_amount from mortgages_department_agg hmda join credit_department hcd on hcd.customer_id=hmda.customer_id;
OK
Time taken: 0.316 seconds

• A.  MapReduce is run; the command output is incorrect.
• B.  MapReduce is not run with Hive. Hive bypasses the MapReduce layer.
• C.  The MapReduce job is run when the view is accessed.
• D.  A view only defines the metadata in the RDBMS store.
• E.  MapReduce is run in the background.