IBM C2090-101 Online Practice Questions and Exam Preparation

IBM C2090-101 Online Questions & Answers

• Question 71:

  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
  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

  ---

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

• Question 72:

  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
  D. Make the terminal node a scoring branch

• Question 73:

  Which tool below can be used for extracting data directly from an RDBMS and placing a copy within BigInsights as a ready-to-query table?

  A. Flume
  B. Sqoop
  C. NZ Load
  D. Distributed Copy
  B. Sqoop

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/da/SSPT3X_4.2.0/com.ibm.swg.im.infosphere.biginsights.import.doc/doc/data_warehouse_sqoop.html

• Question 74:

  When running Hive Queries using Apache Spark, which of the following execution engines is invoked?

  A. Tez
  B. Spark
  C. HiveQL
  D. MapReduce
  B. Spark

  ---

  When running queries, you can set hive.execution.engine so as to choose the execution engine. To run on Spark, set it to spark. To run on MapReduce, set it to mr. Reference: https://www.ibm.com/support/knowledgecenter/en/SSPT3X_4.2.5/com.ibm.swg.im.infosphere.biginsights.admin.doc/doc/admin_hive_on_spark.html

• Question 75:

  Extracting structured data from various database into a "sandbox" location without writing code can be performed using which tool include with BigInsights?

  A. Flume
  B. Data Click
  C. DataStage
  D. Big SQL Load
  A. Flume

• Question 76:

  Which format would be best for holding semi-structured data?

  A. Text
  B. Avro
  C. CSV
  D. JSON
  D. JSON

• Question 77:

  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
  A. Hue submits MapReduce jobs to Oozie

• Question 78:

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

  A. Hue utilizes Java libraries which must be installed on your system
  B. The Hue Beeswax application enables you to perform queries on HBase
  C. For optimal performance, the Hue Server should be one of the nodes within your Hadoop cluster
  D. The Hue Sqoop UI allows transferring data from a relational database to Hadoop, but not from Hadoop to a relational database
  D. The Hue Sqoop UI allows transferring data from a relational database to Hadoop, but not from Hadoop to a relational database

  ---

  Reference: https://gethue.com/move-data-in-out-your-hadoop-cluster-with-the-sqoop/

• Question 79:

  The GPFS implementation of Data Management API is compliant to which Open Group storage management Standard?

  A. XSH
  B. XBD
  C. XDSM
  D. X / Open
  C. XDSM

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSFKCN_4.1.0/com.ibm.cluster.gpfs.v4r1.gpfs400.doc/bl1dmp_intro.htm

• Question 80:

  Which source operator detects SPSS Collaboration and Deployment Services notification events for a specific SPSS Modeler file and downloads the indicated file version for the refreshed scoring branch?

  A. SPSSPublish operator
  B. SPSSScoring operator
  C. SPSSModeler operator
  D. SPSSRepository operator
  D. SPSSRepository operator

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/SS69YH_8.1.0/cads_infosphere_ddita/cads/infosphere/is_overview.html