Databases

The key goals of data governance include rules for data use, requirement compliance, high-quality data, and ________.

• server space

• cost reduction

• data scrubbing

• database objects

Answer explanation

The key goals of data governance include rules for data use, requirement compliance, high-quality data, and cost reduction.

Database forms structure data input to ensure data ________.

• language

• integrity

• information

• control

Answer explanation

Forms structure data input to ensure data integrity.

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

• database

• field

• report

• platform

Answer explanation

Reports offer a way to view, format, and summarize the information in a database. They are primarily designed for printing.

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

• screen readers

• servers

• websites

• pages

Answer explanation

Accessibility in web mining includes the structure of website and pages to ensure device/platform access and scalability, providing the information is available to users and access for those with physical and cognitive limitations.

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

• True

• False

Answer explanation

Web mining uses the principles of data mining to uncover and extract information from website, social media sites, e-commerce platforms, and web services.

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

• True

• False

Answer explanation

A data mart is a subsection of a data warehouse that is designed and built specifically for individual departments or business functions.

What object is used to store information when creating a database?

• queries

• tables

• forms

• reports

Answer explanation

Tables are used to store information when creating a database.

A database and a DBMS are different. A database is a collection of metadata, relationships, and ________.

• forms

• tables

• queries

• reports

Answer explanation

A database is a collection of tables, relationships, and metadata.

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

• True

• False

Answer explanation

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

Examples of data scrubbing include which of the following?

• correcting misspelled words

• removal of duplicate database records

• creating data tables

• fixing syntax issues

Answer explanation

Examples of data errors data scrubbing can resolve to include: elimination of duplicate database records, correcting misspellings, correcting incorrect names and address, and fixing syntax issues.