Data Resource Management

Question 1

How does a database management system address the traditional file environment problem of redundancy?

1. By allowing ad hoc queries to avoid having to write complicated programs.
2. By allowing the organization to centrally manage data and its use.
3. By enabling data to stand on their own, apart from applications.
4. By minimizing isolated files in which the same data are repeated.

Answer 1

By minimizing isolated files in which the same data are repeated.

Question 2

Which capability of database management systems relates to adding or deleting data from the database?

1. Data reduction
2. Data definition
3. Data correction
4. Data manipulation

Answer 2

Data manipulation

Question 3

Which role do database management systems have in organizations?

1. Conducting predictive data analytics
2. Correcting data outliers
3. Facilitating data sharing
4. Using customer data to predict profitability

Answer 3

Facilitating data sharing

Question 4

A large organization is working on implementing a relational database management system and wants to have a high level of data integrity.

Which action should this organization take to achieve a high level of data integrity?

1. Restructure content as needed to enhance performance.
2. Ensure that entries follow defined rules.
3. Design structures to reduce redundancy.
4. Set up tables with appropriate columns and value types.

Answer 4

Ensure that entries follow defined rules.

Question 5

What do companies use data mining to accomplish?
1. Monitoring online communities for public opinions.
2. Extracting patterns from large sets of information.
3. Discovering operational insights from wearable devices.
4. Optimizing delivery routes using location-based information.

Answer 5

Extracting patterns from large sets of information.

Question 6

Which business intelligence gathering method is used to present insights regularly in a structured format?

1. Social media analytics
2. Prescriptive analytics
3. Internet of Things analytics
4. Reporting tools

Answer 6

Reporting tools

Question 7

Which method is used to gather information about widespread consumer trends?

1. Descriptive analytics
2. Benchmarking
3. Reporting tools
4. Market research

Answer 7

Market research

Question 8

What do companies use geospatial intelligence to accomplish?

1. Identifying areas of improvement by comparing key performance indicators with competitors.
2. Examining raw data to draw conclusions from past trends.
3. Optimizing delivery routes using location-based data.
4. Uncovering trends in large sets of information using machine learning.

Answer 8

Optimizing delivery routes using location-based data.

Question 9

An organization is working on improving data quality throughout its operations. The organization is specifically ensuring that data is available to those who need it.

Which aspect of data quality is the organization addressing?

1. Consistency
2. Accessibility
3. Usability
4. Accuracy

Answer 9

Accessibility

Question 10

An organization with a large online presence has been struggling to maintain data quality with the rapid growth of the business. As part of its current effort to improve data quality, the organization would like to establish rules for organizational information sharing.

Which tool should the organization use?

1. Data governance
2. Data analytics
3. Data cleansing
4. Data auditing

Answer 10

Data governance