Oracle-Big Data 2016 Implementation Essentials Set 1

Question - 15 Maximum mark : - 29

Home
All Exams
Oracle-Big Data 2016 Implementation Essentials Online Mock Tests
Oracle-Big Data 2016 Implementation Essentials Set 1

The hdfs_stream script is used by the Oracle SQL Connector for HDFS to perform a specific task to access data. What is the purpose of this script?

It is the preprocessor script for the Impala table. ✘ It is the preprocessor script for the HDFS external table. ✘ It is the streaming script that creates a database directory. ✘ It is the preprocessor script for the Oracle partitioned table. ✔ It defines the jar file that points to the directory where Hive is installed. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

How should you encrypt the Hadoop data that sits on disk?

Enable Transparent Data Encryption by using the Mammoth utility. ✘ Enable HDFS Transparent Encryption by using bdacli on a Kerberos-secured cluster. ✘ Enable HDFS Transparent Encryption on a non-Kerberos secured cluster. ✘ Enable Audit Vault and Database Firewall for Hadoop by using the Mammoth utility. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You want to set up access control lists on your NameNode in your Big Data Appliance. However, when you try to do so, you get an error stating "the NameNode disallows creation of ACLs." What is the cause of the error?

During the Big Data Appliance setup, Cloudera's ACLSecurity product was not installed. ✘ Access control lists are set up on the DataNode and HadoopNode, not the NameNode. ✘ During the Big Data Appliance setup, the Oracle Audit Vault product was not installed. ✘ dfs.namenode.acls.enabled must be set to true in the NameNode configuration. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What does the following line do in Apache Pig? products = LOAD '/user/oracle/products' AS (prod_id, item);

The products table is loaded by using data pump with prod_id and item. ✘ The LOAD table is populated with prod_id and item. ✘ The contents of /user/oracle/products are loaded as tuples and aliased to products. ✘ The contents of /user/oracle/products are dumped to the screen. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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", "123456") FROM src;

xyz ✘ 123 ✘ 456 ✘ xxx ✔ x/y ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The NoSQL KVStore experiences a node failure. One of the replicas is promoted to primary. How will the NoSQL client that accesses the store know that there has been a change in the architecture?

The KVLite utility updates the NoSQL client with the status of the master and replica. ✘ KVStoreConfig sends the status of the master and replica to the NoSQL client. ✘ The NoSQL admin agent updates the NoSQL client with the status of the master and replica. ✘ The Shard State Table (SST) contains information about each shard and the master and replica status for the shard. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

native MapReduce Java programs ✘ Impala ✘ HiveFastQL ✘ Apache Grunt ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Your customer keeps getting an error when writing a key/value pair to a NoSQL replica. What is causing the error?

The master may be in read-only mode and as result, writes to replicas are not being allowed. ✘ The replica may be out of sync with the master and is not able to maintain consistency. ✘ The writes must be done to the master. ✘ The replica is in read-only mode. ✔ The data file for the replica is corrupt. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The log data for your customer's Apache web server has seven string columns. What is the correct command to load the log data from the file 'sample.log' into a new Hive table LOGS that does not currently exist?

hive> CREATE TABLE logs (t1 string, t2 string, t3 string, t4 string, t5 string, t6 string, t7 string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' '; ✘ hive> create table logs as select * from sample.log; ✘ hive> CREATE TABLE logs (t1 string, t2 string, t3 string, t4 string, t5 string, t6 string, t7 string) ROW FORMATDELIMITED FIELDS TERMINATED BY ' '; hive> LOAD DATA LOCAL INPATH 'sample.log' OVERWRITE INTO TABLE logs; ✘ hive> LOAD DATA LOCAL INPATH 'sample.log' OVERWRITE INTO TABLE logs;hive> CREATE TABLE logs (t1 string, t2 string, t3 string, t4 string, t5 string, t6 string, t7 string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' '; ✔ hive> create table logs as load sample.1og from hadoop; ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Your customer's Oracle NoSQL store has a replication factor of 3. One of the customer's replica nodes goes down. What will be the long-term performance impact on the customer's NoSQL database if the node is replaced?

There will be no performance impact. ✘ The database read performance will be impacted. ✘ The database read and write performance will be impacted. ✘ The database will be unavailable for reading or writing. ✔ The database write performance will be impacted. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle-Big Data 2016 Implementation Essentials Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner