Online Access Free 1z0-449 Practice Test

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

During a meeting with your customer's IT security team, you are asked the names of the main OS users and groups for the Big Data Appliance.
Which users are created automatically during the installation of the Oracle Big Data
Appliance?

• A.bda, cdh5, and oracle
• B.flume, hbase, and hdfs
• C.mapred, bda, and engsys
• D.hbase, cdh5, and oracle

Your customer wants to implement the Oracle Table Access for a Hadoop Connector
(OTA4H) to connect the Hadooop cluster to the Oracle database. The customer's Oracle
Database is a Real Application Clusters database.
How should you configure the database listener?

• A.Connecting to a RAC database is not supported.
• B.The database listener is configured to route the Hadoop connection requests to the available nodes randomly, provided that the RAC-aware service name is specified in the
  JDBC URL.
• C.The database listener is configured to route requests to the designated "hadoop" node in the listener's service definition.
• D.The database listener is configured to route the Hadoop connection requests to the first node the RAC cluster because clustered environments are not inherently supported.

Your customer has had a security breach on its running Big Data Appliance and needs to quickly enable security for Hive and Impala.
What is the quickest way to enable the Sentry service?

• A.Sentry is enabled by default on the Big Data Appliance.
• B.Use the Mammoth utility during installation.
• C.Execute bdacli sentry enable.
• D.Use the Cloudera Manager.

Your customer has three XML files in HDFS with the following contents. Each XML file contains comments made by users on a specific day. Each comment can have zero or more "likes" from other users. The customer wants you to query this data and load it into the Oracle Database on Exadata.
How should you parse this data?

• A.by using the XML file module in the Oracle XQuery for Hadoop Connector
• B.by using the built-in functions for reading JSON in the Oracle XQuery for Hadoop
  Connector
• C.by configuring the Oracle SQL Connector for HDFS and parsing by using SerDe
• D.by creating a table in Hive and using MapReduce to parse the XML data by column