WorksheetsQuản trị dữ liệu
Total questions: 129
Worksheet time: 1hrs 27mins
What is an example of structured data?
All are correct
Customer phone number
Customer address
Customer name
Why is it said that thanks to data management, businesses can shape their business strategy?
Because data management helps businesses understand consumers better
Because data management helps businesses understand industry trends better
Because data management helps businesses understand competitors better
All answers are correct
What does a proactive approach to data governance help businesses improve?
Reduce errors in data processing and improve data timeliness
Increase the amount of erroneous data that needs to be corrected
Increase the workload required to consolidate data from multiple sources
Reduce the ability to share data securely between departments
What does a proactive approach to data governance help businesses achieve?
Increase data usability and ensure consistency with the organization's vision
Make data sharing between departments more difficult
Increase costs related to poor quality data management
Reduce transparency in data processing
What benefits does data governance help organizations achieve?
Reduce transparency in data usage
Ensure data is not collected from different sources
Increase the amount of data collected each day
Enhance operational efficiency and save time and resources
What is the duration of data governance implementation?
Short-term and daily processes.
Medium-term.
No answer is correct.
Long-term and future-oriented.
What does an organization implement data governance to achieve?
What does an organization achieve by implementing data governance?
Ensuring that data is used correctly and complies with security and privacy regulations
Improving the performance of database systems
Conducting data analysis for strategic decisions
Optimizing data usage in daily operations
Why is it said that thanks to data management, businesses can shape their business strategy?
Because thanks to data management, businesses understand consumers better
Because thanks to data management, businesses understand industry trends better
Because thanks to data management, businesses understand competitors better
All answers are correct
Data management mainly relates to which of the following factors?
Processing, organizing, and storing data
Ensuring data security
Establishing data access rules
Building data protection policies
What is the main difference between data governance and data management based on the main objective criteria?
No answer is correct
Data management ensures high-quality, consistent data while data governance ensures data storage, processing, and analysis
Data governance ensures high-quality but inconsistent data while data management ensures effective data storage, processing, and analysis
Data governance ensures high-quality, consistent data while data management ensures effective data storage, processing, and analysis
Data management is the process of collecting, storing, organizing, and maintaining data in an organization, true or false:
True
False
Data quality governance helps organizations:
Integrate data from multiple sources
Protect data from security threats
Ensure that data is
Is the data in an organization true or false?
True
False
Data quality management helps organizations:
Integrate data from various sources
Protect data from security threats
Ensure that data is accurate, consistent, complete, and timely
Manage how data is created, stored, and deleted
What is the importance of data governance in a business?
Helps manage access rights and data security
Helps enhance operational efficiency
All statements are correct
Helps ensure data quality
Which of the following correctly describes data governance?
Performing data backup and recovery operations
Optimizing data usage for daily operations
Ensuring that data is managed and used legally and safely
Focusing on organizing and analyzing data
What factor does data governance primarily focus on in an organization?
Data storage and backup
Policies, regulations, and data security
Managing technical infrastructure
Data processing and analysis
Why is it said that tight data management helps employees access information faster?
Because it helps employees find the necessary data
No answer is correct
Because it helps employees easily search and retrieve necessary information
Because it helps employees retrieve the necessary data
Choose the correct statement about structured data?
Structured data is often qualitative data
No answer is correct
Structured data can be subjective opinions and business evaluations in text form
Structured data is often quantitative data
Why is it said that data management will help businesses save costs?
Because it will reduce the number of potential customers that the business can reach.
Because it will double the amount of work that needs to be done.
Because
How does data management help businesses save costs?
It reduces the number of potential customers that the business can reach.
It helps double the workload that needs to be done.
It complicates decision-making.
It avoids duplication when performing tasks.
Why does data governance focus on long-term strategy while data management emphasizes short-term activities?
Data governance does not care about daily activities, while data management focuses only on long-term strategy.
Data governance needs to establish policies and directions for the organization, while data management only needs to perform activities according to existing plans.
Data governance focuses on management tools and technologies, while data management cares about short-term results.
Data governance only cares about collecting and analyzing data in the short term, while data management plans for the long term.
Which of the following benefits is a result of data governance?
Increase the number of potential customers.
Enhance data accuracy and minimize risks.
Increase data maintenance costs.
Minimize compliance with data regulations.
What activities does data management include?
Organizing, storing, and processing data to meet usage needs.
Establishing data security policies and controlling access rights.
Setting standards for data protection.
Ensuring data always complies with legal regulations.
What results does data management help organizations achieve?
Analyzing and reporting data for managers.
Building data protection policies to ensure legality.
Processing, organizing, and storing data reasonably to serve business purposes.
What is a correct example of unstructured data?
Address
No correct answer
Purchase date
Customer survey feedback
Choose the correct statement about unstructured data
Unstructured data is often quantitative data
No correct answer
Unstructured data is often numbers, names, dates, addresses, transaction information.
Unstructured data is often qualitative data
Why is data management important in businesses?
Data management helps businesses understand their customers better
Data management helps businesses shape their business strategy
Data management helps businesses protect data safety
All correct answers
What does a proactive approach in data governance help businesses achieve?
Reduce compliance with data security regulations
Minimize the risk of data leaks and protect sensitive information
Increase uncontrolled access to data
Make it harder to detect security incidents
Data governance helps organizations ensure that data is:
Prone to errors and biases
Lost during analysis
No correct answer
High quality and reliable
What issues does data governance help organizations address?
Establish regulations on data access and usage permissions
Manage and organize data protection processes
Create comprehensive data management policies
Ensure data is organized logically and easily accessible
What does data governance help organizations do with data?
What does data governance help organize data for?
Managing business rules and ensuring data is understood and used correctly
Managing data for reporting and purposes
Building data strategies for the organization
Ensuring data is protected from security threats
Why is it said that data governance focuses on long-term strategy while data management emphasizes short-term activities?
Data governance focuses on tools and management technologies while data management cares about short-term results
Data governance needs to establish policies and directions for the organization, while data management only needs to perform planned activities
Data governance only cares about collecting and analyzing short-term data while data management plans for the long term
Why is establishing data quality standards necessary?
To ensure data is accurate and can support sound business decisions.
To increase the reliability of systems.
To minimize the costs of data collection and processing.
To analyze updated data more effectively.
What does role-based access control to data help businesses achieve?
Increase system storage capacity.
Automate data security processes.
Prevent unauthorized access and enhance data control.
Speed up data processing.
What are the characteristics of Reference Data?
Used for decision analysis.
Data providing standardized codes and rules.
Used in daily transactions.
Often changes over time.
What is Transactional Data?
What is Transactional Data?
Data used for normalization and classification.
Data that does not change and supports analysis.
Data describing the core entities of a business.
Data that changes frequently and records daily activities.
What is the main purpose of Analytical Data?
Support daily transactions.
Normalize conventions.
Manage entities within the business.
Analyze, make decisions, and plan.
How does Analytical Data differ from Transactional Data?
Analytical data is used for daily transaction activities, while transactional data supports decision-making.
Analytical data is aggregated, unchanging, while transactional data changes frequently.
Analytical data has no practical application in the company, while transactional data is the basis for business operations.
Analytical data does not need to be organized, while transactional data must be organized for analysis.
What is one of the roles of Reference Data in the system?
Automatically change to fit new transactions.
Provide analytical data for financial decisions.
Ensure consistency and standardization of information such as country codes and currency types.
Support the analysis of financial transactions over time.
How does Metadata help in data system management?
Helps standardize international conventions and standards.
Creates a clear structure for data types, aiding retrieval and management.
Provides information about customer behaviors in the system.
What does data integrity ensure in data management?
Enhances data sharing capabilities.
Ensures data is always accurate, consistent, and reliable.
Only ensures data security.
Creates new data for the system.
What does data standardization help in the organization?
Eliminates all errors in data.
Minimizes data usage.
Ensures data is used and managed according to common standards in the organization.
Creates inconsistent data.
How does transparency in data management help the organization?
Creates errors in data.
Enhances trust, minimizes risks, and supports the auditing process.
Prevents any changes in data.
Reduces the amount of data that needs to be stored.
Which principle in enterprise data management ensures that processes and activities related to data are carried out clearly, understandably, and can be tracked?
Standardization.
Auditability.
Integrity.
Transparency.
Which principle in data governance clearly defines who is responsible for decisions, processes, and controls related to data?
Change management.
Integrity.
Standardization.
Accountability.
The principle of 'Transparency' in data governance means:
Data management processes must be described in detail and easily traceable.
Decisions about data management must be made without review and assessment.
Data must be shared with all stakeholders without discrimination.
All data must be...
What is one of the measures to improve external communication?
Eliminate neutral data
Use CRM systems to personalize customer service
Delegate access based on roles
Enhance security for personal data
How is reference data used in the data analysis process?
Provide standard values to help classify and standardize data
Have no role in data analysis
Replace analytical data in the system
Reduce the accuracy of analytical data
What does finding transparency in data management mean?
Data can only be accessed by one manager
All data is public
Data is completely secured
Data management policies and processes are clear and understandable
What is the relationship between transaction data and master data?
Transaction data has been dependent data, unrelated to master data
Transaction data has no relationship with master data
Transaction data is data that the system must fully execute
Transaction data is the change of master data in daily transactions
What is Master Data?
Temporary data, frequently changing
Data that hinders analysis and decision making
Data that does not change frequently and is the foundation for business operations
Data that other entities belong to in the enterprise
Why is it necessary to establish data quality control rules?
To delegate data access more effectively
To speed up the process
Why is it necessary to establish data quality control rules?
To effectively control data access
To speed up data retrieval between systems
To ensure data accuracy and support sound business decisions
To reduce storage and processing costs
How does Metadata help in managing data systems?
Creates a clear structure for data types, facilitating retrieval and management
Helps standardize international conventions and standards
Provides information about customer behaviors in the system
Manages financial transactions in the enterprise
What is one of the most common risks in enterprise data governance?
Data loss due to technical failures or human error
Non-compliance with operational procedures
Loss of customer information
Increased infrastructure investment costs
How can data integrity be ensured during change management?
By not allowing any changes to occur
By monitoring and controlling all changes to reference and master data
By changing data without notification
By limiting the number of changes in the data
Which principle in enterprise data governance ensures consistency, accuracy, and ease of data exchange between departments and systems throughout the organization?
Standardization.
Change management
Integrity
Transparency
Which principle in enterprise data governance requires organizations to establish clear processes and common standards to ensure that data is always accurate, consistent, and retrievable from various sources throughout its lifecycle?
Standardization.
Change management
What are the clear processes and common standards to ensure that data is always accurate, consistent, and retrievable from different sources throughout its lifecycle?
Standardization
Change management
Integrity
Transparency
What measures minimize the risk of data loss?
Regular software updates
Creating manual storage processes
Building a disaster recovery plan (DRP)
Increasing the number of technical staff
What consequences can legal compliance risks cause?
Financial damage and loss of customer trust
Wrong business decisions
Data corruption due to technical issues
Data loss
How does master data affect business operations?
No impact on other business operations
Only used for financial reports
Supports data analysis from transactions
Forms the basis for transactions and decisions in the business
Why is it necessary to establish data backup and recovery policies?
To reduce data management costs
To ensure continuous and safe data in emergencies
To speed up data access
To increase real-time data processing efficiency
The data governance framework plays an important role in organizations because?
Ensures data is used for the right purposes and complies with legal regulations.
Completely eliminates risk management and communication.
Increases revenue and profit from data.
Supports the development of marketing strategies.
The goal of the data governance framework does NOT include?
Protecting data from unauthorized access.
Creating simulated datasets for testing.
Enhancing scientific data management capabilities.
Supporting business decisions.
What is one of the important goals of the data governance framework?
What is one of the important goals of the data governance framework?
Ensure software procurement.
Minimize fraud access to data.
Create simulated data.
Protect data from unauthorized access.
Enhancing the value of data helps organizations achieve:
Data-driven business decision making.
Scaling hardware systems.
Faster data usage.
Reducing personnel hiring costs.
Which role implements policies and oversees data?
Data manager
Senior management
Data user
Data owner
Why is it necessary to have policies and principles in the data governance framework?
To ensure security and proper data usage guidance.
To speed up data processing.
To minimize unnecessary data storage.
To increase the number of data users.
What do processes and regulations in the data governance framework primarily support?
Ensuring data analysis tools operate effectively.
Managing data collection, storage, processing, and control.
Increasing long-term data storage capacity.
Analyzing and predicting data.
Which organization developed the Data Management Body of Knowledge (DMBOK) data governance framework?
Data Governance Institute (DGI).
ISACA.
Data Management Association (DAMA).
Boston Consulting Group (BCG).
What does the COBIT data governance framework provide a roadmap for businesses to do in data governance?
Manage risks and measure performance.
Build modern data storage systems.
Support cost optimization in data management.
Manage and maintain data.
Which organization developed COBIT, the global IT governance framework?
ISACA
ISO
W
COBIT is a global IT governance framework developed by which organization?
ISACA
ISO
W3C
IEEE
The governance framework focused on data control in organizations is?
COBIT governance framework
DGI governance framework
SAS governance framework
DMBOK governance framework
The DGI framework identifies which factor as important in establishing data governance rules and policies?
Data ownership and clear responsibilities
Advanced data analytics tools
The combination of technology and operational processes
Compliance with legal data regulations
What does the SAS framework encourage businesses to do in building a data governance program?
Build a comprehensive data governance strategy aligned with business goals
Enhance the involvement of external parties in data control
Use new technology to change operational methods in the organization
Identify which types of data are important and should not be
Data management in the SAS governance framework includes which factors?
Providing advanced analytical tools for all departments
Ensuring data is used correctly and not manipulated over time
Managing quality, security, and compliance with data regulations
Managing financial budgets allocated
What does the DMBOK data governance framework provide for businesses?
Knowledge about data control in organizations
Detailed guidance on data security
Comprehensive knowledge about data governance
Principles for using information technology
The Data Governance Framework is a system that includes which components?
What are the components of the Data Governance Framework?
Financial models, business plans, and software
Policies, processes, standards, and tools
Legal regulations, contracts, and guidelines
Personnel, equipment, budget, and assets
Who is responsible for the accuracy and integrity of data in the organization of the data governance framework?
Data analyst
Data user
Data owner
Data manager
What does the SAS data governance framework primarily focus on?
Developing automated data management tools
Building a dedicated workforce for data governance
Linking data governance with the strategic goals of the enterprise
Creating friendly Data Governance environments
The governance framework that focuses on controlling data in the organization is:
COBIT governance framework
DMBOK governance framework
DGI governance framework
SAS governance framework
How does COBIT help organizations measure and control IT processes?
By indicating methods to optimize profits from software sales
By guiding organizations to reduce investment costs in technology
By providing metrics and standards to evaluate the performance of IT processes
By identifying the latest requirements for IT software
What is the main purpose of BCG's data governance framework?
To ensure the enterprise reduces data software costs
To build a detailed and professional data governance platform to ensure stability and long-term efficiency.
To manage third-party data tools
To improve data analysis capabilities without optimizing governance processes
"Ensuring data is accurate, complete, and consistent" is the goal of
"Ensuring accurate, complete, and consistent data" is which goal of the Data Governance Framework?
Optimize resources
Enhance data value
Improve data quality
Ensure regulatory compliance
Why is the role of the Data Steward important in data governance?
They use data in daily operations.
They build the entire software system.
They decide all data policies.
They are responsible for overseeing and enforcing data policies.
The BCG Data Governance Framework focuses on establishing what to ensure consistency and transparency in data governance processes?
Building data analysis and forecasting tools.
Data security regulations and standards.
Operational processes and governance tools.
Data structure, data catalog, and data model.
Which factor in the BCG Data Governance Framework helps organizations ensure consistency and transparency in data retrieval processes?
Data structure.
Data management processes.
Data tools.
Human resource training plans.
Which governance framework provides principles for using information technology?
BCG.
DGI.
SAS.
COBIT.
Which component in the data governance framework assigns roles and responsibilities for data governance?
Processes and regulations
Supporting technology and tools
Organizational structure
Policies and rules
Why is measurement and monitoring important in the data governance framework?
To eliminate all unnecessary data
To assess the effectiveness of data management and identify issues
To build new management processes
To reduce the cost of implementing new software
At
Why do businesses need an Intranet to manage resources centrally?
To speed up data transmission.
To reduce the number of management staff.
To ensure resources are always updated and secure.
To increase the scalability of the hardware system.
Which is a correct example of a location entity?
Delivery slip
No correct answer
Invoice
Store
Which is a correct example of an event entity?
Registration
Sale
All correct answers
Extension
What attributes does the customer entity include?
Address
Customer name
All are correct
Customer code
What is this representation model?
Network model
Constellation model
No correct answer
Snowflake model
What structure does the hierarchical data model use to organize data?
Layered structure.
Tree structure.
Table structure.
Network structure.
What does the object-oriented data model include?
A collection of objects, each with its own features and methods.
A collection of database tables and their relationships.
A collection of data tables and indexes.
A collection of hierarchical relationships between objects.
What is this representation model?
Constellation model
Network model
Relational model
Hierarchical model
How does the data model help businesses improve the exploration and standardization of data sources?
By enhancing data security measures.
By ensuring data objects are presented accurately and avoiding missing important data.
By minimizing dependence on external software and systems.
By enhancing unrestricted information sharing.
What does the semantic data model (SDM) help compared to modern database models?
Simplifies data structure.
Provides deeper insights into data relationships.
Reduces data storage costs.
Speeds up data queries.
What factors should be considered in the database structure design process to determine the data to be stored and exploited?
Only care about people and documents.
Only survey other systems and facilities.
Only consider documents and facilities.
Consider people, documents, facilities, and other systems.
In the 1NF (First Normal Form) standard, what requirement is mandatory for database tables?
Columns in the table must contain unique values and can contain duplicate values.
Columns in the table must contain atomic values and no columns can repeat.
Attribute values can contain multivalued values and do not need to be single values.
Attribute values must be calculated from other attributes.
If it is necessary to separate n-n relationships in the database model, what is the next step?
Create a new table and use foreign keys.
Split the table into single columns.
Check for redundant and missing fields.
Identify primary keys for entities.
What type of relationship will exist between the Invoice table and the Product table if each invoice can include multiple products and each product can appear in multiple invoices?
1-1
1-n
n-1
n-n
What type of relationship will exist between the Customer table and the Order table if each customer can create multiple orders?
What type of relationship exists between the Customer table and the Order table if each customer can create multiple orders and each order can only be created by one customer?
1-1
1-n
n-n
n-1
Which field below does not need to be stored in the database?
Unit of measure
Customer name
Total amount (calculated from unit price * quantity)
Invoice number
Which of the following is a correct example of an object entity?
Product
Car
All correct answers
Machinery
What types of data modeling are mentioned below?
Conceptual Data Model, Logical Data Model
Conceptual Data Model, Logical Data Model, Physical Data Model
No correct answer
Logical Data Model, Physical Data Model
What does the Entity-Relationship (ER) model represent?
Physical devices in the database.
Relationships between software in the system.
Entities and their relationships.
Data and computer programs in the system.
What is the purpose of designing the database structure?
Transforming real-world objects into tables in the database to meet storage and data retrieval requirements.
Automating the process of collecting data from external sources.
Optimizing query performance in the database.
Generating data analysis reports for the system.
When normalizing the database to 3NF, which fields need to be removed?
Fields with duplicate values
Fields that are transitively dependent on the primary key
No correct answer
Fields that depend on a part of the primary key
To transition from 1NF to 2NF, what action needs to be taken?
To transition from 1NF to 2NF, what action is needed?
Separate non-key dependent fields into a separate table
Split fields into single values
Decompose n-n relationships into 1-n relationships
Eliminate fields that depend on a part of the primary key
Which statement is correct about an entity set?
An entity set is a group of entities that are both similar and different
An entity set is a group of similar entities
An entity set is a group of different entities
None of the answers are correct
This is which representation model?
A relational model
A hierarchical model
A semantic model
A network model
What is the benefit of a data model in designing and applying a database?
The data model only affects the management of products and customers.
The data model only helps businesses store data efficiently.
The data model makes database design easier without concern for efficiency.
The data model helps businesses implement databases more accurately, efficiently, and logically.
For the order shown below:
The list of properties in the sales invoice includes: Sales order number, Sale date, supplier code, supplier name, address, product code, product name, unit, quantity, unit price.
Sale date, transaction code, transaction name, address, product code, product name, unit, quantity, unit price.
Sales order number, Sale date, customer code, customer name, address, product code, product name, unit, quantity, unit price.
All answers are correct
An example of a human entity is?
Student
Patient
