IBM C2090-101 Exam Questions Instant Access

Question 1

Consider the following Solr query:

curl ''http://localhost:8983/solr/gettingstarted/select?wt=json&indent=true&q=foundation''

What is the term that is being searched?

Aindent

Bjson

Cgettingstarted

Dfoundation

Answer : D

https://lucene.apache.org/solr/6_0_0/quickstart.html

Question 2

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

AXSH

BXBD

CXDSM

DX / Open

Answer : C

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

Question 3

Which parameters are considered when configuring Big Match algorithm?

ASearch and custom requirements

BAccuracy, search, and performance

CAdaptive weighting and standardization

DEmpirical components, accuracy, and performance

Answer : B

Question 4

Which of the following are CRUD operations available in HBase? (Choose two.)

AHTable.Put

BHTable.Read

CHTable.Delete

DHTable.Update

EHTable.Remove

Answer : A, C

https://www.tutorialspoint.com/hbase/hbase_client_api.htm

Question 5

For a customer satisfaction application, a large eCommerce company is loading click stream data into MySQL and running Cognos Reports which are accessed by 50 plus customer service reps (CSR). The IT team decided to move the application to the new BigInsights-based Hadoop cluster and load the data into a Hive Warehouse and run the queries. Which one of the following would enable them to reuse the SQL queries without extensive rewrite?

APig

BNoSQL

CHiveQL

DBig SQL

Answer : D

Question 6

Which of the following Jaq operators groups one or more arrays based on key values and applies an aggregate expression?

Ajoin

Bgroup

Cexpand

Dtransform

Answer : B

https://books.google.com.pk/books?id=Qj-5BQAAQBAJ&pg=PA174&lpg=PA174&dq=Jaq

+operators+groups+one+or+more+arrays+based+on+key+values+and+applies+an+aggregate

+expression&source=bl&ots=zobr8AZzWy&sig=ZRCIH9ee4Un3Aam1hX8TzxfrfQI&hl=en&sa=X&redir_esc=y# v=onepage&q=Jaq%20operators%20groups%20one%20or%20more%20arrays%20based%20on%20key% 20values%20and%20applies%20an%20aggregate%20expression&f=false

Question 7

A large bank was planning to offload existing data from a data warehouse into Hadoop and use SQL queries to access historical dat

a. Which one of the following statements is true for using HiveQL?

AIt supports four logical operators in query predicates: IN, NOT IN, EXISTS, and NOT EXISTS

BIt does not support nested sub-queries

CHive supports all ANSI SQL 2011 syntax

DAll of the above

Answer : A

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.5/bk_data-access/content/hive-013- feature-subqueries-in-where-clauses.html

IBM Big Data Engineer C2090-101 Exam Questions