Online Access Free 1z0-449 Exam Questions

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

What are the two advantages of using Hive over MapReduce? (Choose two.)

• A.Hive is a free tool; Hadoop requires a license.
• B.Hive does not require MapReduce to run in order to analyze data.
• C.Hive is much faster than MapReduce because it accesses data directly.
• D.Hive simplifies Hadoop for new users.
• E.Hive allows for sophisticated analytics on large data sets.

Your customer collects diagnostic data from its storage systems that are deployed at customer sites. The customer needs to capture and process this data by country in batches.
Why should the customer choose Hadoop to process this data?

• A.Hadoop processes data on large clusters (10-50 max) on commodity hardware.
• B.Hadoop supports centralized computing of large data sets on large clusters.
• C.Hadoop is a batch data processing architecture.
• D.Hadoop processes data serially.
• E.Node failures can be dealt with by configuring failover with clusterware.

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

Your customer wants you to set up ODI by using the IKM SQL to Hive module and overwrite existing Hive tables with the customer's new clinical data.
What parameter must be set to true?

• A.CREATE_HIVE_TABLE
• B.SQOOP_ODI_OVERWRITE
• C.OVERWRITE_HDFS_TABLE
• D.OVERWRITE_HIVE_TABLE