NEW
Font size
WorksheetsIT305
Total questions: 50
Worksheet time: 25mins
A centralized repository that stores large amounts of historical data from different sources.
Database
Data Mining
Data Warehouse
Data Analytics
Which characteristic of a data warehouse means it is organized around major business themes such as sales or customers?
Time-Variant
Subject-Oriented
Integrated
Non-volatile
Which characteristic ensures that data remains consistent even when sourced from different departments like finance, HR, and logistics?
Non-Volatile
Integrated
Subject-Oriented
Time-Variant
A data warehouse storing several years of historical data demonstrates what feature?
Time-Variant
Non-Volatile
Integrated
Subject-Oriented
Which data warehouse characteristic indicates that stored data is stable and not frequently updated or deleted?
Integrated
Non-Volatile
Time-Variant
Subject-Oriented
A company analyzing five years of customer purchase history relies on which data warehouse characteristic?
Integrated
Non-Volatile
Time-Variant
Subject-Oriented
A type of system used for day-to-day business operations.
OLAP
OLTP
SQL
RDBMS
A type of system used for analysis, reporting, and decision-making.
OLAP
OLTP
SQL
RDBMS
Which system is primarily used to run daily business operations?
OLAP
OLTP
Data Warehousing
Data Mining
Which type of users typically rely on OLAP systems?
Cashiers and Clerks
Frontline Staff
Managers and Analysts
Store Supervisors
What type of data does OLTP mainly handle?
Historical data
External Web Data
Current Operational Data
Archived Batch Data
Which of the following is an example of an OLAP system?
POS System
Banking Deposit System
ATM Withdrawal System
Sales Dashboard
Which system is best suited for performing aggregations and multidimensional analysis?
OLTP
OLAP
Operational Database
Cloud Storage System
A table in a data warehouse that stores numeric, measurable data used for analysis.
Fact Table
Database Table
Dimension Table
Excel Table
A table contains descriptive information about the business.
Fact Table
Database Table
Dimension Table
Excel Table
Which system is a smaller, department-focused version of a data warehouse?
Data Mart
Data Lake
ODS
OLTP System
Which of the following is typically used by a specific department like sales or HR?
Data Lake
Operational Database
Data Mart
ODS
Which system stores near real-time operational data for daily reporting?
Data Mart
ODS
Data Lake
Archive Storage
Which storage system handles raw, semi-structured, and unstructured data like logs and images?
Data Mart
ODS
Data Warehouse
Data Lake
Which of the following is MOST suitable for machine learning and big data analytics?
Data Lake
ODS
Data Mart
OLTP System
Which cloud service is Amazon’s SQL-based data warehouse?
Azure Synapse Analytics
AWS Redshift
Google BigQuery
Snowflake
Which cloud warehouse integrates closely with Amazon S3 and AWS Glue?
Azure Synapse Analytics
AWS Redshift
Azure SQL
MongoDB Atlas
A retail company loading daily sales data and building QuickSight dashboards is an example of using:
BigQuery
AWS Redshift
Azure Synapse Analytics
Azure SQL Database
Which cloud warehouse is both a data warehouse and a big data analytics platform?
AWS Redshift
Azure Synapse Analytics
AWS RDS
Amazon Neptune
Which system integrates directly with Microsoft Power BI for analytics?
AWS Redshift
Azure Synapse Analytics
Amazon DynamoDB
MySQL Cloud
A company combining SQL customer data with IoT sensor data from a data lake is most likely using:
AWS Redshift
Azure Synapse Analytics
PostgreSQL
MariaDB
Which system is known for its very fast query engine on AWS?
Azure Synapse Analytics
AWS Redshift
Amazon Aurora
SQL Server
Which platform can process both structured data and big data in a single system?
AWS Redshift
Azure Synapse Analytics
Oracle Cloud DB
Firebase
A framework that consists of policies, roles, responsibilities, standards, and processes to ensure organizational data is accurate, consistent, secure, and properly used.
Data Privacy
Data Governance
Data Integrity
Data Warehouse
Which principle of RA 10173 ensures organizations inform individuals about why their data is collected and who will access it?
Legitimate Purpose
Transparency
Proportionality
Accountability
Collecting a student’s medical certificate for health clearance exemplifies which principle?
Transparency
Legitimate Purpose
Proportionality
Confidentiality
A delivery service requests only a customer’s name, address, and phone number, but not marital status. This demonstrates:
Transparency
Legitimate Purpose
Proportionality
Data Portability
Which of the following is a Sensitive Personal Information (SPI)?
Name
Phone Number
Religion
Which right allows an individual to request deletion of their data if collected unlawfully?
Right to Access
Right to Object
Right to Erasure or Blocking
Right to Rectification
A bank informing customers before sending their data to a credit bureau reflects which data subject right?
Right to Object
Right to Be Informed
Right to Data Portability
Right to File Complaint
What ethical issue arises if an AI loan approval system discriminates against applicants from certain areas?
Exploitation of Data
Surveillance
Bias in Data and Algorithms
Informed Consent
Which ethical principle is violated if a mobile app forces users to accept unnecessary data collection?
Bias
Informed Consent
Surveillance
Exploitation
An HR employee accidentally emailing a spreadsheet with salaries is an example of:
Malicious Insider
Negligent Insider
Compromised Insider
External Threat
Phishing attacks are classified as:
Insider Threats
External Threats
Physical Threats
Logical Threats
Combining a password, OTP, and fingerprint to access a banking app is an example of:
Single-factor Authentication
Biometric Authentication
Multi-factor Authentication (MFA)
Role-Based Access
Which security measure records all user activities for compliance and investigations?
Encryption
Tokenization
Audit Trails
Access Control
Which type of encryption protects data while being transmitted over the internet?
Data-at-Rest Encryption
Data-in-Transit Encryption
Storing old bank transaction logs for 7 years for auditing represents:
Secure Storage
Archival
Secure Disposal
Data Breach Response
A hospital hires an IT company to maintain patient records. Who is responsible for enforcing policies on patient data?
IT Company (PIP)
Hospital (PIC)
National Privacy Commission
Patients
A customer refuses marketing emails from a company. Which right are they exercising?
Right to Object
Right to Access
Right to Erasure
Right to Rectification
An employee downloads confidential customer data to sell online. Which type of threat is this?
Compromised Insider
Malicious Insider
Negligent Insider
External Hacker
A student requests a copy of their school records. This exemplifies which data subject right?
Right to Access
Right to Erasure
Right to Object
Right to File Complaint
A mobile app states: "We collect your name and phone number to create your account and contact you." This demonstrates:
Proportionality
Transparency
Legitimate Purpose
Data Minimization
An HR manager can view payroll, but staff cannot. Which principle is being applied?
Transparency
Role-Based Access Control
Data Portability
Proportionality
A mobile app asks for unnecessary access to contacts and photos without clear explanation. Which principle and ethical issue are being violated?
Transparency and Exploitation of Data
Proportionality and Informed Consent
Legitimate Purpose and Bias
Transparency and Bias
