Free C2090-101 Exam Braindumps
IBM Big Data Engineer Questions 31–35 (page: 8)

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

  1. Flume
  2. Data Click
  3. DataStage
  4. Big SQL Load

Answer(s): A



What is Flume?

  1. A distributed filesystem
  2. A platform for executing MapReduce jobs
  3. A programming language that translates high-level queries into map tasks and reduce tasks
  4. A service for moving large amounts of data around a cluster soon after the data is produced.

Answer(s): 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



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

  1. TIFF, and CSF
  2. TIFF, and PNG
  3. JPEG, and PNG
  4. Plain Text, and CSV

Answer(s): A


Reference:

https://www-01.ibm.com/software/info/channel-solution-profiles/Information_Graphics_Redact-

It.html



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

  1. The data is only processed in memory
  2. Customer data is never allowed in testing or development
  3. The data is never stored longer than 24 hours in the test system
  4. The data is only stored in volatile storage that expires on power loss

Answer(s): D



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

  1. Which one of the following statements is true for using HiveQL?
  2. It supports four logical operators in query predicates: IN, NOT IN, EXISTS, and NOT EXISTS
  3. It does not support nested sub-queries
  4. Hive supports all ANSI SQL 2011 syntax
  5. All of the above

Answer(s): A


Reference:

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



Viewing page 8 of 23
Viewing questions 36 - 40 out of 106 questions


Post your Comments and Discuss IBM C2090-101 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!