support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. IBM
  4. C2090-101

IBM C2090-101 Exam Prep
IBM Big Data Engineer (Page 11 )

Updated On: 6-Apr-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



  PDF
Viewing page 11 of 23
Viewing questions 51 - 55 out of 106 questions


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

AI Tutor AI Tutor 👋 I’m here to help!