IBM C2090-101 Exam (page: 3)
IBM Big Data Engineer
Updated on: 12-Feb-2026

Viewing Page 3 of 23

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 3 of 23



Share your comments for IBM C2090-101 exam with other users:

Raj 5/25/2023 8:43:00 AM

nice questions
UNITED STATES


max 12/22/2023 3:45:00 PM

very useful
Anonymous


Muhammad Rawish Siddiqui 12/8/2023 6:12:00 PM

question # 208: failure logs is not an example of operational metadata.
SAUDI ARABIA


Sachin Bedi 1/5/2024 4:47:00 AM

good questions
Anonymous


Kenneth 12/8/2023 7:34:00 AM

thank you for the test materials!
KOREA REPUBLIC OF


Harjinder Singh 8/9/2023 4:16:00 AM

its very helpful
HONG KONG


SD 7/13/2023 12:56:00 AM

good questions
UNITED STATES


kanjoe 7/2/2023 11:40:00 AM

good questons
UNITED STATES


Mahmoud 7/6/2023 4:24:00 AM

i need the dumb of the hcip security v4.0 exam
EGYPT


Wei 8/3/2023 4:18:00 AM

upload the dump please
HONG KONG


Stephen 10/3/2023 6:24:00 PM

yes, iam looking this
AUSTRALIA


Stephen 8/4/2023 9:08:00 PM

please upload cima e2 managing performance dumps
Anonymous


hp 6/16/2023 12:44:00 AM

wonderful questions
Anonymous


Priyo 11/14/2023 2:23:00 AM

i used this site since 2000, still great to support my career
INDONESIA


Jude 8/29/2023 1:56:00 PM

why is the answer to "which of the following is required by scrum?" all of the following stated below since most of them are not mandatory? sprint retrospective. members must be stand up at the daily scrum. sprint burndown chart. release planning.
UNITED STATES


Marc blue 9/15/2023 4:11:00 AM

great job. hope this helps out.
UNITED STATES


Anne 9/13/2023 2:33:00 AM

upload please. many thanks!
Anonymous


pepe el toro 9/12/2023 7:55:00 PM

this is so interesting
Anonymous


Antony 11/28/2023 12:13:00 AM

great material thanks
AUSTRALIA


Thembelani 5/30/2023 2:22:00 AM

anyone who wrote this exam recently
Anonymous


P 9/16/2023 1:27:00 AM

ok they re good
Anonymous


Jorn 7/13/2023 5:05:00 AM

relevant questions
UNITED KINGDOM


AM 6/20/2023 7:54:00 PM

please post
UNITED STATES


Nagendra Pedipina 7/13/2023 2:22:00 AM

q:42 there has to be a image in the question to choose what does it mean from the options
INDIA


BrainDumpee 11/18/2023 1:36:00 PM

looking for cphq dumps, where can i find these for free? please and thank you.
UNITED STATES


sheik 10/14/2023 11:37:00 AM

@aarun , thanks for the information. it would be great help if you share your email
Anonymous


Random user 12/11/2023 1:34:00 AM

1z0-1078-23 need this dumps
Anonymous


labuschanka 11/16/2023 6:06:00 PM

i gave the microsoft azure az-500 tests and prepared from this site as it has latest mock tests available which helped me evaluate my performance and score 919/1000
Anonymous


Marianne 10/22/2023 11:57:00 PM

i cannot see the button to go to the questions
Anonymous


sushant 6/28/2023 4:52:00 AM

good questions
EUROPEAN UNION


A\MAM 6/27/2023 5:17:00 PM

q-6 ans-b correct. https://docs.paloaltonetworks.com/pan-os/9-1/pan-os-cli-quick-start/use-the-cli/commit-configuration-changes
UNITED STATES


unanimous 12/15/2023 6:38:00 AM

very nice very nice
Anonymous


akminocha 9/28/2023 10:36:00 AM

please help us with 1z0-1107-2 dumps
INDIA


Jefi 9/4/2023 8:15:00 AM

please upload the practice questions
Anonymous