EMT Practice Test

1. Question Content...

---

Question1: Which of the following Hive data types is directly supported in Big SQL without any changes?

Question2: Which statement is TRUE about Big SQL?

Question3: Which file format support Column data compression? (Choose two.)

Question4: How are insights derived from Big Match moved to an MDM system?

Question5: Which of the following are capabilities of the Apache Spark project?

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

Question7: Which parameters are considered when configuring Big Match algorithm?

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

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

Question10: Which of the following Big SQL statements is valid?

Question11: In order for an SPSS Modeler stream to be incorporated for use in an InfoSphere Streams application leveraging SPSS Modeler Solution Publisher, you need to:

Question12: Which of the following is not a capability of Pig?

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

Question14: Which of the following is TRUE about a Resilient Distributed Dataset?

Question15: Which BigInsights tool is able to export data from Big SQL?

Question16: Which of the following is the most effective method for improving query performance on large Hive tables?

Question17: 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?

Question18: Which of the following Pig Latin expressions is used to sum a set of numbers in a bag?

Question19: Which of the following statements is TRUE regarding search visualization with Apache Hue?

Question20: Which tool below can be used for extracting data directly from an RDBMS and placing a copy within BigInsights as a ready-to-query table?

Question21: Given a file named readme.txt, which command will copy the readme.txt file to the <user> directory on the HDFS?

Question22: Which statement about the Jaqi Programming Language is TRUE?

Question23: Consider the following query:
curl "http://localhost:8983/sorl/gettingstarted/select?wt=json&indent=true&q=foundation&fl=id What is the restricted field?

Question24: Which format would be best for holding semi-structured data?

Question25: Which one of the following is NOT provided by the SerDe interface?

Question26: When we create a new table in Hive, which clause can be used in HiveSQL to indicate the storage file format?

Question27: Which of the following statements about MapReduce is true?