Home Certification SQL Access for Hadoop Cognitive Class Exam Answers

SQL Access for Hadoop Cognitive Class Exam Answers

1060
0

Apply for this Certification : SQL Access for Hadoop Cognitive Class Exam Answers

Big Data University: BD0145EN

Module 1: Big SQL Overview SQL Access for Hadoop

Question 1 :Which Big SQL architecture component is responsible for accepting queries?

  • Hive Server
  • Scheduler
  • Worker Node
  • DDL Processing Engine
  • Master Node

Question 2 :Big SQL differs from Big SQL v1 in which of the following ways? Select all that apply.

  • Big SQL does not have support for HBase
  • Big SQL v1 reserves double quotes for identifiers
  • Big SQL requires the HADOOP keyword for table creation
  • Big SQL v1 treats single and double quotes as the same
  • DDL in Big SQL v1 is a superset of Big SQL

Question 3 :In Big SQL, what is the term for the default directory in the distributed file system (DFS) where tables are stored?

  • Schema
  • Metastore
  • Table
  • Warehouse
  • Partitioned Table

Module 2: Big SQL data types

Question 1 :What are the main data type categories in Big SQL? Select all that apply.

  • SQL
  • INT
  • Declared
  • REAL
  • Hive

Question 2 :When creating a table, which keyword is used to specify the DFS directory for storing data files?

  • EXTERNAL
  • HADOOP
  • USE
  • CHECK
  • LOCATION

Question 3 :Which human-readable Big SQL file format uses a character to separate column values?

  • Avro
  • Parquet
  • ORC
  • Sequence
  • Delimited

Final Exam

Question 1 : In order to use Big SQL, you need to learn several new query languages. True or false?

  • True
  • False

Question 2: Which component serves as the main interface between Big SQL and Hadoop?

  • Hive Metastore
  • Big SQL Master Node
  • Scheduler
  • Big SQL Worker Node
  • UDF FMP

Question 3 : Officially, there are two different releases of Big SQL. True or false?

  • True
  • False

Question 4 :Which of the following statements is true of a partitioned table?

  • Query predicates can be used to avoid scanning every partition
  • A table may be partitioned on one or more rows
  • Data is stored in multiple directories for each partition
  • The partitions are specified only when data is inserted
  • All of the above

Question 5 :Which of the following statements is true of JSqsh?

  • JSqsh supports multiple active sessions
  • JSqsh is an open source command client
  • JSqsh can be used to work with Big SQL
  • The term JSqsh derives from “Java SQL Shell”
  • All of the above

Question 6 : Which of the following statements is true of the SQL data type?

  • The database  engine supports the SQL data type
  • There are more declared data types than SQL data types
  • SQL data types are provided in the CREATE statement
  • SQL data types tell SerDe how to encode and decode values
  • All of the above

Question 7 : In Big SQL, the STRING and VARCHAR types are equivalent and can be used interchangeably. True or false?

  • True
  • False

Question 8 : What is the default Big SQL schema?

  • “admin”
  • Your login name
  • “warehouse”
  • “default”
  • The schema that was previously used

Question 9 : Which of the following statements are true of Parquet files? Select all that apply.

  • Parquet files are supported by the native I/O engine
  • Parquet files provide a columnar storage format
  • Parquet files support the DATE and TIMESTAMP data types
  • Parquet is a high-performance file format
  • Parquet files are good for data interchange outside of Hadoop

Question 10 : Which of the following statements are true of ORC files? Select all that apply.

  • ORC files are supported by the native I/O engine
  • ORC files are good for data interchange outside of Hadoop
  • Individual columns can be retrieved efficiently
  • ORC files can be efficiently compressed
  • Big SQL can exploit every advanced ORC feature

Question 11 : Which of the following statements is NOT true of the Native I/O processing engine?

  • There is a high-speed interface for common file formats
  • The native engine supports the delimited file format, among others
  • The native engine is highly optimized and parallelized
  • The native engine is written in Java
  • All of the above statements are true

Question 12 : Which of the following statements about Big SQL are true? Select all that apply.

  • Big SQL comes with comprehensive SQL support
  • Big SQL provides a powerful SQL query rewriter
  • Big SQL currently doesn’t support subqueries
  • Big SQL queries can only be written for one data source
  • Big SQL supports all the standard join operations

Question 13 : Which keyword indicates that the data in a table is not managed by the database manager?

  • USE
  • LOCATION
  • EXTERNAL
  • HADOOP
  • CHECK

Question 14 : The Avro file format is more efficient than Parquet and ORC. True or false?

  • True
  • False

Question 15 : Which statement accurately characterizes the Big SQL data types?

  • Sequence files are the fastest format
  • Delimited files are the most efficient format
  • ORC files can be efficiently compressed
  • Avro is human readable
  • RC files replaced ORC files

LEAVE A REPLY

Please enter your comment!
Please enter your name here