Oracle 1z0-449 問題集

質問 1：
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. user
C. bruce
D. all users
E. sales
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Identify two ways to create an external table to access Hive data on the Big Data Appliance by using Big Data SQL. (Choose two.)
A. Use the Enterprise Manager Big Data SQL Configuration page to create the table.
B. Use a CREATE table statement with ORGANIZATION EXTERNAL and the
ORACLE_BDSQL access parameter.
C. Use a CREATE table statement with ORGANIZATION EXTERNAL and the
ORACLE_HIVE access parameter.
D. Use Cloudera Manager's Big Data SQL Query builder.
E. You can use the dbms_hadoop.create_extdd1_for_hive package to return the text of the
CREATE TABLE command.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which parameter setting will force Impala to execute queries only on the coordinator node?
A. SYNC_DDL=TRUE
B. NUM_NODES=1
C. DISABLE_UNSAFE_SPILLS=TRUE
D. NUM_SCANNER_THREADS=1
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Your customer needs to analyze large numbers of log files after combining them with customer profile and interaction data. The customer wants to be able to analyze these files back to their go-live date, which was last October.
Which solution should you choose to accomplish this?
A. Berkeley DB
B. Oracle NoSQL
C. Oracle Database
D. Hadoop
正解：D

質問 5：
What are the two advantages of using Hive over MapReduce? (Choose two.)
A. Hive does not require MapReduce to run in order to analyze data.
B. Hive allows for sophisticated analytics on large data sets.
C. Hive is much faster than MapReduce because it accesses data directly.
D. Hive simplifies Hadoop for new users.
E. Hive is a free tool; Hadoop requires a license.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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. Change the HDFS server I/O settings to duplex mode.
B. Increase the number of Sqoop mappers.
C. Add additional tables.
D. Change the ODI configuration to high performance mode.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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. The MapReduce job is run when the view is accessed.
B. MapReduce is not run with Hive. Hive bypasses the MapReduce layer.
C. MapReduce is run; the command output is incorrect.
D. A view only defines the metadata in the RDBMS store.
E. MapReduce is run in the background.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)