CIS 330 Quizzes

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(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system.

API (Application Program Interface)

________ is the process of assigning pieces of application code to clients or servers.

Application partitioning

Which of the following is a component of processing logic?

Business rules

Which of the following factors drive the need for data warehousing?

Businesses need an integrated view of company information.

All of the following are newer XML schema languages EXCEPT:

Document Type Declarations (DTDs).

Which of the following organizational trends does not encourage the need for data warehousing?

Downsizing

The development of the relational data model did not contribute to the emergence of data warehousing.

False

When multiple systems in an organization are synchronized, the need for data warehousing increases.

False

FLWOR is an acronym for:

For, LET, Where OrderBy, Return.

If you write a database application in a Java program, you are most likely to use the ________ API.

JDBC

Which of the following is a basic method for single field transformation?

Table lookup

Which of the following is false about three-tier architectures?

Tends to involve fatter clients than two-tier architectures

Advances in computer hardware, particularly the emergence of affordable mass storage and parallel computer architectures, was one of the key advances that led to the emergence of data warehousing.

True

Informational systems are designed to support decision making based on historical point-in-time and prediction data.

True

The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.

True

________ is a scripting language that allows for the creation of customized tags, and is often used to facilitate exchange of data between applications over the Web.

XML

An XML transformation language that allows applications to query both XML data and relational databases is called:

XQuery

________ facilitates the ability of applications to query relational data along with associated structured data.

XQuery

At a basic level, analytics refers to:

analysis and interpretation of data

Which of the following is NOT a method for storing XML documents?

convert to text

All of the following are tasks of data cleansing EXCEPT:

creating foreign keys.

Conformance means that:

data are stored, exchanged or presented in a format that is specified by its metadata.

Including data capture controls (i.e., dropdown lists) helps reduce ________ deteriorated data problems.

data entry

When we consider data in the data warehouse to be time-variant, we mean:

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

The Hadoop Distributed File System (HDFS) is the foundation of a ________ infrastructure of Hadoop.

data management

All of the following are ways to consolidate data EXCEPT:__

data rollup and integration.

Converting data from the format of its source to the format of its destination is called:

data transformation.

Allowing users to dive deeper into the view of data with online analytical processing (OLAP) is an important part of:

descriptive analytics.

When online analytical processing (OLAP) studies last year's sales, this represents:

descriptive analytics.

A(n) _______ client is a PC that is responsible for processing presentation logic, extensive application and business rules logic and even DBMS functions.

fat

Data governance can be defined as:

high-level organizational groups and processes that oversee data stewardship.

The best place to improve data entry across all applications is:

in the database definitions.

All of the following are characteristics of cloud technologies EXCEPT:

infinite bandwidth.

It is true that in an HDFS cluster the DataNodes are the:

large number of slaves.

Big Data includes:

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

A Web server:

processes client requests and returns HTML pages to the client

Event-driven propagation:

pushes data to duplicate sites as an event occurs.

XPath and XQuery are both technologies used to:

retrieve data from XML documents.

Data quality ROI stands for:

risk of incarceration.

It is true that in an HDFS cluster the NameNode is the:

single master server.

One simple task of a data quality audit is to:

statistically profile all files.

When an XML document is shredded, each element is:

stored in a relational table.

A(n) ________ is a module of code written in SQL or some proprietary language to run business rules from within a database server.

stored procedure

The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:

subject-oriented.

External data sources present problems for data quality because:

there is a lack of control over data quality.

A PC configured to handle user interface with little or no local storage is called a(n) _______ client.

thin

Cloud computing relies most heavily on:

three-tier architectures.

Quality data can be defined as being:

unique

Which of the following advances in information systems contributed to the emergence of data warehousing?

Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms.

Extensible Markup Language (XML) is:

a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations.

________ is/are any of several classes of software that allow an application to interoperate with other software without requiring the user to understand all software involved.

middleware

Descriptive, predictive, and ________ are the three main types of analytics.

prescriptive

The Hadoop framework consists of the ________ algorithm to solve large scale problems.

MapReduce

PHP is a popular API for MySQL because of all of the following EXCEPT:

Microsoft integration.

Which language would you expect to see in a stored procedure?

PL/SQL

Which of the following is an advantage of stored procedures?

Performance improves for compiled SQL statements.

The XML shown in the figure below describes some data from the Pine Valley Furniture case study. What does the following The following XPath expression return?

The standard price of products with a cherry finish

________ is a language used to transform complex XML documents and also to create HTML pages from XML documents.

XSLT

The process of transforming data from a detailed to a summary level is called:

aggregating

Extensible Business Reporting Language (XBRL) is an example of:

an XML-based vocabulary.

The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers.

application logic components

The the main idea behind ________ computing refers to a model for providing ubiquitous, convenient and on-demand access to shared computing resources.

cloud

A technique using pattern recognition to upgrade the quality of raw data is called:

data scrubbing.

The analysis of summarized data to support decision making is called:

informational processing.

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

joining

Informational and operational data differ in all of the following ways EXCEPT:

level of detail.

Data federation is a technique which:

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

Informational systems are designed for all of the following EXCEPT:

running a business in real time.

One characteristic of quality data which pertains to the expectation for the time between when data are expected and when they are available for use is:

timeliness

The three 'v's commonly associated with big data include:

volume, variety, and velocity.

Which of the following is an INCORRECT statement about stored procedures?

There can be significant network traffic increases using stored procedures as processing moves from client to server.