Quiz 8

What does the acronym RDBMS stand for?

Relational Database Management Systems

Data governance policies help to ensure an organization's data is valid, understandable, complete, and ________.

accessible

There are many RDBMS query tools we can use. Those query tools include crosstab queries, ________ queries, parameter queries, and queries specific to SQL.

action

Data marts assist with the ________ of what data a user needs rather than focusing on existing data.

analysis

The role of a DBA is to ________ and maintain tables in a relational database.

build

When creating a field in a database, the field type specifies the type of ________ in the field.

data

A cloud database infrastructure integrates computer hardware and operating system in an internet-based ________.

data center

Knowledge Discovery in Data (KDD) is also known as ________.

data mining

Search Engine Optimization (SEO) can be ________ through the information gained by web mining.

enhanced

Data scrubbing (data cleaning) involves identifying ________ in data sets then duplicating these errors to ensure the data is accurate for an organization.

errors

A hybrid data mart ________ data from a data warehouse as well as other data collection systems. It incorporates a top-down approach, end-user inputs, and enterprise-level integration.

integrates

Data centralization is necessary for maintaining ________.

integrity

The DBMS (Database Management System) is designed to administer and ________ a database.

organize

A ________ key must contain a unique value.

primary

Parameter queries ________ the user for values to execute/run a query.

prompt

Because we can create relationships in Microsoft Access, this program is considered to be a(n) ________ database.

relational

One reason to create database policies is to specify the ________ used in database design (how the data is structured)

rules

Data governance involves the staff, procedures, and technologies needed to ________ and protect the data and data properties of an entity.

supervise

Parameter queries prompt the user for ________ to run a query.

values

________ is software with processing capabilities outside of what the operating system of the consumer provides.

Middlewear