Chapter 6 MIS flashcards by anki gpt

1
Q

What are the two primary data types in organizations?

A

Transactional and analytical.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Define real-time data.

A

Immediate, up-to-date information.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a common cause of data inconsistency?

A

Varying data formats and entry standards.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Name a benefit of high-quality data.

A

Improved decision-making.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What does data governance involve?

A

Managing data’s availability, usability, and security.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Define a database.

A

Stores data about objects, events, people, and places.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What does a DBMS do?

A

Manages creation, reading, updating, and deletion of data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Define a data model.

A

Details relationships between data elements.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is metadata?

A

Descriptive details about data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Explain a primary key in a database.

A

Uniquely identifies an entity in a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What advantage does reduced data redundancy offer?

A

Minimizes data inconsistencies.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How does a relational integrity constraint work?

A

Ensures data quality by enforcing rules.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Why is data security important?

A

To protect organizational assets.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Define business intelligence (BI).

A

Analyzing data for better business decision-making.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What challenge is posed by being “data rich, information poor”?

A

Difficulty in transforming data into insights.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the main purpose of a data warehouse?

A

Aggregating data for decision-making.

17
Q

Describe ETL (Extraction, Transformation, Loading).

A

Process for preparing data for a data warehouse.

18
Q

What is a data lake?

A

Storage for raw data until needed.

19
Q

What is data cleansing?

A

Fixing inconsistent or incorrect data.

20
Q

How do data visualization tools assist BI?

A

By visually displaying patterns and trends.