Quiz #4: Databases
Data redundancy can lead to which three of the following?
increased storage fees, inefficient access times, inconsistent data
Data marts are used to track ________, purchase transactions, and the supply chain.
inventories
A Database Management System (DBMS) has the ability for ________ and database ________ to manipulate, query, and store information in a database.
managers, administrators
The primary key field cannot hold a ________ or ________ value.
null, duplicate
OLAP is used to support businesses in a wide range of areas including ________.
performance management, financial reporting, simulation model
Parameter queries ________ the user for values to execute/run a query.
prompt
Some of the duties a database administrator performs include ________.
security, tuning, backup
data quality audit uses ________ analysis to test data, variabilities, and outcomes against test data.
statistical
Commonly used techniques to gain information in web mining include, ________, ________, and ________.
1. Web Content Mining (WCM) 2. Web Structure Mining (WSM) 3. Web Usage Mining (WUM)
A cloud database is a type of database that is ________ and ________ via a cloud platform.
1. built, created 2. accessed
The data mining process includes knowledge deployment, ________, ________, and ________
1. problem definition 2. data gathering and preparation 3. model building and evaluation
The main objectives of data governance include high-quality data and which other goals?
1. risk mitigation risk mitigation 2.data use rules data use rules 3. requirement compliance requirement compliance 4. cost-saving
Knowledge Discovery in Data (KDD) is also known as ________.
data mining
The acronym for Data Governance is ________.
DG
________ is software with processing capabilities outside of what the operating system of the consumer provides.
Middlewear
Structured Query Language (SQL)-specific queries use specific SQL ________ to execute the query.
Statements
What does the abbreviation SQL stand for?
Structured Query Language
We use a ________ field between the two database tables to create a relationship link.
common
Basic DBMS functions allow users to ________, read, ________, and ________ data.
create, update, delete
Usability in web mining refers to how a website ________ and ________ can interact with a website.
users, visitors, pages