CIS exam 3
3 accurate statements reflecting the business advantages of relational database
-increased information integrity -increased information security -reduces information redundancy
four functions that a database management system can perform on data in a database
-read data -create data -update data -delete data
social media analysis
Analyzes text flowing across the Internet, including unstructured text from blogs and messages
what creates, reads, updates, and deletes data in a database while co trolling access and security
Databade management system
what stores informations about a person, place, thing, transaction, or event
Entity
what is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse
Extraction, Transformation, and Loading
what are the rules that help ensure the quality of information
Integrity constraints
what is the tool that consists of lines of code for answering questions against a database
Structured query language
cluster analysis
a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible
___ grouping analysis reveals the relationship between variables along wi to the nature and frequency of the relationships
affinity
data ___ is the collection of data from various sources for the purpose of data processing
aggregation
Classification
assigns records to one of a predefined set of classes
what defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer
business rule
what is the process of organizing data into categories of groups for its most effective and efficient use
classification analysis
3 terms for the data elements associated with an entity
columns, attributes, fields
integrity ____ are rules that help ensure the quality of information
constraints
what is the common term for the representation of multidimensional information
cube
who is a business analytics specialist who uses visual tools to help people understand complex data
data artist
what compiles all of the metadata about the data elements in the data model
data dictionary
what is the smallest or basic unit of information
data element
term that is a synonym for data element
data field
what is the process of analyzing data to extract information not offered by the raw data alone
data mining
what are logical data structures that detail the relationships among data elements using graphics or pictures
data models
what maintains information about various types of objects?
database
correlation analysis
determines a statistical relationship between variables, often for the purpose of identifying predictive factors among the variables
affinity grouping
determines the relationships between variables and the nature of the relationships
estimation
determines values for an unknown continuous variable behavior or estimated future value
estimation analysis
determines values for an unknown continuous variable behavior or estimated future value
___ data is erroneous or flawed data
dirty
clustering
divides information that is similar into groups that are mutually exclusive of each other
the relationship between entities and attributes in a relational database
each record in an attribute occupies one row in its respective table
what is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between two tables
foreign key
what is a broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system by associating user rights and restrictions with the established identity
identity management
what is a process that weeds out and fixed or discards inconsistent, incorrect, or incomplete information
information cleansing
what is the duplication of data, or the storage of the same data in multiple places
information redundancy
two terms that describe the process for weeding out, fixing, or discarding inconsistent, incorrect, or incomplete information
information scrubbing, information cleansing
A data __________ contains a subset of data warehouse information.
mart
____ provides details about data
metadata
what provided details about data
metadata
data ___ are logical data structures that detail the relationships among data elements using graphics or pictures
models
a ___ key is a field that uniquely identifies a given record in a table
primary
what is a collection of related data elements
records
____ integrity constraints are rules that enforce basic and fundamental information-based constraints
relational
a ___ is a central location in which data is stored
repository
what is a central location in which data is stored
repository
affinity grouping analysis
reveals the relationship between variables along with the nature and frequency of the relationships
a data ___ extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information
scientist
a ____ query language asks users to write lines of code to answer questions against a database
structured
pattern recognition analysis
the classification or labeling of an identified pattern in the machine learning process
classification analysis
the process of organizing data into categories or groups for its most effective and efficient use
Behavior Analysis
using data about people's behaviors to understand intent and predict future actions
data ___ visualization describes technologies that allowed users to "see" or visualize data to transform information into a business perspective
visualization
a data ___ is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks
warehouse