IBM IBM Certifications C2090-101 Questions & Answers

• Question 91:

  Which parameters are considered when configuring Big Match algorithm?

  A. Search and custom requirements

  B. Accuracy, search, and performance

  C. Adaptive weighting and standardization

  D. Empirical components, accuracy, and performance

  Correct Answer: B

• Question 92:

  Which of the following Hive data types is directly supported in Big SQL without any changes?

  A. INT

  B. STRING

  C. STRUCT

  D. BOOLEAN

  Correct Answer: B

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSCRJT_5.0.1/ com.ibm.swg.im.bigsql.dev.doc/doc/biga_numbers.html

• Question 93:

  In order for an SPSS Modeler stream to be incorporated for use in an InfoSphere Streams application leveraging SPSS Modeler Solution Publisher, you need to:

  A. add a Type node

  B. insert any Output node

  C. add a Table node as the terminal node

  D. Make the terminal node a scoring branch

  Correct Answer: D

• Question 94:

  A Resilient Distributed Dataset supports which of the following?

  A. Creating a new dataset from an old one

  B. Returning a computed value to the driver program

  C. Both "Creating a new dataset from an old one" and "Returning a computed value to the driver program"

  D. Neither "Creating a new dataset from an old one" nor "Returning a computed value to the driver program"

  Correct Answer: C

  Reference: https://spark.apache.org/docs/latest/rdd-programming-guide.html (RDD operations)

• Question 95:

  Which of the following statements is TRUE regarding search visualization with Apache Hue?

  A. Hue submits MapReduce jobs to Oozie

  B. No additional setup is required to secure your session cookies

  C. Hue applications require some code to be installed on the client

  D. The File Browser application allows you to perform keyword searches across your Hadoop data

  Correct Answer: A

• Question 96:

  Which statement is TRUE about Big SQL?

  A. The table definition can include other attributes such as the primary key or check constraints

  B. When using Big SQL, the CREATE TABLE statement cannot be embedded in an application program

  C. If a sub-table is being defined, the authorization ID can be either the same as the owner of the root table or an equivalent

  D. When defining a staging table associated with a materialized query table, the privileges held by the authorization ID of the statement only works with DBADM authority

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/fi/SSCRJT_5.0.2/ com.ibm.swg.im.bigsql.commsql.doc/doc/r0000927.html

• Question 97:

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

  A. HTable.Put

  B. HTable.Read

  C. HTable.Delete

  D. HTable.Update

  E. HTable.Remove

  Correct Answer: AC

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

• Question 98:

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

  A. hive.exec.max.dynamic.partitions.pernode

  B. hive.exec.max.dynamic.partitions

  C. hive.exec.max.created.files

  D. All of the above

  Correct Answer: A

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

• Question 99:

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

  A. join

  B. group

  C. expand

  D. transform

  Correct Answer: B

  Reference: https://books.google.com.pk/books?id=Qj-5BQAAQBAJandpg=PA174andlpg=PA174anddq=Jaq +operators+groups+one+or+more+arrays+based+on+key+values+and+applies+an+aggregate +expressionandsource=blandots=zobr8AZzWyandsig=ZRCIH9ee4Un3Aam1hX8TzxfrfQIandhl=enandsa=Xandredir_es c=y#v=onepageandq=Jaq%20operators%20groups%20one%20or%20more%20arrays%20based%20on% 20key%20values%20and% 20applies%20an%20aggregate%20expressionandf=false

• Question 100:

  Which of the following statements regarding Big SQL is TRUE?

  A. Big SQL doesn't support stored procedures

  B. Big SQL can be deployed on a subset of data nodes in the BigInsights cluster

  C. Big SQL provides a SQL-on-Hadoop environment based on map reduce

  D. Only tables created or loaded via Big SQL can be accessed via Big SQL

  Correct Answer: B

  Reference: https://books.google.com.pk/books?id=t13nCQAAQBAJandpg=PA3andlpg=PA3anddq=Big+SQL+can +be+deployed+on+a+subset+of+data+nodes+in+the+BigInsights +clusterandsource=blandots=RBbad0Xkelandsig=pMgmgDNLGUrkvOSXoVBj64xTMgkandhl=enandsa=Xandredir_esc =y#v=onepageandq=Big%20SQL%20can%20be%20deployed%20on%20a%20subset%20of%20data% 20nodes%20in%20the% 20BigInsights%20clusterandf=false