WorksheetsData Management Quiz
Total questions: 97
Worksheet time: 32mins
What is one of the key aspects of data management mentioned in the document?
Ensuring data is fit for purpose on data entry
Ignoring data validity
Storing data in a single format
Avoiding data maintenance
Why is data considered a valuable asset to organizations?
It can be ignored without consequences
It requires no management
It supports organizational needs
It is always secure
What will you learn about in section 3.4 of the learning outcomes?
Data entry and maintenance concepts
Data visualization methods
Data modeling tools
Data access control methods
Which section covers the types of data access management across platforms?
3.8
3.5
3.2
3.9
What type of data is represented using a range of different number types, such as integer and decimal?
Text data
Media data
Numeric data
Logical data
Which type of data is represented using characters, words, and paragraphs?
Geospatial data
Text data
Temporal data
Media data
What type of data includes images, sounds, and videos?
Numeric data
Media data
Logical data
Temporal data
Which type of data represents elements and components found on the Earth's surface?
Temporal data
Geospatial data
Financial data
Employee data
What type of data represents a moment in time and is usually shown with a date or timestamp?
Logical data
Media data
Temporal data
Text data
What type of data has two states or choices, such as true or false?
Numeric data
Logical data
Geospatial data
Media data
Which type of data is sourced from advertising campaigns?
Sales data
Marketing data
Financial data
Employee data
What type of data will show the financial health of an organization?
Employee data
Marketing data
Financial data
Sales data
What is customer data likely to be stored in?
Customer relationship management (CRM) system
Data warehouse
Public repository
Social media account
What is the purpose of monitoring website traffic?
To increase the number of employees
To enhance the design and performance of the website
To decrease customer interaction
To store data in a warehouse
What is an example of open data?
Confidential company data
Google Open Data
Employee records
Private subscription data
What is a data warehouse used for?
Storing social media data
Central collection of key data for business decisions
Organizing public data
Monitoring website traffic
What is data cleaning?
Storing data in a logical manner
The process of going through data looking for errors and correcting them
Collecting data from external sources
Increasing website traffic
What is a key characteristic of data stored in a data warehouse?
It is unstructured and raw.
It is secure, reliable, and easy to manage.
It is only accessible by government agencies.
It is primarily used for real-time data analysis.
What is a data lake?
A structured data storage system.
A data store that holds data in an unstructured way.
A government database for public access.
A competitor analysis tool.
What is one benefit of a data lake?
It only stores processed data.
It allows for a range of analysis and processing.
It is limited to storing small data sets.
It requires a predefined format for data.
What is 'big data'?
Small data sets used for simple analysis.
Very large data sets that can be analyzed to produce trends and patterns.
Data that is only used by the government.
Data that cannot be stored in a data warehouse.
What role do suppliers play for most organizations?
They provide data analysis services.
They offer goods and materials needed for operations.
They manage the organization's data warehouse.
They compete with the organization for customers.
What is meant by temporal data?
Data related to time
Data stored in the cloud
Data about employee records
Data stored in folders
Which department will collect and store employee data?
Marketing
Human Resources
IT Support
Sales
What is website traffic?
The number of files in a folder
The amount of data stored in a database
The number of visitors to a website
The speed of internet connection
What is the difference between a data lake and a data warehouse?
Data lakes store structured data, data warehouses store unstructured data
Data lakes store raw data, data warehouses store processed data
Data lakes are used for real-time data, data warehouses for historical data
Data lakes are smaller than data warehouses
What is open data?
Data that is freely available to everyone
Data stored in a private database
Data that requires a password to access
Data that is encrypted
What is one of the main benefits of using a Network Attached Storage (NAS)?
It is cheaper than other storage options.
It allows easy addition of storage capacity.
It does not require a network connection.
It is the only backup option needed.
Which type of hard drive is known for having a high failure rate due to mechanical parts?
SSD
USB drive
HDD
NAS
What is a key characteristic of SSDs compared to HDDs?
SSDs have moving parts.
SSDs are slower in data access.
SSDs have no moving parts and are faster.
SSDs are more prone to failure.
What is the primary function of a file server?
To provide internet access
To store and manage files
To run applications
To connect to external devices
What is the primary purpose of a Storage Area Network (SAN)?
To provide internet access
To store, manage, and protect data
To enhance video streaming quality
To improve email communication
What is DaaS in the context of cloud storage?
Data as a Service
Device as a Service
Development as a Service
Design as a Service
Which type of cabling is typically used in a SAN network for better performance?
Copper cabling
Fibre optic cabling
Coaxial cabling
Wireless connection
What is a key benefit of using DaaS for organizations?
Reduces the need for physical office space
Enhances video quality
Reduces data sprawl and data silos
Increases the number of employees
What is the main characteristic of object storage in cloud systems?
Files are stored in a hierarchical structure
Files are broken into pieces and spread out
Files are stored in a single location
Files are encrypted and hidden
What is the purpose of an application programming interface (API) in object storage?
To classify data as an object
To access the data
To store data in blocks
To create a unique identifier
What is block storage typically linked with in the cloud?
A database
A SAN (Storage Area Network)
An API
A file system
What is a cloud-based database referred to as?
Software as a service (SaaS)
Database as a service (DBaaS)
Platform as a service (PaaS)
Infrastructure as a service (IaaS)
What are the core functions of data systems?
Input, saving/storage, processing, output, feedback loop
Input, processing, output, deletion
Storage, retrieval, deletion, backup
Analysis, storage, input, output
Diagram showing the differences between block storage and object storage
Block storage is typically used for databases and virtual machines, while object storage is used for unstructured data like media files.
Block storage is more scalable than object storage.
Object storage is typically used for databases and virtual machines, while block storage is used for unstructured data like media files.
Block storage is less reliable than object storage.
Where can input data be sourced from?
From a database
From a spreadsheet
From a text file
From a website
Identify one format that data can be saved in.
Spreadsheet
Image file
Audio file
What is processing?
Storing data
Converting data into output
Deleting data
Copying data
Identify one task that can take place during processing.
Printing
Analyzing
Archiving
Encrypting
What is meant by the term 'output'?
Raw data
Processed and analyzed data
Unused data
Archived data
What is the main purpose of a data dictionary in database management?
To store actual data records
To define user access levels
To contain metadata about the data
To execute database queries
Which type of data model describes how the system will be implemented using a specific DBMS?
Conceptual data model
Logical data model
Physical data model
Relational model
What is an entity in an Entity Relationship Diagram (ERD)?
A database query
A table
A data attribute
A user role
In an ERD, what does a one-to-many (1:M) relationship indicate?
One entity is linked to one entity
One entity is linked to many entities
Many entities are linked to one entity
Many entities are linked to many entities
What does the acronym DBMS stand for?
Data Backup Management System
Database Management System
Data Binary Management System
Digital Base Management System
In an ERD, what is a primary key used for?
To link tables together
To uniquely identify each record in a table
To store data temporarily
To encrypt data
What is the purpose of a data flow diagram (DFD)?
To encrypt data
To model how data and information flow through a digital system
To store data in a database
To create a backup of data
What is an external entity in a DFD?
A process within the system
A source of data input and output external to the system
A data store within the system
A flow of data within the system
Which of the following is NOT a component of a DFD?
External entity
Process
Data store
Encryption key
How does the hierarchical database model represent a database?
As a flat file
As a tree structure
As a network
As a relational table
Identify one relationship shown in an ERD.
One-to-one
Many-to-many
One-to-many
All of the above
What is an L0 DFD also known as?
Context diagram
Flowchart
Entity-relationship diagram
Use case diagram
What is the symbol for a data store?
Circle
Rectangle
Parallel lines
Diamond
Identify one rule for creating a DFD.
Data can flow in any direction
Every data flow must be labeled
There can be multiple outputs for each process
Data stores are optional
What is the purpose of entering data twice during verification?
To ensure the data is entered quickly
To check if the data is in the correct format
To verify that both data entries are identical
To prevent unauthorized access
What is a check digit used for in data entry?
To calculate the total number of entries
To identify errors caused by transposition
To format the data correctly
To ensure data is entered twice
Which of the following is NOT a method of verification?
Entering the data twice
Cross-checking
Format check
Validation
What does the International Book Standard Number (ISBN) use as a check?
The first digit
The 11th digit
The last two digits
The middle digit
What is the main goal of validation in data entry?
To ensure data is entered quickly
To prevent entry of data that does not meet predefined rules
To allow any data to be entered
To check the data twice
What is cross-checking?
Comparing data against a known list
Checking the length of data
Using colors to help users
Storing data securely
What does validation check the data against?
Random data
A list of known data
User preferences
Data length
What is a check digit?
A number used to verify the accuracy of data
A method to store data
A type of data entry error
A way to delete data
What does the presence check do?
Ensures data is entered
Compares data to a list
Deletes old data
Encrypts data
How is most data entered?
Through a data entry screen
Via email
Using a mobile app
Through voice commands
Why should data be kept secure and private?
To prevent unauthorized access and misuse
To increase data redundancy
To allow public access
To reduce data storage costs
Identify one group that can maintain data.
Marketing team
System administrator
Sales department
Customer service
What does the digital system administrator control?
Data entry speed
User access and permissions
Data visualization
Network bandwidth
Identify one financial consideration of data storage.
Data encryption costs
Increased storage capacity expenses
User training fees
Software development costs
Why would new software have to be purchased?
To improve user interface design
To replace obsolete software
To increase marketing reach
To enhance customer support
Identify two consistent items in a file-based structure.
Attributes and data types
Files and folders
Users and passwords
Servers and clients
What is a directory-based structure?
A structure where data is held in a single file
A structure where data is held across many files
A structure where data is stored in a database
A structure where data is stored on a server
What data modelling tool is used when creating a relational database?
ERD
SQL
XML
HTML
Identify two features that can be used to reduce data redundancy.
Normalisation and relationships
Encryption and compression
Backup and recovery
Sorting and filtering
What does SQL stand for?
Structured Query Language
Simple Query Language
Standard Query Language
Sequential Query Language
What is the main purpose of presenting data in reports?
To entertain the audience
To provide an easy-to-read format for end users
To confuse the end users
To hide the data from end users
Which technology allows users to be totally immersed in a virtual world with no sight of the real world?
Augmented Reality (AR)
Virtual Reality (VR)
Mixed Reality (MR)
Digital Slides
What is a common use of Augmented Reality (AR) in retail?
To create video games
To provide immersive experiences for customers to visualize furniture in their homes
To conduct webinars
To present data in reports
What is a webinar?
A type of digital slide
An online meeting hosted by an organization
A form of augmented reality
A video game
How can data be presented using video and sound?
By using a set of moving images
By writing a report
By conducting a webinar
By creating digital slides
What is one advantage of using graphs and charts to present data?
They can present data in a more complex way.
They are always more accurate than tables.
They allow data to be visualized in the form of diagrams.
They are easier to create than tables.
Which of the following is NOT a type of chart mentioned in the document?
Pie
Area
Funnel
Scatter
What is a dashboard primarily used for?
Creating animated presentations
Providing simple visualization of data related to performance indicators
Designing complex databases
Writing detailed reports
Why might data tables be preferred over graphs for certain data presentations?
They are always more visually appealing.
They can present very precise data values.
They are easier to create.
They can show trends more effectively.
What is an infographic according to the Oxford English Dictionary?
A detailed report of data
A visual representation of information or data
A collection of written essays
A summary of numerical data
What is the primary purpose of using a heat map?
To display numerical data in tables
To show geographical-related data visually
To create detailed written reports
To summarize text information
In a heat map, what does the darkest shade typically represent?
The lowest value
The average value
The greatest value
The median value
What is the main purpose of formal communication in a business setting?
To use slang and abbreviations
To report to line managers and meetings
To communicate informally with peers
To use incorrect sentence construction
Which of the following is considered an informal method of visualizing data?
Reports
Infographics
Formal presentations
Technical documents
What should be considered when selecting the method of data presentation and visualization?
The color scheme of the presentation
The audience's technical knowledge and skills
The length of the presentation
The number of slides in the presentation
What type of data is described as non-numerical?
Quantitative data
Statistical data
Qualitative data
Numerical data
What is the role of data in an organization?
To make uninformed decisions
To ignore the importance of data
To make informed and correct decisions
To reduce the need for analysis
