Free Oracle 1z1-449 Exam Dumps Questions & Answers

Your customer is using the IKM SQL to HDFS File (Sqoop) module to move data from
Oracle to HDFS. However, the customer is experiencing performance issues.
What change should you make to the default configuration to improve performance?

• A.  Increase the number of Sqoop mappers.
• B.  Change the HDFS server I/O settings to duplex mode.
• C.  Add additional tables.
• D.  Change the ODI configuration to high performance mode.

How does the Oracle SQL Connector for HDFS access HDFS data from the Oracle database?

• A.  NoSQL tables
• B.  external tables
• C.  Apache Sqoop files
• D.  non-partitioned tables
• E.  Data Pump files

Your customer wants to architect a system that helps to make real-time recommendations to users based on their past search history.
Which solution should the customer use?

• A.  Oracle Data Integrator
• B.  Oracle Exadata
• C.  Oracle NoSQL
• D.  Oracle Container Database

Your customer has a requirement to use Oracle Database to access and analyze the data that resides in Apache Hadoop.
What is the result of executing the following command when using Oracle SQL Connector for Hadoop?

• A.  Hadoop is configured over JDBC to connect to the Oracle database by using Big Data
  SQL.
• B.  An external table called SALES_HIVE_XTAB is created to write data from a Hadoop table.
• C.  An external table called SALES_HIVE_XTAB is created to read data from a Hive table.
• D.  A Hive table called SALES_HIVE_XTAB is created.

Which user in the following set of ACL entries has read, write and execute permissions? user::rwx group::r-x other::r-x
default:user::rwx
default:user:bruce:rwx #effective:r-x
default:group::r-x
default:group:sales:rwx #effective:r-x
default:mask::r-x
default:other::r-x

• A.  hdfs
• B.  all users
• C.  bruce
• D.  user
• E.  sales