What is Big SQL?
A. Big SQL is a feature in Data Explorer that allows for indexing of data from SQL sources such as data warehouses.
B. Big SQL is a feature in BigInsights that allows for native SQL query access for Hadoop, providing full ANSI SQL 92 compliance and standardSQL syntax such as joins, for data contained in a variety of formats such as structured Hive tables, Hbase tables, or csv and other delimitedfiles in HDFS.
C. Big SQL is a feature in Streams that allows for real time analysis of data via standard SQL syntax.
D. Big SQL is a feature in BigInsights that provides a SQL like interface to data contained in Hbase tables only. Other data sources in HDFS mustbe accessed via other means such as HiveQL.
What does ig Data represent?
A. A Hadoop feature capable of processing vast amounts of data in-parallel on large clusters of commodity hardware in a reliable, fault-tolerant manner.
B. A concept and platform of technologies with the characteristics of the ? Vs? that is able to handle large amounts of unstructured,semi-structured, and structured raw data unlike traditional systems.
C. A database feature capable of converting pre-existing structured data into unstructured raw data.
D. Only data stored in the BIGDATA table in any relational database.
How do existing applications usually connect to InfoSphere BigInsights using the Big SQL feature?
A. Applications will connect using custom made connectors programmed in SPL.
B. Applications will connect using standard JDBC and ODBC drivers that come with InfoSphere BigInsights.
C. Applications will connect using the JAQL programming language.
D. Applications will connect using either HiveQL or Pig programming languages.
Hadoop environments are optimized for:
A. Processing transactions (random access).
B. Low latency data access.
C. Batch processing on large files.
D. Intensive calculation with little data.
Which of the following options DOES NOT describe an advantage of InfoSphere BigInsights on top of regular standalone Hadoop distributions?
A. Integrated install
B. BigSheets
C. Adaptive MapReduce
D. Support to HiveQL and PigLatin languages.
Which of the following options best describes the proper usage of MapReduce jobs in Hadoop environments?
A. MapReduce jobs are used to process vast amounts of data in-parallel on large clusters of commodity hardware in a reliable, fault-tolerant manner.
B. MapReduce jobs are used to process small amounts of data in-parallel on expensive hardware, without fault-tolerance.
C. MapReduce jobs are used to process structured data in sequence, with fault-tolerance.
D. MapReduce jobs are used to execute sequential search outside the Hadoop environment using a built-in UDF to access information stored in non-relational databases.
Which of the following InfoSphere BigInsights features provides a vast library of extractors enabling actionable insights from large amounts of native textual data?
A. Text Analytics.
B. Adaptive MapReduce.
C. General Parallel File System.
D. BigSheets.
Which of the following options contain security enhancements available in InfoSphere BigInsights (choose two) ?
A. LDAP authentication
B. Secure file transfers through SFTP protocol.
C. Trusted Context.
D. Kerberos authentication protocol.
Which of the following integrated development environment (IDE) can be used to develop programs to be used with InfoSphere BigInsights?
A. InfoSphere Data Explorer.
B. IBM Data Studio with InfoSphere Data Explorer plug-in.
C. InfoSphere Streams Studio
D. Eclipse with InfoSphere BigInsights plug-in.
The analytic capabilities that come built-in with the Big Data platform include:
A. Image and Video
B. Acoustic
C. Financial
D. All of the above
