Which one of the following file formats is optimal for querying tables with many columns and performing aggregation operations such as SUM() and AVG()?
A. Text
B. Avro
C. JSON
D. PARQUET
Which of the following is NOT TRUE regarding the Job Control Plane operator?
A. User-defined checkpoint logic can be coded in the logic section
B. It must be added to each application that includes a consistent region
C. It controls the notifications to set of operators that are included in a consistent region
D. It has no input or output ports and appears as a stand-alone operator in an application graph
How many Job Trackers can be found in a MapReduce v1 cluster?
A. One per cluster
B. One per data node
C. One for each Mapper
D. One for each Reducer
Which of the following is TRUE regarding a schema In Jaql?
A. It specifies a particular type for each field
B. It is used only when Jaql includes SQL statements
C. It must be provided when the data format is not otherwise known
D. It can be used both as a data constraint and to optimize processing and storage
A large retailer is planning to create a data cloud using BigInsights. They would like to run queries using data that is stored in BigInsights as well as other databases like DB2 and Oracle.
Which one of the following would enable them to write the queries without having to move data into one common data store?
A. Hive
B. HBase
C. Big SQL
D. BigSheets
A Resilient Distributed Dataset is a good solution for which of the following?
A. A search
B. An SQL based data transformation
C. A high throughput write oriented use cases
D. An interactive query and iterative algorithms
When running Hive Queries using Apache Spark, which of the following execution engines is invoked?
A. Tez
B. Spark
C. HiveQL
D. MapReduce
You have social media data in a plain text file. You want to figure out the number of times the word "Watson" is mentioned in it.
Which of the following steps will correctly allow you to visualize that data?
A. Create a master workbook, add a filter sheet, run the workbook, add chart
B. Create a master workbook, create a child workbook, add a filter sheet, add chart
C. Create a master workbook, edit the workbook, add a filter sheet, run the workbook, add chart
D. Create a master workbook, create a child workbook, add a filter sheet, run the workbook, add chart
One option to import data to your BigInsights cluster is to use Sqoop.
Which of the following examples shows a data exchange with a DB2 database by using the built-in DB2 connector?
A. $SQOOP_HOME/bin/sqoop export --connect jdbc:db2://db2.my.com:50000/myDB --username db2user --password db2pwd --table db2tbl --export-dir /sqoop/dataFile.csv
B. $SQOOP_HOME/bin/sqoop import -connect jdbc:db2://db2.my.com:50000/testdb -username db2user password db2pwd -table db2tbl -split-by tbl_primarykey -target-dir sqoopimports
C. $SQOOP_HOME/bin/sqoop import --connect jdbc:db2://db2.my.com:50000/testdb --username db2user --password db2pwd --table db2tbl --split-by tbl_primarykey --target-dir sqoopimports
D. $BIGINSIGHTS_HOME/bin/sqoop import --connect jdbc:db2://db2.my.com:50000/testdb -- username db2user --password db2pwd --table db2tbl --split-by tbl_primarykey --target-dir sqoopimports
What should you use to run Big SQL queries that require dynamic variables or scheduling?
A. JSqsh
B. Eclipse
C. BigInsights Console
D. BigInsights Applications
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-101 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.