IBM IBM Certifications C2090-101 Questions & Answers

• Question 41:

  Which BigInsights components are essential for Big Match operations?

  A. Social Data Analytics (SDA)

  B. HDFS, HBase, and BigSheets

  C. HDFS and HBase

  D. MapReduce framework, BigInsights cluster management

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/SSWSR9_11.3.0/ com.ibm.swg.im.mdmhs.pmebi.doc/topics/pme_bi_architecture.html

• Question 42:

  Which of the following statements regarding importing streaming data from InfoSphere Streams into Hadoop is TRUE?

  A. InfoSphere Streams utilizes Flume to interface to Hadoop

  B. The HDFSFileSink operator writes files in parallel to a Hadoop Distributed File System

  C. Buffering techniques are used to process incoming streams from InfoSphere Streams

  D. When you use the HDFS operators to access GPFS, you must install InfoSphere Streams on an InfoSphere Big Insights data node

  Correct Answer: C

  Reference: https://books.google.com.pk/books?id=JWfRAgAAQBAJandpg=PA147andlpg=PA147anddq=IBm +Buffering+techniques+are+used+to+process+incoming+streams+from+InfoSphere +Streamsandsource=blandots=Z6XhA0Owkandsig=ACfU3U3T9ydrZHWTMvB31qQOyf6FtoDQgwandhl=enandsa=Xandved=2ahUKEwj6wsnvqvfoAhVUSx UIHWNDAycQ6AEwA3oECBEQAQ#v=onepageandq=IBm%20Buffering%20techniques%20are%20used% 20to%20process% 20incoming%20streams%20from%20InfoSphere%20Streamsandf=false

• Question 43:

  Which of the following statements regarding Sqoop is TRUE?

  A. Output files are always delimited text files in HDFS

  B. The import of a single database table results in multiple files in HDFS

  C. When exporting data back to a database, a target table will be created if it doesn't already exist

  D. Sqoop processes the entire database table as a single unit rather than row-by-row for enhanced performance

  Correct Answer: A

  Reference: https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html

• Question 44:

  Considering the following properties:

  1.

  Automated creation of target database schema and bulk extract and load

  2.

  Real-time replication subscriptions (with CDC)

  3.

  Managed workload for optimized performance of potentially thousands of artifacts

  4.

  Ensured governance around both data access as well as for metadata capture (to support data lineage and impact assessment)

  Which tool supports all of the above?

  A. Pig

  B. JAQL

  C. Data Click

  D. BigSheets

  Correct Answer: A

  Reference: http://meta7.forsythe.com/_wss/clients/508/news_feed/20151130202508951.pdf

• Question 45:

  What Redaction feature needs to be selected when manually redacting a form through the Optim Review Tool?

  A. Text Redaction

  B. Image Redaction

  C. Region Redaction

  D. Redact by Information Type

  Correct Answer: D

• Question 46:

  Which is a benefit of row oriented table design?

  A. When writing a new row, if all of the row data is supplied at the same time the entire row can be written with a single disk seek

  B. When columns of a single row are required at the same time, the entire row can be retrieved with a single disk seek regardless of row size

  C. When new values of a column are supplied for all rows at once, that column data can be written efficiently and replace old column data without touching any other columns for the rows

  D. When an aggregate needs to be computed over many rows but only a notably smaller subset of all columns of data, reading that smaller subset of data can be faster than reading all data

  Correct Answer: B

  Reference: http://www.ijoart.org/docs/Column-Oriented-Databases-to-Gain-High-Performance-for-DataWarehouse-System.pdf (7)

• Question 47:

  Which source operator detects SPSS Collaboration and Deployment Services notification events for a specific SPSS Modeler file and downloads the indicated file version for the refreshed scoring branch?

  A. SPSSPublish operator

  B. SPSSScoring operator

  C. SPSSModeler operator

  D. SPSSRepository operator

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/SS69YH_8.1.0/cads_infosphere_ddita/cads/ infosphere/is_overview.html

• Question 48:

  When loading data into Big SQL, which statement is TRUE concerning the underlying storage mechanisms supported?

  A. Big SQL supports .DB2 files

  B. Big SQL supports Parquet files

  C. Big SQL natively supports XML file format

  D. Big SQL supports file stored in PDF format

  Correct Answer: B

  Reference: https://www.ibm.com/support/knowledgecenter/SSCRJT_5.0.3/com.ibm.swg.im.bigsql.doc/doc/ biga_fileformats.html

• Question 49:

  Which of the following statements regarding importing streaming data from InfoSphere Streams into Hadoop is TRUE?

  A. InfoSphere Streams can only write to HDFS not read from HDFS

  B. InfoSphere Streams can only write directly to BigInsights, not other Hadoop distributions like Hortonworks or Cloudera

  C. A Streams developer needs to account for the fact that BigInsights may not be able to absorb the incoming streams at the rate InfoSphere Streams is sending them

  D. Adding a Big Data toolkit operator (for writing to Hadoop) to an InfoSphere Streams Processing Language (SPL) application requires that the SPL application be recompiled

  Correct Answer: B

  Reference: https://books.google.com.pk/books? id=6BmLCwAAQBAJandpg=PA15andlpg=PA15anddq=InfoSphere+Streams+can+only+write+directly+to +BigInsights,+not+other+Hadoop+distributions+like+Hortonworks+or +Clouderaandsource=blandots=bAX5_-opwFandsig=ACfU3U2rhwLKLEes37evjJfMzxYMLP7NxQandhl=enandsa=Xandved=2ahUKEwi6gY2soffoAhWIzaQ KHREADDkQ6AEwAHoECBcQJg#v=onepageandq=InfoSphere%20Streams%20can%20only% 20write% 20directly%20to%20BigInsights%2C%20not%20other%20Hadoop%20distributions%20like% 20Hortonworks%20or%20Clouderaandf=false

• Question 50:

  What command is used to find the version level of GPFS running on a particular Linux node?

  A. lslpp -ver \*

  B. list ver gpfs\*

  C. lslpp -l gpfs\*

  D. rpm -qa | grep gpfs

  Correct Answer: D

  Reference: https://www.google.com/url? sa=tandrct=jandq=andesrc=sandsource=webandcd=3andved=2ahUKEwjKhrG7q_foAhXiVhUIHSizDyQQFjACegQIAxA Bandurl=https%3A%2F%2Fwww.ibm.com%2Fdeveloperworks%2Fcommunity%2Fforums% 2Fatom% 2Fdownload%2FConcepts_Planning_Installation.pdf%3FnodeId%3Df189c262-a09f-4ed0-991b3e702fafcad2andusg=AOvVaw32QxwHaqCkUPwVyWiS01Cx (11)