NoSQL for SQL Professionals

Question 1

Which of the following is true about business intelligence and its relation to data?

Answer 1

It helps businesses answer many questions related to their operations.

It turns data into usable information for businesses.

It drives implementation of new types of database technologies like NoSQL.

Question 2

Which of the following data is considered semi-structured data?

Answer 2

JSON data

Question 3

Which of the following is not true about RDBMS databases?

Answer 3

They can process high volumes of data at near real-time.

Question 4

NoSQL is a highly scalable relational database.

Answer 4

FALSE

Question 5

Which of the following is the query or processing paradigm that was invented and used with Hadoop?

Answer 5

MapReduce

Question 6

Which of the following is the easiest way to get started with Hadoop?

Answer 6

Rent it via the cloud like Google Cloud Cloudera.

Question 7

The Hive Query Editor uses a SQL-like language but it’s running against NoSQL implementation.

Answer 7

TRUE

Question 8

At which of the following phases of the MapReduce programming paradigm does the incoming data get processed into output of a key and a value?

Answer 8

Map

Question 9

When you have a huge amount of data in terabytes or petabytes and when you have non-structured data or semi-structured data, which architectural pattern do you use for this data?

Answer 9

Hadoop

Question 10

_____ databases are alternative types of databases which are designed to store a high volume and larger variety of data.

Answer 10

NoSQL databases are alternative types of databases which are designed to store a high volume and larger variety of data.

Question 11

_____ is a NoSQL database that captures not only entities or objects but relationships such as social media information.

Answer 11

Graph is a NoSQL database that captures not only entities or objects but relationships such as social media information.

Question 12

If your business needs huge and fast lookup tables, which of the following NoSQL databases do you choose?

Answer 12

key-value

Question 13

Using the NoSQL database Redis, what is the command that is comparable to Insert command in RDBMs databases like SQL?

Answer 13

SET

Question 14

Which of the following is true about Column-families type of wide-column store Databases?

Answer 14

They are non-relational.

Question 15

Which of the following NoSQL features are available in SQL Server?

Answer 15

NC Columnstore Index

SSAS Tabular Models

In-Memory OLTP

Question 16

How do you create a Non-Clustered Columnstore Index in SQL server?

Answer 16

Object Explore > right-click Indexes > New Index > Non-Clustered Columnstore Index

Question 17

Any data that has to do with money or profit, you should put in a NoSQL database.

Answer 17

FALSE

Question 18

Which of the following Cloud storage is the cheapest?

Answer 18

File storage

Question 19

Which of the following Cloud-base file storage is offered by Microsoft?

Answer 19

Azure

Question 20

The scaling of Hadoop on the Amazon Cloud is an example of a NoSQL scaling on top of MapReduce.

Answer 20

TRUE

Question 21

Which of he following is a category of NoSQL databases?

Answer 21

Wide-Column

Key/Value Persistent

Key/Value Volatile

Question 22

Which of the following cloud-base key value store database is a schema- less database where you only need to specify the primary key?

Answer 22

DynamoDB

Question 23

What is the first step that you should take when applying NoSQL capabilities into your business so you can get actual business values?

Answer 23

Formulate business questions.

Question 24

NoSQL will not be a good solution for a company with 1 terabyte of data where simple aggregate queries will be used to get results from this data and where the volume and velocity of the data is moderate with no variety.

Answer 24

FALSE

Question 25

NoSQL will be a good solution for a customer with 5 GB of data, where the customer will run real-time queries, and where the data will have a high growth with big volume a velocity in the future.

Answer 25

TRUE

Question 26

\_\_\_\_\_ as the data source and _____ libraries will be a solution for a business with unpredictable volume of data, huge velocity and some variety.

Answer 26

Hadoop as the data source and NoSQL libraries will be a solution for a business with unpredictable volume of data, huge velocity and some variety.

Question 27

NoSQL is not the way to go with startup companies because it is not appropriate for the companies' data volume.

Answer 27

FALSE

Question 28

Considering the volume, _____ , variety, and veracity is key to deciding whether and which NoSQL database to use?

Answer 28

velocity

Question 29

The most important thing about the NoSQL data is its _____ because it plays a big role in the usefulness of this data.

Answer 29

veracity

Question 30

Who created Presto?

Answer 30

Facebook

Question 31

Which of these is not a benefit of Presto?

Answer 31

HiveQL

Question 32

Which component of Presto parses queries?

Answer 32

Coordinator

Question 33

Which of these non-relational databases can Presto query?

Answer 33

Apache Kafka

Question 34

What clause combines multiple data sources in a single Presto query?

Answer 34

JOIN

Question 35

Which clause allows you to store the results of a query inside an alias?

Answer 35

WITH

Question 36

Which grouping clause returns a hierarchical result grouping result set?

Answer 36

ROLLUP

Question 37

Which conditional expression will trap errors in your SQL statement?

Answer 37

Try

Question 38

Which date function will aggregate a date value to the month level?

Answer 38

date\_trunc

Question 39

Which function will return NULL if the conversion between two data types fails?

Answer 39

try\_cast

Question 40

Which function will order the values inside an array?

Answer 40

array\_sort

Question 41

Which function will let you combine maps?

Answer 41

map\_concat

Question 42

Which function will convert a string to a JSON object?

Answer 42

json\_parse