Chapter 6 Practice Test Questions

Unstructured data comes from sources such as word-processing documents and surveillance video.

• True

• False

The data for BI (business intelligence) comes from many sources.

• True

• False

Some insurance companies can detect fraudulent claims using BI and analytics software.

• True

• False

Creative data scientists--a key component of BI efforts in an organization--are people who are primarily focused on coming up with novel ways of analyzing data.

• True

• False

Users still need help from the IT function of the organization to create customer reports using modern reporting tools.

• True

• False

Marshall's company currently maintains their data on in-house servers, but his supervisor has asked him to research their options for having some or all of it hosted by a cloud service provider. Which challenge of big data is Marshall helping to address?

• where and how to store the data

• how to derive value from the relevant data

• how to choose what subset of data to store

• how to find the most relevant data nuggets

Which step of the ETL process has the goal of collecting source data from all the desired sources and converting it into a single format suitable for processing?

• edit

• load

• transform

• extract

A well-designed series of rules or algorithms is a key component of which stage of the ETL process?

• extract

• edit

• load

• transform

One key difference between a relational database and a NoSQL database is _____.

• where data comes from

• the way data storage and retrieval are modeled

• which vendors provide applicable software tools

• the data backup and recovery procedure

Hadoop's two major components are _____.

• a data processing component and a distributed file system

• a cluster and a group of servers

• a JobTracker and a group of TaskTrackers

• a real-time data processor and a framework for data analytics