WPC 300 MAIN EXAMINATION MANUAL 2026/2027
QUESTIONS AND SOLUTIONS RATED A+
✔✔The Relational Database - ✔✔- A series of tables with logical
associations between them
- The associations (relationships) allow
the data to be combined
- Entity
- Primary Key
- Foreign Key
- What does a row in a table mean?
- Why does primary key need to be
unique?
✔✔SQL SELECT statement - ✔✔SELECT column_name(s)
FROM table_name
WHERE condition*
GROUP BY column_name
ORDER BY column_name DESC/ASC
- *condition: column_name =, <>, >, >=, <, <= 'a value' or a
number (need ' ' for test value, not numbers like 123)
- Understand all the Keywords: DISTINCT, COUNT, MAX, MIN,
AVG, SUM
✔✔Typical IT infrastrcuture - ✔✔Data sources
- Operational systems
- Flat files
↓
Staging Area
↓
Warehouse
- summary data
- metadata
- raw data
↓
Data Marts
- Purchasing
- Sales
, - inventory
↓
Users
- analytics
- reporting
- mining
✔✔Cloud Computing - ✔✔Types: public, private, and hybrid
- Types of cloud services:
--- Infrastructure as a service (IaaS)
--- Platform as a service (PaaS)
--- Serverless computing
--- Software as a service (SaaS)
• Drawback: concerns of security, reliability
✔✔IaaS (Infrastructure as a Service) - ✔✔rent IT infrastructure—servers and virtual
machines (VMs), storage, networks, operating systems—from a cloud provider on a pay
as you-go basis
✔✔PaaS (Platform as a Service) - ✔✔PaaS includes infrastructure but also middleware,
development tools, business intelligence (BI) services, database management systems,
and more. PaaS is designed to support the complete web application lifecycle: building,
testing, deploying, managing, and updating.
✔✔Serverless computing - ✔✔The cloud provider handles the setup, capacity planning,
and
server management for you.
✔✔SaaS (Software as a Service) - ✔✔Pay for software as you use it. Not installed
locally, instead it is 'Hosted software e.g. Google Docs
✔✔4Vs of Big Data - ✔✔• Volume
• Velocity
• Variety - different forms of
data
• Veracity - uncertainty of
data
✔✔experiment - ✔✔A research method in which an investigator manipulates one or
more factors to observe the effect on some behavior or mental process
QUESTIONS AND SOLUTIONS RATED A+
✔✔The Relational Database - ✔✔- A series of tables with logical
associations between them
- The associations (relationships) allow
the data to be combined
- Entity
- Primary Key
- Foreign Key
- What does a row in a table mean?
- Why does primary key need to be
unique?
✔✔SQL SELECT statement - ✔✔SELECT column_name(s)
FROM table_name
WHERE condition*
GROUP BY column_name
ORDER BY column_name DESC/ASC
- *condition: column_name =, <>, >, >=, <, <= 'a value' or a
number (need ' ' for test value, not numbers like 123)
- Understand all the Keywords: DISTINCT, COUNT, MAX, MIN,
AVG, SUM
✔✔Typical IT infrastrcuture - ✔✔Data sources
- Operational systems
- Flat files
↓
Staging Area
↓
Warehouse
- summary data
- metadata
- raw data
↓
Data Marts
- Purchasing
- Sales
, - inventory
↓
Users
- analytics
- reporting
- mining
✔✔Cloud Computing - ✔✔Types: public, private, and hybrid
- Types of cloud services:
--- Infrastructure as a service (IaaS)
--- Platform as a service (PaaS)
--- Serverless computing
--- Software as a service (SaaS)
• Drawback: concerns of security, reliability
✔✔IaaS (Infrastructure as a Service) - ✔✔rent IT infrastructure—servers and virtual
machines (VMs), storage, networks, operating systems—from a cloud provider on a pay
as you-go basis
✔✔PaaS (Platform as a Service) - ✔✔PaaS includes infrastructure but also middleware,
development tools, business intelligence (BI) services, database management systems,
and more. PaaS is designed to support the complete web application lifecycle: building,
testing, deploying, managing, and updating.
✔✔Serverless computing - ✔✔The cloud provider handles the setup, capacity planning,
and
server management for you.
✔✔SaaS (Software as a Service) - ✔✔Pay for software as you use it. Not installed
locally, instead it is 'Hosted software e.g. Google Docs
✔✔4Vs of Big Data - ✔✔• Volume
• Velocity
• Variety - different forms of
data
• Veracity - uncertainty of
data
✔✔experiment - ✔✔A research method in which an investigator manipulates one or
more factors to observe the effect on some behavior or mental process
