C2090-101

C2090-101 practice questions, page 3 of 5, with answer review and explanations.

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

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