Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SQL > NoSQL for SQL Professionals > Flashcards

NoSQL for SQL Professionals 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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

JSON data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which of the following is not true about RDBMS databases?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

NoSQL is a highly scalable relational database.

A

FALSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

MapReduce

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

key-value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

SET

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

They are non-relational.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

NC Columnstore Index

SSAS Tabular Models

In-Memory OLTP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

FALSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

SQL (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions