IBM IBM Certifications C2090-101 Questions & Answers

• Question 71:

  When you configure a MapReduce job, the inputs can include:

  A. A single file

  B. Paths to one or more directories

  C. A file pattern (e.g., mypath/*.csv)

  D. All of the above

  Correct Answer: C

• Question 72:

  A large bank was planning to offload existing data from a data warehouse into Hadoop and use SQL queries to access historical data. Which one of the following statements is true for using HiveQL?

  A. It supports four logical operators in query predicates: IN, NOT IN, EXISTS, and NOT EXISTS

  B. It does not support nested sub-queries

  C. Hive supports all ANSI SQL 2011 syntax

  D. All of the above

  Correct Answer: A

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

• Question 73:

  PCI compliance requirements allow the use of real customer data during testing and development only when:

  A. The data is only processed in memory

  B. Customer data is never allowed in testing or development

  C. The data is never stored longer than 24 hours in the test system

  D. The data is only stored in volatile storage that expires on power loss

  Correct Answer: D

• Question 74:

  What are the available document formats beside PDF and MS Word when export a redacted document using Optim Review Tool?

  A. TIFF, and CSF

  B. TIFF, and PNG

  C. JPEG, and PNG

  D. Plain Text, and CSV

  Correct Answer: A

  Reference: https://www-01.ibm.com/software/info/channel-solution-profiles/Information_Graphics_RedactIt.html

• Question 75:

  What is Flume?

  A. A distributed filesystem

  B. A platform for executing MapReduce jobs

  C. A programming language that translates high-level queries into map tasks and reduce tasks

  D. A service for moving large amounts of data around a cluster soon after the data is produced.

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSPT3X_4.1.0/ com.ibm.swg.im.infosphere.biginsights.product.doc/doc/bi_flume.html

• Question 76:

  Extracting structured data from various database into a "sandbox" location without writing code can be performed using which tool include with BigInsights?

  A. Flume

  B. Data Click

  C. DataStage

  D. Big SQL Load

  Correct Answer: A

• Question 77:

  Use of Bulk Load in HBase for loading large volume of data will result in which of the following?

  A. It will use less CPU but will use more network resource

  B. It will use less network resource but more CPU

  C. It will behave same way as using HBase API for loading large volume of data

  D. None of the above

  Correct Answer: C

• Question 78:

  When embedding SPSS models within InfoSphere Streams, what SPSS product must be installed on the same machine with InfoSphere Streams?

  A. SPSS Modeler

  B. SPSS Solution Publisher

  C. SPSS Accelerator for InfoSphere Streams

  D. None, the SPSS software runs remotely to the Streams machine

  Correct Answer: B

• Question 79:

  Which of the following statements regarding Sqoop is TRUE? (Choose two.)

  A. All columns in a table must be imported

  B. Sqoop bypasses MapReduce for enhanced performance

  C. Each row from a source table is represented as a separate record in HDFS

  D. When using a password file, the file containing the password must reside in HDFS

  E. Multiple options files can be specified when invoking Sqoop from the command line

  Correct Answer: CE

  Reference: https://data-flair.training/blogs/apache-sqoop-tutorial/

• Question 80:

  Which of the following techniques is NOT employed by Big SQL to improve performance?

  A. Query Optimization

  B. Predicate Push down

  C. Compression efficiency

  D. Load data into DB2 and return the data

  Correct Answer: A

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSZLC2_7.0.0/ com.ibm.commerce.developer.soa.doc/refs/rsdperformanceworkspaces.htm