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?
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.
Which of the following is the query or processing paradigm that was invented and used with Hadoop?
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.
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?
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?
_____ 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?
Using the NoSQL database Redis, what is the command that is comparable to Insert command in RDBMs databases like SQL?
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
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.
Which of the following Cloud storage is the cheapest?
Which of the following Cloud-base file storage is offered by Microsoft?
The scaling of Hadoop on the Amazon Cloud is an example of a NoSQL scaling on top of MapReduce.
Which of he following is a category of NoSQL databases?
Which of the following cloud-base key value store database is a schema- less database where you only need to specify the primary key?
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.
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.
_____ 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.
Considering the volume, _____ , variety, and veracity is key to deciding whether and which NoSQL database to use?
The most important thing about the NoSQL data is its _____ because it plays a big role in the usefulness of this data.
Who created Presto?
Which of these is not a benefit of Presto?
Which component of Presto parses queries?
Which of these non-relational databases can Presto query?
What clause combines multiple data sources in a single Presto query?
Which clause allows you to store the results of a query inside an alias?
Which grouping clause returns a hierarchical result grouping result set?
Which conditional expression will trap errors in your SQL statement?
Which date function will aggregate a date value to the month level?
Which function will return NULL if the conversion between two data types fails?
Which function will order the values inside an array?
Which function will let you combine maps?
Which function will convert a string to a JSON object?