WorksheetsData and Security Concepts Quiz
Total questions: 31
Worksheet time: 16mins
Which of the following best describes data?
Contextualized facts with meaning
Raw symbols or numbers without interpretation
Organized knowledge used for decision-making
A set of trends extracted from a warehouse
What is Data?
Raw facts and figures without context
Processed facts given meaning
The ability to apply experience in decision-making
Insights derived from analyzed information
What is Information?
Experience-based judgment
Data organized and given context
Raw numbers with no meaning
Knowledge applied in real-life situations
What is Knowledge?
Raw observations collected from the environment
Data converted into tables and charts
Insights gained from analyzing information
Wisdom shared through storytelling
What is Wisdom?
Simply storing more knowledge
Applying knowledge and experience to make sound decisions
Organizing data into useful reports
Memorizing factual information
In a relational database, rows represent:
Fields
Keys
Records
Columns
Which of the following best describes a DBMS?
A software tool for formatting documents
A program that manages the storage, retrieval, and analysis of data in databases
A device that stores raw data only without processing
A tool for browsing the Internet
Which of the following is an example of metadata?
"1992" as a birth year stored in a database
The field name "Year of Birth" and its data type (integer)
A student's actual GPA value
A list of customer orders
Which of the following illustrates data mining?
Loading raw sales data into a spreadsheet
Identifying hidden purchase patterns after analyzing millions of transactions
Designing a database table with student IDs
Deleting duplicate records from a dataset
What makes Big Data "big"?
It always refers to personal data from social media
Its size and complexity exceed the capacity of traditional database tools
It can only be stored in personal DBMS like Access
It is a synonym for metadata
The main purpose of a data warehouse is to:
Replace all operational databases
Store time-stamped, standardized copies of data for analysis
Delete irrelevant information from company databases
Serve as a temporary backup of files
Why do data mining and data brokers raise privacy concerns?
They only store data temporarily
They can combine information from multiple sources to profile individuals
They are unable to process metadata
They always require user consent before analyzing data
Business intelligence is best defined as:
Using data analysis to gain competitive advantage
Replacing human managers with AI systems
An internal-only system that excludes external data
Another term for a data warehouse
How does business analytics differ from business intelligence?
Analytics focuses on improving internal processes, while BI emphasizes overall competitive strategy
Analytics only uses external data, while BI uses only internal data
Analytics is a synonym for data mining
Analytics eliminates the need for databases
What is the primary goal of knowledge management in organizations?
To store only operational data in warehouses
To capture and organize company knowledge for reuse and decision-making
To replace databases with employee experiences
To delete outdated employee records
In building a data warehouse, the ETL process involves:
Encrypting, Tracking, and Loading data
Extracting data, Transforming it into a standard format, and Loading it into the warehouse
Editing Tables Locally in the database
Exporting Temporary Logs for analysis
Which of the following is an example of "something you are" in authentication?
Password
Smart card
Fingerprint
PIN
Using a PIN plus an RSA token is an example of:
Single-factor authentication
Biometric authentication
Multi-factor authentication
Password recycling
What is the main difference between ACL (Access Control List) and RBAC (Role-Based Access Control)?
ACL assigns permissions based on roles, while RBAC assigns them per user
ACL assigns permissions per user, while RBAC assigns permissions based on roles
Both assign permissions per user only
RBAC is less secure than ACL
In public key encryption, which key is kept secret?
Session key
Public key
Private key
Shared key
Which of the following is considered a poor password practice?
Changing passwords every 60-90 days
Using "123456" as a password
Using at least one upper-case, one number, and one special character
Avoiding dictionary words
Why should backup data be stored offsite?
To comply with encryption rules
To ensure data survives disasters at the main site
To prevent duplication
To reduce storage costs
What is the main purpose of a firewall?
To block viruses from infecting computers
To filter network packets based on security rules
To encrypt sensitive files
To back up company data
Which of the following best describes an IDS?
Prevents hackers from entering the system
Monitors network traffic and alerts on suspicious activity
Replaces the need for firewalls
Encrypts user data
The primary purpose of a VPN is to:
Encrypt backup data stored offsite
Allow secure remote access to a corporate network
Replace firewalls and IDS
Provide two-factor authentication
Which of the following is an example of physical security?
Complex passwords
Firewall configurations
Locked server rooms
VPN connections
Which of the following best describes multi-factor authentication (MFA)?
Using multiple usernames to log in
Combining two or more methods such as password, token, or biometric scan
Encrypting data with multiple algorithms
Requiring frequent password changes
In access control, which model assigns permissions based on organizational roles rather than individual users?
Access Control List (ACL)
Role-Based Access Control (RBAC)
Biometric Control Model (BCM)
Multi-Layer Access Model (MLAM)
Which of the following BEST represents confidentiality in information security?
Ensuring that data is available when needed
Preventing unauthorized access to data
Making sure data is accurate and consistent
Backing up files regularly
Integrity in the CIA triad refers to:
Protecting data from being disclosed without permission
Ensuring data is accurate, consistent, and not tampered with
Making sure systems are available during peak usage
Encrypting all sensitive communications
Which scenario BEST illustrates availability?
A company encrypts its files before sending them
A server is configured with redundancy to prevent downtime
A user logs in with a fingerprint scanner
A database is updated with corrected values
