Free Oracle 1z0-449 Exam Dumps Questions & Answers

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

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 sinks that write to a consolidated source with a sink to the customer's HDFS directory
• B.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
• C.multiple flume agents with collectors that output to a logger that writes to the Oracle
  Loader for Hadoop agent
• D.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
• E.multiple HDFS agents that write to a consolidated HDFS directory

Your customer is worried that the redundancy of HDFS will not meet its needs. The customer needs to store certain files with higher levels of redundancy than other files.
Which architectural feature of HDFS should you choose?

• A.Apache Scala on top of MapReduce, which allows you to store files at various redundancies
• B.Automatic Storage Management, which can be used to multiplex the data
• C.Apache Impala, which can be used to set the duplex level for each file
• D.the replication factor, which can be set at the file level

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

Your customer needs to access Hive tables, HDFS, and Data Pump format files as the data source.
When installing and configuring the Oracle SQL Connector for HDFS, which two locations must be installed or configured to fulfill this requirement? (Choose two.)

• A.Hadoop cluster
• B.Impala
• C.Oracle NoSQL
• D.Oracle database
• E.HiveQL