CIS exam 3

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Management Organizational Structure

View Set

Multivariable Calculus, 14.4 Curvature, Math 14.2-14.5, Math new material 15.5-15.8

View Set

Saunders- Ch.23: Labor and Birth w/ Rationale

View Set

MGMT: Intro to Business, Chapter Assignments, Chapters 1-7.., etc.

View Set

SAU Comm 135-L Final Exam chp 1-16

View Set

Setting up deep forecasting environment

View Set