CIS 323 Exam 3
Sarbane Oxley
privacy again financial records
Extensible Markup Language (XML) is:
A scripting language that allows the creation of customized tags to enable easier sharing of data across organizations
Controls designed to restrict access and activities are called:
Authorization Rules
The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the:
Grain
Data governance can be defined as:
High-level organizational groups and processes that oversee data stewardship
The Unified Modeling Language (UML):
Is a notation useful for graphically depicting an object-oriented analysis or design model.
The NoSQL model that includes a simple pair of a key and an associated collection of values is called a:
Key-value score
Big Data includes:
Large volumes of data with many different data types that are processed at very high speeds.
A class of database technology used to store textual and other unstructured data is called:
NoSQL
The use of a set of graphical tools that provides users with multidimensional views of their data is called
On-line analytical processing (OLAP)
In the ________ approach, one consolidated record is maintained and all applications draw on that one actual "golden" record.
Persistent
Descriptive, predictive, and ________ are the three main types of analytics.
Prescriptive
Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.
Reconciled
________ is used to undo unwanted database changes.
Rollback
Which of the following characterizes homogeneous environments?
Same DBMS used at all locations
SOAP stands for
Simple Object Access Protocol Method
Hadoop/Map reduce
?
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.
An open-source DBMS is:
A free source-code RBMS that provides the functionality of an SQL-compliant DBMS
At a basic level, analytics refers to:
Analysis and interpretation of data
Web Services
Are a set of emerging standards for protocols for automatic communication between software
Which of the following factors drive the need for data warehousing?
Businesses need an integrated view of company information.
An emerging trend likely to have an effect on the development of three-tier applications is called:
Cloud Computing
The actions that must be taken to ensure data integrity is maintained during multiple simultaneous transactions are called ________ actions
Concurrency control
Which of the following is NOT a method for storing XML documents?
Convert to text
A repository of information about a database that documents data elements of a database is called a:
Data Dictionary
When a data repository (including internal and external data) does NOT follow a predefined schema, this is called a
Data Lake
Converting data from the format of its source to the format of its destination is called
Data Transformation
Conformance means that:
Data are stored, exchanged or presented in a format that is specified by its metadata.
The role of a ________ emphasizes integration and coordination of metadata across many datasources.
Data warehouse administrator
A data mart is a(n):
Data warehouse that is limited in scope.
A computer that provides database storage and access in a client/server environment is called a(n):
Database Server
________ is a technical function responsible for database design, security, and disaster recovery
Database administration
A(n) ________ is a database stored on multiple computers in multiple locations that are NOT connected by a data communications link.
Decentralized database
________ is the technique of hiding the internal implementation details of an object from its external view
Encapsulation
A researcher trying to explain why sales of garden supplies in Hawaii have decreased would be an example of ________ data mining
Explanatory
The goal of data mining related to analyzing data for unexpected relationships is:
Exploratory
A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a(n)
Fat Client
Event-drive propagation:
Pushes data to duplicate sites as an event occurs
A PC configured to handle user interface with little or no local storage is called a:
Thin Client
Data in the data warehouse contain a time dimension so that they may be used to study trends and changes.
Time-Varient
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
TQM stands for
Total Quality Management.
A discrete unit of work that must be processed completely or not at all within a computer system is called a
Transaction
User interaction integration is achieved by creating fewer ________ that feed different systems
User Interfaces
fact tables > impact of grain and duration
Transactional grain-finest level Aggregated grain-more summarized Finer grains better market basket analysis capability Finer grain more dimension tables, more rows in fact table In Web-based commerce, finest granularity is a click
Two other V's
Veracity, Value
The three 'v's commonly associated with big data include
Volume, variety, and velocity