Exam II

Operational and informational systems are generally separated because of which of the following factors? A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications. A properly designed data warehouse decreases value to data. A separate data warehouse increases contention for resources. Only operational systems allow SQL statements.

A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications.

NoSQL focuses on: Avoidance of replication of data Minimizing storage space Normalized data Flexibility

Flexibility

Loading data into the warehouse does not involve? Appending new rows and tables to the data warehouse Purging data that may have become obsolete or were incorrectly loaded Formatting the hard drive Updating rows with new data

Formatting the hard drive

The process of combining data from various sources into a single table or view is called: Extracting Updating Selecting Joining

Joining

When using MapReduce, a _____ function takes a collection and data and sorts and filters it into a set key-value pairs Reduce Map Data block

Map

According to your text, NoSQL stands for: Numbered SQL No SQL Not Only SQL Numeric Only SQL

Not Only SQL

_____ Is an important scripting language to help reduce the complexity of MapReduce Pig Horse Dog Cat

Pig

Event driven propagation: Provides a means to duplicate data for events Pushes data to duplicate sites as an event occurs Pulls duplicate data from redundant sites Triggers a virus

Pushes data to duplicate sites as an event occurs

Conformed dimensions allow users to do the following: Delete correlated data Query across fact tables with consistency Identify viruses in websites Fix viruses in html'documents

Query across fact tables with consistency

________ technologies are allowing more opportunities for real-time data warehouses.

RFID

Informational systems are designed for all of the following EXCEPT: Running a business real time Support decision making Complex queries Data mining

Running a business real time

NoSQL systems allow ______, by incorporating servers that can be easily added to the architectural solution. Scaling down Scaling out Scaling up Scaling over

Scaling out

When reporting and analysis organization of the data is determined when the data is used is called a(n): Entity relationship diagram Schema binding Schema on read Cognitive schema

Schema on read

It is true that in an HDFS cluster the NameNode is the: Large number of slaves Single master server Language library Business intelligence

Single master server

An expanded version of a star schema in which all tables are fully normalized is called a(n) Snowflake schema Operational schema DSS schema Complete schema

Snowflake schema

Big Data includes: large volumes of data with many different data types that are processed at very high speeds. large volumes of entity relationship diagrams (ERD) with many different data types that are processed at very high speeds. large volumes of data entry with a single data type processed at very high speeds. large volumes of entity relationship diagrams (ERD) with a single data type processed at very high speeds.

large volumes of data with many different data types that are processed at very high speeds.

Data federation is a technique which: Creates an integrated database from several separate databases Creates a distributed database Provides a virtual view of integrated data without actually creating one centralized database Provides a real-time update of shared data

provides a virtual view of integrated data without actually creating one centralized database.

A data mart is a(n): Enterprise-wide data warehouse Smaller system built upon file processing technology Data warehouse that is limited in scope Generic on-line shopping site

A data warehouse that is limited in scope

The process of transforming data from a detailed to a summary level is called: Extracting Updating Joining Aggregating

Aggregating

Grain and duration have an impact on the size of ________ tables. Selection Grain Fact Figure

Fact

A dependent data mart: Is filled with data extracted directly from the operational system. Is filled exclusively from the enterprise data warehouse with reconciled data. Is dependent upon an operational system. Participates in a relationship with an entity.

Is filled exclusively from the enterprise data warehouse with reconciled data.

The NoSQL model that includes a simple pair of a key and an associated collection of values is called a: Key-value store Document store Wide-column store Graph database

Key-value store

It is True in HDFS clusters Data Nodes are the: Large number slaves Single master servers Language barriers Business intelligences

Large number slaves

Informational and operational data differ in all of the following ways EXCEPT: Level of detail Normalization level Scope of data Data quality

Level of detail

The hadoop Framework consists of the ____ algorithm to solve large scale problems. MapSystem MapReduce MapCluster MapComponent

MapReduce

An organization that requires a graph database that is highly scalable would select the _____ database management system. Access Excel spreadsheet Neo4j Redis

Neo4j

An organization using HDFS realizes that the hardware failure is an? Norm Anomaly Irregularity inconsistency

Norm

The process of transforming data from a detailed to a summary level is called? Irregularity Norm Inconsistency Normalization

Normalization

_______ includes concern about data quality issues. Velocity Vigilant Veracity Variety

Veracity

Which of the follow factors drive the need for data warehousing? Informational data must be kept together with operational data Businesses need an integrated view of company information Data Warehouses generally have better security None of the above

Businesses need an integrated view of company information

When using a HDFS, the __ node creates new files by communicating with the __ node. Client; name Data; name Data; client Host; client

Client; name

Apache Cassandra is a leading producer of _____ NoSQL database management systems. Key value store Columnar Relational Graph

Columnar

All of the following are tasks of data cleansing EXCEPT? Decoding data to make them understandable for data warehousing applications. Adding time stamps to distinguish values for the same attribute over time. Generating primary keys for each row of a table. Creating foreign keys.

Creating foreign keys

All of the following are ways to consolidate data EXCEPT. Application integration Data Rollup and integration Business Process Integration User interaction integration

Data Rollup and integration

When we consider data in the data warehouse to be time variant, we mean: That the time of storage varies Data in the warehouse contain a time dimension so that they may be used to study trends and changes That there is a time delay between when the data are posted and when we report on the data That time is relative

Data in the warehouse contain a time dimension so that they may be used to study trends and changes

_____ duplicates data across databases Data propagation Data duplication Redundant replication A replication server

Data propagation

One characteristic of independent data marts is complexity for end users when they need access to data in separate data marts. This complexity is caused by not only having to access data from separate databases, but also form: The possibility of a new generation of inconsistent data systems, the data marts themselves Lack of user training Denormalized data Incongruent data formats

The possibility of a new generation of inconsistent data systems, the data marts themselves

The key discovery that triggered the development of data warehousing was: Computer viruses New ways to present information using mobile devices The recognition of the differences between transactional and informational systems The invention of the ipad

The recognition of the differences between transactional and informational systems

_______ includes NoSQL accommodation of various data types. Velocity Vigilant Verified Variety

Variety

________ includes the value of speed in a NoSQL database. A) Velocity B) Vigilant C) Verified D) Variety

Velocity

The three v's commonly associated with big data include? Viewable, volume, and variety Volume, variety, velocity Verified, variety, and velocity Vigilant, viewable, and verified

Volume, variety, velocity

Factless Fact tables may apply when: We are deleting sales We are tracking sales We are taking inventory of a set of possible occurrences We are deleting correlated data

We are taking inventory of a set of possible occurrences

The level of detail in a fact table determined by the intersection of all components of the primary key, including all foreign keys and any other primary key elements, is called the: Span Grain Selection Aggregation

Grain

The NoSQL model that is specifically designed to maintain information regarding the relationships (often real-world instances of entities) between data items is called a: Key-value store Document store Wide-column store Graph oriented database

Graph oriented database

_____ is the most popular key-value store NoSQL database management system.

Neo4j