Chapter 3 Quiz

Which type of non-relation database is best for the simplest data modeling? a. key-value stores b. columnar database c. graph database d. document database e. object database

a. key-value stores

What benefit do non-relational databases have to a marketing analytics professional? a. they assist in machine-to-machine data retrieval b. they allow professionals to extract data from emails. documents, xml files, etc. c. they are more affordable since many are open source d. all of these

d. all of these

What is a primary key in a relational database? a. a column that uniquely identifies a row in the table b. none of the above c. a row that uniquely identifies a column in the table d. either a or b

a. a column that uniquely identifies a row in the table

What does a query do? a. allows you to ask a question and answer the said question through information pulled from the database b. it calculates the solution to a complex combination of statistical functions c. it stores information in a virtual "deep pit" for the purpose of future extraction d. all of these

a. allows you to ask a question and answer the said question through information pulled from the database

Hadoop is an open-source software framework that stores and processes large amounts of data using _____. a. commodity cluster hardware b. synchronous map-reduced algorithms c. commodity cluster software d. asynchronous map-reduced algorithms

a. commodity cluster hardware

The Hadoop Ecosystem encompasses Hadoop's various tools and projects which were designed to promote _______. a. optimal usability b. optimal reduction c. optimal efficiency d. optimal processing power

a. optimal usability

Big data are useless to a company unless a. the data are raw and unclean b. the company has a place to analyze and easily access the information c. the company finds something meaningful in the data quickly d. the data supports assumptions the company has made before analyzing them

b. the company has a place to analyze and easily access the information

What is the role of a relational database? a. to store semi-structured data so that a marketing analytics professional can retrieve the data b. to store large amounts of data and create easy access to important information c. none of these d. to manage and store big data

b. to store large amounts of data and create easy access to important information

What is one function that a relational database can do that a non-relational database cannot? a. update information b. delete information c. join queries d. retrieve information

c. join queries