C2090-101: IBM Big Data Engineer - Free download from Exam Files

Which statement is TRUE concerning optimizing the load performance?

You can improve the performance by increasing the number of map tasks assigned to the load
When loading large files the number of files that you load does not impact the performance of the LOAD HADOOP statement
You can improve the performance by decreasing the number of map tasks that are assigned to the load and adjusting the heap size
It is advantageous to run the LOAD HADOOP statement directly pointing to large files located in the host file system as opposed to copying the files to the DFS prior to load

Correct answer: A

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSCRJT_5.0.3/com.ibm.swg.im.bigsql.doc/doc/bigsql_loadperf.html

Which of the following statements are TRUE regarding the use of Data Click to load data into BigInsights? (Choose two.)

Big SQL cannot be used to access the data moved in by Data Click because the data is in Hive
You must import metadata for all sources and targets that you want to make available for Data Click activities
Connections from the relational database source to HDFS are discovered automatically from within Data Click
Hive tables are automatically created every time you run an activity that moves data from a relational database into HDFS
HBase tables are automatically created every time you ran an activity that moves data from a relational database into HDFS

Correct answer: CE

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.3.0/com.ibm.swg.im.iis.dataclick.doc/topics/hivetables.html

Which of the following statements regarding importing streaming data from InfoSphere Streams into Hadoop is TRUE?

InfoSphere Streams can both read from and write data to HDFS
The Streams Big Data toolkit operators that interface with HDFS uses Apache Flume to integrate with Hadoop
Streams applications never need to be concerned with making the data schemas consistent with those on Hadoop
Big SQL can be used to preprocess the data as it flows through InfoSphere Streams before the data lands in HDFS

Correct answer: D

Which of the following is TRUE about storing an Apache Spark object in serialized form?

It is advised to use Java serialization over Kryo serialization
Storing the object in serialized from will lead to faster access times
Storing the object in serialized from will lead to slower access times
All of the above

Correct answer: B

Explanation:

Reference: https://spark.apache.org/docs/latest/rdd-programming-guide.html

Which ONE of the following statements regarding Sqoop is TRUE?

HBase is not supported as an import target
Data imported using Sqoop is always written to a single Hive partition
Sqoop can be used to retrieve rows newer than some previously imported set of rows
Sqoop can only append new rows to a database table when exporting back to a database

Correct answer: C

Explanation:

Reference: https://sqoop.apache.org/docs/1.4.1-incubating/SqoopUserGuide.html

Which one of the following statements is TRUE?

Spark SQL does not support HiveQL
Spark SQL does not support ANSI SQL
To use Spark with Hive, HiveQL queries have to rewritten in Scala
Spark SQL allows relational queries expressed in SQL, HiveQL, or Scala

Correct answer: D

Explanation:

Reference: https://spark.apache.org/docs/1.2.1/sql-programming-guide.html (overview)

Which of the following statements regarding Big SQL is TRUE?

Big SQL doesn’t support stored procedures
Big SQL can be deployed on a subset of data nodes in the BigInsights cluster
Big SQL provides a SQL-on-Hadoop environment based on map reduce
Only tables created or loaded via Big SQL can be accessed via Big SQL

Correct answer: B

Explanation:

Reference: https://books.google.com.pk/books?id=t13nCQAAQBAJ&pg=PA3&lpg=PA3&dq=Big+SQL+can+be+deployed+on+a+subset+of+data+nodes+in+the+BigInsights+cluster&source=bl&ots=RBbad0Xkel&sig=pMgmgDNLGUrkvOSXoVBj64xTMgk&hl=en&sa=X&redir_esc=y#v=onepage&q=Big%20SQL%20can%20be%20deployed%20on%20a%20subset%20of%20data%20nodes%20in%20the%20BigInsights%20cluster&f=false

The number of partitions created by DynamicPartitions in Hive can be controlled by which of the following?

hive.exec.max.dynamic.partitions.pernode
hive.exec.max.dynamic.partitions
hive.exec.max.created.files
All of the above

Correct answer: A

Explanation:

Reference: https://resources.zaloni.com/blog/partitioning-in-hive

Which of the following Jaq operators groups one or more arrays based on key values and applies an aggregate expression?

join
group
expand
transform

Correct answer: B

Explanation:

Reference: https://books.google.com.pk/books?id=Qj-5BQAAQBAJ&pg=PA174&lpg=PA174&dq=Jaq+operators+groups+one+or+more+arrays+based+on+key+values+and+applies+an+aggregate+expression&source=bl&ots=zobr8AZzWy&sig=ZRCIH9ee4Un3Aam1hX8TzxfrfQI&hl=en&sa=X&redir_esc=y#v=onepage&q=Jaq%20operators%20groups%20one%20or%20more%20arrays%20based%20on%20key%20values%20and%20applies%20an%20aggregate%20expression&f=false

Which of the following are CRUD operations available in HBase? (Choose two.)

HTable.Put
HTable.Read
HTable.Delete
HTable.Update
HTable.Remove

Correct answer: AC

Explanation:

Reference: https://www.tutorialspoint.com/hbase/hbase_client_api.htm

Vendor:	IBM
Exam Code:	C2090-101
Exam Name:	IBM Big Data Engineer
Date:	Feb 24, 2019
File Size:	32 KB

Download IBM Big Data Engineer.C2090-101.TestInside.2019-02-24.53q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown