Question 1

What is a data steward responsible for?

Accepted Answer

Data stewards are responsible for both acting as a liaison between the MIS department and the business units and ensuring that data policies, procedures, and standards are implemented across the organization.

Question 2

Why do relational databases use primary keys and foreign keys?

Accepted Answer

Primary keys and foreign keys are used in relational databases to create logical relationships between different tables. This allows for the organization and retrieval of related data across these tables.

Question 3

What is a foreign key?

Accepted Answer

A foreign key is a primary key from one table that is used in another table to establish a relationship between the two tables. It ensures referential integrity by linking the data in the two tables.

Question 4

Which of the following asks users to write lines of code to answer questions against a database?

Accepted Answer

Structured Query Language (SQL) is specifically designed for managing and manipulating relational databases. Users write lines of SQL code to query databases, retrieve data, and manipulate that data.

Question 5

What is the term for the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner?

Accepted Answer

The answer of What is the term for the management...

Question 6

A database maintains information on ________.

Accepted Answer

Databases are versatile systems used to maintain a wide variety of information, including inventory, transactions, and employee details, among other types of data.

Question 7

What is the term for the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data?

Accepted Answer

Data validation is the process of ensuring that a program operates on clean, correct and useful data. It involves checks and tests to confirm compliance with data governance policies, ensuring the accuracy and integrity of the data.

Question 8

What is master data management?

Accepted Answer

Master data management involves the processes, governance, policies, standards, and tools that consistently define and manage the critical data of an organization to provide a single point of reference. It ensures that the organization's data is uniform, accurate, consistent, and complete.

Question 9

Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

Accepted Answer

A Database Management System (DBMS) is designed to handle the creation, storage, retrieval, update, and management of data in databases. It also includes features for controlling access and ensuring security of the data stored within the database.

Question 10

What is the term for when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

Accepted Answer

Data gap analysis is the process where a company reviews its data to ensure it can meet business expectations and identifies any potential data gaps or areas where data might be missing.

Question 11

What maintains information about various types of objects, events, people, and places?

Accepted Answer

A database is specifically designed to store, retrieve, and manage information about various types of objects, events, people, and places, making it the correct choice.

Question 12

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

Accepted Answer

An entity in the relational database model represents a person, place, thing, transaction, or event about which information is stored. Entities are the basic units for which data is collected.

Question 13

What is data gap analysis?

Accepted Answer

Data gap analysis involves examining a company's data to see if it meets business needs and identifying any missing data that could hinder achieving those goals. It's a process for identifying if there are gaps in the data that need to be filled to support business processes or decisions.

Question 14

What is a primary key?

Accepted Answer

A primary key is a unique identifier for a record in a database table, ensuring that each record can be uniquely identified from the others.

Question 15

What is data latency?

Accepted Answer

Data latency refers to the delay between the time a request for data is made and the actual delivery or retrieval of that data. This can involve the time it takes for data to be transferred from its storage location to the end-user or application that requested it.

Question 16

What is the term for the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

Accepted Answer

Master data management (MDM) is the practice focused on the management of reference or master data shared by several different systems and groups within an organization. MDM aims to ensure this data is consistently defined, connected, and updated across the enterprise, covering entities like customers, products, employees, etc., to ensure uniformity, accuracy, consistency, and completeness of the organization's core data.

Question 17

What is data validation?

Accepted Answer

Data validation involves tests and evaluations to ensure that data is correct, complete, and meets the standards set by data governance policies.

Question 18

What is data stewardship?

Accepted Answer

Data stewardship refers to the management and oversight of an organization's data assets to ensure that they are utilized effectively, responsibly, and efficiently, in a way that maximizes their value.

Question 19

What is the term for the time it takes for data to be stored or retrieved?

Accepted Answer

Data latency refers to the time it takes for data to be stored or retrieved from a computer or network.

Question 20

What is a data steward?

Accepted Answer

A data steward is responsible for ensuring that data management policies and procedures are implemented across the organization, maintaining data quality and integrity.

Quiz 6: Valuing and Storing Organizational Informationdatabases