Oracle 1z0-449 問題集

質問 1：
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. multiple flume agents with collectors that output to a logger that writes to the Oracle
Loader for Hadoop agent
B. multiple HDFS agents that write to a consolidated HDFS directory
C. 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
D. 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
E. multiple flume agents with sinks that write to a consolidated source with a sink to the customer's HDFS directory
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
The Hadoop NameNode is running on port #3001, the DataNode on port #4001, the
KVStore agent on port #5001, and the replication node on port #6001. All the services are running on localhost.
What is the valid syntax to create an external table in Hive and query data from the NoSQL
Database?
A. CREATE EXTERNAL TABLE IF NOT EXISTSMOVIE( id INT,original_tit1e
STRING,overview STRING)STORED BY
'oracle.kv.hadoop.hive.table.TableStorageHandler'TBLPROPERTIES
("oracle.kv.kvstore"="kvscore","oracle.kv.hosts"="localhost:3001","oracle.kv.hadoop.hosts"
= "localhost","oracle.kv.tableName"= MOVIE");
B. CREATE EXTERNAL TABLE IF NOT EXISTSMOVIE( id INT,original_title
STRING,overview STRING)STORED BY
'oracle,kv.hadoop.hive.table.TableStorageHandler'TBLPROPERTIES
("oracle.kv.kvstore"="kvstore","oracle.kv.hosts"="localhost:6001","oracle.kv.hadoop.hosts"=
"localhost","oracle.kv.tab1eName"="MOVIE");
C. CREATE EXTERNAL TABLE IF NOT EXISTSMOVIE( id INT,original_title
STRING,overview STRING)STORED BY
'oracle,kv.hadoop.hive.table.TableStorageHandler'TBLPROPERTIES
("oracle.kv.kvstore"="kvstore","oracle.kv.hosts"="localhost:4001","oracle.kv.hadoop.hosts"=
"localhost","oracle.kv.tab1eName"="MOVIE");
D. CREATE EXTERNAL TABLE IF NOT EXISTSMOVIE( id INT,original_title
STRING,overview STRING)STORED BY
'oracle.kv.hadoop.hive.table.TableStorageHandler'TBLPROPERTIES ("oracle.kv.kvstore
"=" kvstore
","oracle.kv.hosts"="localhost:5001","oracle.kv.hadoop.hosts"="localhost","oracle.kv.tab1eN ame"="MOVIE");
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your customer has 10 web servers that generate logs at any given time. The customer would like to consolidate and load this data as it is generated into HDFS on the Big Data
Appliance.
Which option should the customer use?
A. Set up a web server agent in Apache Oozie to write the data to HDFS.
B. Set up a zookeeper agent to capture the transactions and write them to HDFS.
C. Set up an hbase agent to capture the transactions and write them to HDFS.
D. Set up a flume agent to capture the transactions and write them to HDFS.
E. Write a hive query to listen for new logs and save them in a Hive table.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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 メンバーにのみ表示されます)

質問 5：
What two actions do the following commands perform in the Oracle R Advanced Analytics for Hadoop Connector? (Choose two.) ore.connect (type="HIVE") ore.attach ()
A. Attach the Hadoop libraries to R.
B. Connect to NoSQL via Hive.
C. Attach the current environment to the search path of R.
D. Connect to Hive.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
What is the output of the following six commands when they are executed by using the
Oracle XML Extensions for Hive in the Oracle XQuery for Hadoop Connector?
1 . $ echo "xxx" > src.txt
2 . $ hive --auxpath $OXH_HOME/hive/lib -i $OXH_HOME/hive/init.sql
3 . hive> CREATE TABLE src (dummy STRING);
4 . hive> LOAD DATA LOCAL INPATH 'src.txt' OVERWRITE INTO TABLE src;
5 . hive> SELECT * FROM src;
OK
xxx
6. hive> SELECT xml_query ("x/y", "<x><y>123</y><z>456</z></x>") FROM src;
A. 456
B. 123
C. xyz
D. x/y
E. xxx
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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