Databases Quiz

Key features of cloud databases include...

-Enterprise users are able to host databases without the need to buy and maintain specialized hardware -Can be self-managed or maintained and managed by a provider -Accessed through the web or an API supported by the vendor (Application Programming Interface) -Support SQL and NoSQL databases

The acronym for a database administrator is ________.

DBA

Forms are created using ________ software.

DBMS

________ involves identifying errors in data sets and removing/correcting these errors to ensure the data is accurate.

Data scrubbing

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

Middlewear

Referential integrity is the ________ and ________ of data within a table relationship in a database.

accuracy consistency

Databases are designed to keep data and information about different types of data objects, including objects, events, ________, and places.

people

OLAP is used to support businesses in a wide range of areas including ________.

performance management financial reporting simulation model

To set a primary key field in a database table, you must click the ________ key button.

primary

The data mining process includes knowledge deployment, ________, ________, and ________

problem definition data gathering and preparation model building and evaluation

Areas covered in digital governance include data architecture, data ________, data modeling, data warehousing, and data security.

quality

The major advantages of executing a data quality audit include ________.

reduced risk of data inconsistency reduced data storage costs data improvement recommendations

Examples of data scrubbing include which of the following?

removal of duplicate database records correcting misspelled words fixing syntax issues

Information in a database table is made up of ________ called records or objects, and ________ called fields.

rows columns

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

rules

ERD is a method of describing the architecture of databases structurally by using tables.

FALSE

Data redundancy is the ________ of data.

duplication

RAM storage and ________ processing are two main in-memory computing components.

parallel

Areas covered in digital governance include data architecture, data quality, data modeling, data warehousing, and data ________.

security

When creating a relationship in a relational database management system (DBMS), which object is used?

table

Usability in web mining refers to how a website ________ and ________ can interact with a website.

users visitors

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

values

Accessibility in web mining includes the structure of the ________ and ________ to ensure device/platform access and scalability.

websites pages

When data is centralized, it means data is harder to maintain.

FALSE

In a data warehouse, data is analyzed using business intelligence (BI) tools, ________ clients, and a variety of analytics applications designed to interpret the data.

SQL

A hybrid data mart separates 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.

FALSE

Business Intelligence (BI) encompasses management , computer systems, and processes for gathering, evaluating, and displaying company knowledge to aid in decision making.

FALSE

Four types of action queries are included in many RDBMS and include requests for append, delete, update, and statement.

FALSE

In-memory computing is the use of middleware hardware to help store data around one computer in random access memory (RAM).

FALSE

RAM storage and unparalleled processing are two main components of in-memory computing.

FALSE

When using multiple lists and data sources, information can become consistent and lead to an increase in data integrity?

FALSE

Common database field names for a Members table would include which fields?

FirstName LastName CellPhone

What does the abbreviation SQL stand for?

Structured Query Language

A cloud database platform includes the hardware and operating environment of servers in an internet-based datacenter.

TRUE

A data mart is a division of a data warehouse explicitly built and constructed for individual departments or business functions.

TRUE

A data warehouse is a storehouse of data and information that organizations analyze to make informed business and operational decisions.

TRUE

Action queries (except for make-table queries that create new tables) make changes or move data in tables (records) on which they are based.

TRUE

The Four Vs of big data include Volume: Scale of Data, Variety: Different forms of data, Veracity: Uncertainty of data, and Velocity: Analysis of streaming data.

TRUE

Web mining uses data mining principles for uncovering and extracting information from blogs, social media pages, e-commerce networks, and web services.

TRUE

Popular applications used by today's organizations in web mining include Google Analytics, Data Miner, and ________.

Tableau

The common characteristics of big data include

Volume Variety Veracity Velocity

Commonly used techniques to gain information in web mining include ________, ________,and ________.

WCM WSM WUM

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

analysis

Data mining is a means of ________ data that can help organizations find patterns and relationships within data sets.

analyzing

Tasks of a database administrator (DBA) include database security, tuning, ________, and creation of queries and reports used to assist business decisions.

backup

A cloud database is a type of database that is ________ and ________ via a cloud platform.

built, created accessed

When data is stored in one place, it means it is ________.

centralized

The Foreign Key is a ________ field between tables that is not the primary key.

common

A query can filter data based on specific ________ also known as ________.

conditions criteria

There are many query tools included in an RDBMS database program; those query tools include ________ queries, action queries, ________ queries, and queries specific to the SQL.

crosstab parameter

Data centralization is necessary for maintaining ________.

data integrity

Reports offer a way to view, format, and summarize the information in a ________.

database

The primary key field cannot hold a ________ or ________ value.

duplicate null text

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

enhanced

When multiple lists and data integrity. sources are maintained, information can become ________, leading to decreased data

inconsistent

Data redundancy can lead to which three of the following?

increased storage fees inefficient access times inconsistent data

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 marts are used to track ________, purchase transactions, and the supply chain.

inventories

A database relationship is a(n) ________ between tables that define how the data are related.

link

A Database Management System (DBMS) has the ability for ________ and database ________ to manipulate, query, and store information in a database.

managers administrators

A DBMS provides the ability to ________, query, and store information in a database for managers and database administrators.

monitor

Doing a data quality audit helps ensure the highest quality of data being used for business intelligence and other applications. The data analysis method involves quality assessment, design, transformation, and ________.

monitoring

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

organize