Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-101

IBM C2090-101 Exam Questions
IBM Big Data Engineer (Page 12 )

Updated On: 14-Mar-2026
Page 4 of 23
PDF with 106 Questions

Which statement is TRUE about Big SQL?

  1. The table definition can include other attributes such as the primary key or check constraints
  2. When using Big SQL, the CREATE TABLE statement cannot be embedded in an application program
  3. 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
  4. 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

Answer(s): D


Reference:

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



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

  1. Hue submits MapReduce jobs to Oozie
  2. No additional setup is required to secure your session cookies
  3. Hue applications require some code to be installed on the client
  4. The File Browser application allows you to perform keyword searches across your Hadoop data

Answer(s): A



A Resilient Distributed Dataset supports which of the following?

  1. Creating a new dataset from an old one
  2. Returning a computed value to the driver program
  3. Both "Creating a new dataset from an old one" and "Returning a computed value to the driver program"
  4. Neither "Creating a new dataset from an old one" nor "Returning a computed value to the driver program"

Answer(s): C


Reference:

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



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:

  1. add a Type node
  2. insert any Output node
  3. add a Table node as the terminal node
  4. Make the terminal node a scoring branch

Answer(s): D



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

  1. INT
  2. STRING
  3. STRUCT
  4. BOOLEAN

Answer(s): B


Reference:

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



Viewing page 12 of 23
Viewing questions 56 - 60 out of 106 questions



Post your Comments and Discuss IBM C2090-101 exam dumps with other Community members:

C2090-101 Exam Discussions & Posts

AI Tutor 👋 I’m here to help!