Which of the following is true about business intelligence and its relation to data?
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.
Which of the following data is considered semi-structured data?
JSON data
Which of the following is not true about RDBMS databases?
They can process high volumes of data at near real-time.
NoSQL is a highly scalable relational database.
FALSE
Which of the following is the query or processing paradigm that was invented and used with Hadoop?
MapReduce
Which of the following is the easiest way to get started with Hadoop?
Rent it via the cloud like Google Cloud Cloudera.
The Hive Query Editor uses a SQL-like language but it’s running against NoSQL implementation.
TRUE
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?
Map
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?
Hadoop
_____ databases are alternative types of databases which are designed to store a high volume and larger variety of data.
NoSQL databases are alternative types of databases which are designed to store a high volume and larger variety of data.
_____ is a NoSQL database that captures not only entities or objects but relationships such as social media information.
Graph is a NoSQL database that captures not only entities or objects but relationships such as social media information.
If your business needs huge and fast lookup tables, which of the following NoSQL databases do you choose?
key-value
Using the NoSQL database Redis, what is the command that is comparable to Insert command in RDBMs databases like SQL?
SET
Which of the following is true about Column-families type of wide-column store Databases?
They are non-relational.
Which of the following NoSQL features are available in SQL Server?
NC Columnstore Index
SSAS Tabular Models
In-Memory OLTP
How do you create a Non-Clustered Columnstore Index in SQL server?
Object Explore > right-click Indexes > New Index > Non-Clustered Columnstore Index
Any data that has to do with money or profit, you should put in a NoSQL database.
FALSE
Which of the following Cloud storage is the cheapest?
File storage
Which of the following Cloud-base file storage is offered by Microsoft?
Azure
The scaling of Hadoop on the Amazon Cloud is an example of a NoSQL scaling on top of MapReduce.
TRUE
Which of he following is a category of NoSQL databases?
Wide-Column
Key/Value Persistent
Key/Value Volatile
Which of the following cloud-base key value store database is a schema- less database where you only need to specify the primary key?
DynamoDB
What is the first step that you should take when applying NoSQL capabilities into your business so you can get actual business values?
Formulate business questions.
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.
FALSE
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.
TRUE
_____ as the data source and _____ libraries will be a solution for a business with unpredictable volume of data, huge velocity and some variety.
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.
NoSQL is not the way to go with startup companies because it is not appropriate for the companies’ data volume.
FALSE
Considering the volume, _____ , variety, and veracity is key to deciding whether and which NoSQL database to use?
velocity
The most important thing about the NoSQL data is its _____ because it plays a big role in the usefulness of this data.
veracity
Who created Presto?
Which of these is not a benefit of Presto?
HiveQL
Which component of Presto parses queries?
Coordinator
Which of these non-relational databases can Presto query?
Apache Kafka
What clause combines multiple data sources in a single Presto query?
JOIN
Which clause allows you to store the results of a query inside an alias?
WITH
Which grouping clause returns a hierarchical result grouping result set?
ROLLUP
Which conditional expression will trap errors in your SQL statement?
Try
Which date function will aggregate a date value to the month level?
date_trunc
Which function will return NULL if the conversion between two data types fails?
try_cast
Which function will order the values inside an array?
array_sort
Which function will let you combine maps?
map_concat
Which function will convert a string to a JSON object?
json_parse
