IT - PT 5

Which of the following best illustrates the relationship between entities and attributes? - The entity ADDRESS with the attribute CUSTOMER - The entity CUSTOMER with the attribute PRODUCT - The entity PRODUCT with the attribute PURCHASE - The entity PRODUCT with the attribute CUSTOMER - The entity CUSTOMER with the attribute ADDRESS

The entity CUSTOMER with the attribute ADDRESS

Data governance encompasses an organization's policies and procedures through which data can be managed as an organizational resource. True or False

True

Microsoft Access uses SQL to retrieve information from a database. True or False

True

The project operation: - organizes elements into segments. - creates a subset consisting of rows in a table. - identifies the table from which the columns will be selected. - combines relational tables to provide the user with more information than is otherwise available. - creates a subset consisting of columns in a table.

creates a subset consisting of columns in a table.

A ________ is a structured survey of the accuracy and level of completeness of the data in an information system. data overview data quality audit systems analysis data analysis systems audit

data quality audit

In the context of data mining, the term sequences refers to: - undiscovered groupings. - occurrences linked to a single event. - forecasts as to the future values of various variables. - events linked over time. - patterns that describe a group to which an item belongs.

events linked over time.

In a relational database, a table contains all of the following except: three-dimensional relations. attributes. records. entities. columns.

three-dimensional relations

Which of the following statements about a data mart is not true? - A data mart typically serves a specific population of users. - A data mart may contain a summarized portion of an organization's data. - A data mart is a repository for raw, unstructured data. - A data mart typically focuses on a single subject area or line of business. - A data mart is a subset of a data warehouse.

A data mart is a repository for raw, unstructured data.

In data mining, which of the following involves the ability to find groupings within data? Forecasting Clustering Classifications Sequences Association

Clustering

Which of the following establishes rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information? Data cleansing Data mining Data quality audit Logical database design Data governance

Data governance

Which of the following allows users to add, change, delete, or retrieve data in a database? Report generation tools Data dictionary Data manipulation language Query wizard tool Attribute generation

Data manipulation language

Which of the following statements about data warehouses is not true? - They provide a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities. - They store data of potential interest to decision makers throughout a company. - Data warehouse systems provide easy-to-use tools for managers to easily update data. - Data warehouses make data available for anyone to access as needed. - They may include data from website transactions.

Data warehouse systems provide easy-to-use tools for managers to easily update data.

Common data quality problems include all of the following except: misspelled names. transposed numbers. missing codes. Internet connectivity problems. incorrect codes.

Internet connectivity problems.

Which of the following is not a true statement with respect to data mining and OLAP? - OLAP requires users to have a good idea about the information they are seeking. - OLAP supports multi-dimensional analysis. - Data mining provides insights from data that cannot be obtained with OLAP. - Data mining can infer rules from patterns to make predictions about future behavior. - OLAP is more discovery-driven than data mining.

OLAP is more discovery-driven than data mining.

Data mining allows users to: - obtain online answers to ad hoc questions in a rapid amount of time. - summarize massive amounts of data into much smaller, traditional reports. - perform multidimensional data analysis. - quickly compare transaction data gathered over many years. - find hidden patterns and relationships in data.

find hidden patterns and relationships in data.

In the context of data mining, the term associations refers to: - using a series of existing values to predict future values. - events linked over time. - occurrences linked to a single event. - undiscovered groupings. - patterns that describe a group to which an item belongs.

occurrences linked to a single event.

OLAP enables users to: - find hidden patterns in large databases. - quickly diagram data relationships. normalize data. - view both logical and physical views of data. - perform a multidimensional data analysis.

perform a multidimensional data analysis.

A DBMS makes a: - physical database available for different analytical views. - relational database available for different physical views. - physical database available for different logical views. - physical database available for different physical views. - logical database available for different analytical views.

physical database available for different logical views.

In a relational database, the three basic operations used to develop useful sets of data are: - select, project, and join. - who, what, and where. - select, from, and join. - select, join, and where. - select, project, and where.

select, project, and join

The physical view of a database: - allows the creation of supplementary reports. - shows the relationships between entities and attributes. - shows how data are organized and structured on the storage media. - presents an entry screen to the user. - presents data as they would be perceived by end users.

shows how data are organized and structured on the storage media.