WPC 300 CORE EXAM SET 2026/2027 QUESTIONS AND
SOLUTIONS RATED A+
✔✔Survey -- The Code of Ethics - ✔✔• Respondents should be given the content,
sponsorship (who is
conducting the survey), and purpose of the survey so that they
may make an informed judgement about whether they wish to
participate.
• Avoid use of methods that deliberately introduce bias into the
results.
Note - We should include a paragraph to explain who is conducting
the survey, the content, and purpose of the survey
✔✔Survey Biases - ✔✔• Online Survey Selection Biases
• Question order biases
• Imbalance sampling
• Prevent using leading and biased questions, but use neutral
wording. Do not include your opinion in the question.
• Don't overloaded your question. Always break questions into
singles so your survey is measurable.
• Don't ask the wrong questions
• Don't survey the wrong people.
Note - It is always a good practice to revise survey questions and to target a population
that fits the survey's goal by clearly defining the respondent requirements so we can
prevent survey biases from happening
✔✔The Transactional Database - ✔✔- In business, a transaction is the exchange of
information, goods, or services
- For databases, a transaction is an action performed in a database management
system
- Operational databases deal with both: they store information about business
transactions using database transactions
Ex of Transactions
- purchase of product
- enroll in a course
- hire an employee
Data is in REAL TIME
- reflects current state
- how things are NOW
, ✔✔Two types of data - ✔✔transactional and analytical
✔✔transactional - ✔✔• Captures data describing and event
• An exchange between actors
• Real-time
✔✔Analytical (Data Warehouse) - ✔✔• Captures data to support analysis and reporting
• An aggregated view of the business
• Historical
✔✔The Information Architecture of an Organization - ✔✔Data entry →
Transactional Database (stores real time transactional data) →
Data extraction →
Analytical Data Store (stores historical transactional and summary data) →
Data Analysis
✔✔Transactional Database - ✔✔- Supports management of an organization's data
- For everyday transactions
This is what is commonly thought of as "database management"
✔✔Analytical Data Warehouse - ✔✔- Supports managerial decision-making
- For periodic analysis
This is the foundation for business intelligence
✔✔Entity data relationship model - ✔✔Entities → Attributes → Identifier
✔✔entities - ✔✔- something users want to track
- flights, traveler, reservation
✔✔attributes - ✔✔- describe characteristics of an entity
- FlightNo, From, To, Departs, Arrives
SOLUTIONS RATED A+
✔✔Survey -- The Code of Ethics - ✔✔• Respondents should be given the content,
sponsorship (who is
conducting the survey), and purpose of the survey so that they
may make an informed judgement about whether they wish to
participate.
• Avoid use of methods that deliberately introduce bias into the
results.
Note - We should include a paragraph to explain who is conducting
the survey, the content, and purpose of the survey
✔✔Survey Biases - ✔✔• Online Survey Selection Biases
• Question order biases
• Imbalance sampling
• Prevent using leading and biased questions, but use neutral
wording. Do not include your opinion in the question.
• Don't overloaded your question. Always break questions into
singles so your survey is measurable.
• Don't ask the wrong questions
• Don't survey the wrong people.
Note - It is always a good practice to revise survey questions and to target a population
that fits the survey's goal by clearly defining the respondent requirements so we can
prevent survey biases from happening
✔✔The Transactional Database - ✔✔- In business, a transaction is the exchange of
information, goods, or services
- For databases, a transaction is an action performed in a database management
system
- Operational databases deal with both: they store information about business
transactions using database transactions
Ex of Transactions
- purchase of product
- enroll in a course
- hire an employee
Data is in REAL TIME
- reflects current state
- how things are NOW
, ✔✔Two types of data - ✔✔transactional and analytical
✔✔transactional - ✔✔• Captures data describing and event
• An exchange between actors
• Real-time
✔✔Analytical (Data Warehouse) - ✔✔• Captures data to support analysis and reporting
• An aggregated view of the business
• Historical
✔✔The Information Architecture of an Organization - ✔✔Data entry →
Transactional Database (stores real time transactional data) →
Data extraction →
Analytical Data Store (stores historical transactional and summary data) →
Data Analysis
✔✔Transactional Database - ✔✔- Supports management of an organization's data
- For everyday transactions
This is what is commonly thought of as "database management"
✔✔Analytical Data Warehouse - ✔✔- Supports managerial decision-making
- For periodic analysis
This is the foundation for business intelligence
✔✔Entity data relationship model - ✔✔Entities → Attributes → Identifier
✔✔entities - ✔✔- something users want to track
- flights, traveler, reservation
✔✔attributes - ✔✔- describe characteristics of an entity
- FlightNo, From, To, Departs, Arrives
