NoSQL for SQL Professionals Flashcards Preview

SQL > NoSQL for SQL Professionals > Flashcards

Flashcards in NoSQL for SQL Professionals Deck (43)
Loading flashcards...
1
Q

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

A

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.

2
Q

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

A

JSON data

3
Q

Which of the following is not true about RDBMS databases?

A

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

4
Q

NoSQL is a highly scalable relational database.

A

FALSE

5
Q

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

A

MapReduce

6
Q

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

A

Rent it via the cloud like Google Cloud Cloudera.

7
Q

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

A

TRUE

8
Q

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?

A

Map

9
Q

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?

A

Hadoop

10
Q

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

A

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

11
Q

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

A

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

12
Q

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

A

key-value

13
Q

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

A

SET

14
Q

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

A

They are non-relational.

15
Q

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

A

NC Columnstore Index

SSAS Tabular Models

In-Memory OLTP

16
Q

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

A

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

17
Q

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

A

FALSE

18
Q

Which of the following Cloud storage is the cheapest?

A

File storage

19
Q

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

A

Azure

20
Q

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

A

TRUE

21
Q

Which of he following is a category of NoSQL databases?

A

Wide-Column

Key/Value Persistent

Key/Value Volatile

22
Q

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

A

DynamoDB

23
Q

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

A

Formulate business questions.

24
Q

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.

A

FALSE

25
Q

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.

A

TRUE

26
Q

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

A

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.

27
Q

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

A

FALSE

28
Q

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

A

velocity

29
Q

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

A

veracity

30
Q

Who created Presto?

A

Facebook

31
Q

Which of these is not a benefit of Presto?

A

HiveQL

32
Q

Which component of Presto parses queries?

A

Coordinator

33
Q

Which of these non-relational databases can Presto query?

A

Apache Kafka

34
Q

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

A

JOIN

35
Q

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

A

WITH

36
Q

Which grouping clause returns a hierarchical result grouping result set?

A

ROLLUP

37
Q

Which conditional expression will trap errors in your SQL statement?

A

Try

38
Q

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

A

date_trunc

39
Q

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

A

try_cast

40
Q

Which function will order the values inside an array?

A

array_sort

41
Q

Which function will let you combine maps?

A

map_concat

42
Q

Which function will convert a string to a JSON object?

A

json_parse

43
Q
A