Oracle 1z0-449 問題集

質問 1：
Your customer has a Big Data Appliance and an Exadata Database Machine and would like to extend security. Select two ways that security works in Big Data SQL. (Choose two.)
A. On the Big Data Appliance, Hadoop's native security is used.
B. On the Big Data Appliance, Oracle Advanced Hadoop Security is used for fine grained access control.
C. On the Big Data Appliance, Oracle Identity Management is used.
D. On the Big Data Appliance, data is encrypted by using Oracle Transparent Data
Encryption (TDE).
E. On the Exadata Database Machine, Oracle Advanced Security is used for fine-grained access control.
正解：D,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Your customer needs to move data from Hive to the Oracle database but does have any connectors purchased.
What is another architectural choice that the customer can make?
A. Export data from Hive by using export/import.
B. Use Apache Pig.
C. Use Apache Sentry.
D. Use Apache Sqoop.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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. A Hive table called SALES_HIVE_XTAB is created.
D. An external table called SALES_HIVE_XTAB is created to read data from a Hive table.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
How does the Sqoop Server handle a job that was discontinued by a restart?
A. by stopping the loading of data
B. by sending an alert and waiting to resume the job
C. by rolling back the load
D. by continuing the loading of data
正解：D

質問 5：
Your customer needs to access Hive tables, HDFS, and Data Pump format files as the data source.
When installing and configuring the Oracle SQL Connector for HDFS, which two locations must be installed or configured to fulfill this requirement? (Choose two.)
A. Oracle database
B. Hadoop cluster
C. Impala
D. Oracle NoSQL
E. HiveQL
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Your customer's security team needs to understand how the Oracle Loader for Hadoop
Connector writes data to the Oracle database.
Which service performs the actual writing?
A. NameNode
B. map tasks
C. reduce tasks
D. write tasks
E. OLH agent
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Your customer is experiencing significant degradation in the performance of Hive queries.
The customer wants to continue using SQL as the main query language for the HDFS store.
Which option can the customer use to improve performance?
A. Impala
B. native MapReduce Java programs
C. Apache Grunt
D. HiveFastQL
正解：A
解説: (Topexam メンバーにのみ表示されます)