Module 4: Data Management

What is a key guideline for designing structured data?

• Each column should have a single and consistent purpose

• Use multi-value columns

• Use long text as attribute names

• Avoid using any labels

What does the Personal Data Protection Act 2010 (PDPA) define as sensitive personal data?

• Data related to financial transactions

• Data about physical or mental health

• Data about employment history

• Data about educational background

What is the purpose of data anonymization?

• To enhance data quality

• To increase data storage capacity

• To remove Personal Identifiable Information (PII)

• To improve data visualization

Which of the following is an example of transactional data?

• A database of customer feedback

• A collection of marketing strategies

• Employee payroll records

• A list of employee names

What is the first step in controlling data quality in Excel?

• Using conditional formatting

• Creating a pivot table

• Formatting cells

• Setting up data validation rules

What is the purpose of using a surrogate key in data management?

• To enhance data visualization

• To uniquely identify each row

• To create multi-value columns

• To store sensitive information

Which of the following is NOT a guideline for structured data design?

• Use consistent label names for each column

• Avoid attributes whose values may frequently be empty

• Avoid long text as attribute names

• Use multi-value columns

What is a common method for ensuring data integrity in databases?

• Using unstructured data

• Implementing data redundancy

• Storing data in multiple formats

• Using foreign keys