Free Oracle 1z0-449 Exam Dumps Questions & Answers

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.Use the Cloudera Manager.
• B.Execute bdacli sentry enable.
• C.Use the Mammoth utility during installation.
• D.Sentry is enabled by default on the Big Data Appliance.

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

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

What are three correct results of executing the preceding query? (Choose three.)

• A.Errors in the data for CUST_NUM or ORDER_NUM set the value to INVALID_NUM.
• B.Errors in the data for CUST_NUM or ORDER_NUM set the value to 0000000000.
• C.Values longer than 100 characters for any column are truncated.
• D.ITEM_CNT in the HDFS file matches ORDER_LINE_ITEM_COUNT in the external table.
• E.Values longer than 100 characters for the DESCRIPTION column are truncated.
• F.ORDER_LINE_ITEM_COUNT in the HDFS file matches ITEM_CNT in the external table.

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 first node the RAC cluster because clustered environments are not inherently supported.
• 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 available nodes randomly, provided that the RAC-aware service name is specified in the
  JDBC URL.