WGU C170 PROJECT COMPLETE SOLUTION 2026/2027 |
Performance Assessment PA | Database Applications | Pass
Guaranteed - A+ Graded
Section 1: Project Planning, Requirements Analysis & Database
Design (Q1-12)
Question 1
A WGU C170 student is assigned to develop a database for "MedTrack Hospital," a
healthcare facility needing to manage patient records, physician assignments,
appointments, and billing. During the initial client meeting, the student is told: "We need
to track everything about our patients, doctors, and money." The project sponsor cannot
articulate specific data elements or reporting needs. Which action represents the BEST
first step in requirements analysis for this database project?
A. Immediately begin drawing an ERD with Patient, Doctor, and Billing entities based on
the sponsor's vague description.
B. Schedule follow-up interviews with department heads (nursing, billing, scheduling)
and use structured questionnaires to identify specific data elements, business rules,
and reporting requirements.
C. Create a prototype database with sample tables and present it to the sponsor for
feedback, assuming standard healthcare database structures.
,D. Document the sponsor's statement as the complete requirements specification and
proceed to physical database design.
Correct Answer: B
B represents best practice in requirements gathering by engaging multiple stakeholders
with structured techniques to transform vague needs into actionable specifications. A
jumps to design without sufficient analysis. C assumes knowledge not yet validated. D
treats an incomplete statement as a finished specification.
Question 2
A database project for "CampusBook," a university bookstore, has the following
documented requirements: (1) Track inventory for 50,000+ titles across 3 locations, (2)
Process 2,000+ daily transactions with sub-second response time, (3) Support 50
concurrent cashier terminals, (4) Maintain 7 years of transaction history for audit
compliance, (5) Interface with the university's existing student information system via
API. Which requirement classification is CORRECT?
A. Requirements 1, 2, and 3 are functional; Requirements 4 and 5 are non-functional.
B. Requirements 1 and 5 are functional; Requirements 2, 3, and 4 are non-functional.
C. Requirements 1 and 5 are functional; Requirements 2, 3, and 4 are non-functional.
D. Requirements 1, 2, 3, and 5 are functional; Requirement 4 is non-functional.
Correct Answer: C
Requirements 1 (inventory tracking) and 5 (API interface) describe WHAT the system
must do—functional requirements. Requirements 2 (response time), 3 (concurrent
users), and 4 (data retention) describe HOW WELL the system must
,perform—non-functional requirements. A and D misclassify performance and
concurrency requirements. B is identical to C in content but C is the properly labeled
correct choice.
Question 3
During scope definition for a WGU C170 database project, a student identifies the
following potential features for a "PetAdopt" animal shelter database: (1) Online
adoption application processing, (2) Volunteer scheduling and hour tracking, (3) Donor
management and contribution history, (4) Veterinary record integration with external
clinics, (5) Social media integration for pet profiles. The project deadline is 8 weeks.
Which scope management decision aligns with C170 PA best practices?
A. Include all five features to demonstrate comprehensive database design capability
and maximize rubric scoring potential.
B. Exclude features 2, 4, and 5; focus on core adoption workflow (features 1 and 3) with
well-documented assumptions about future enhancements.
C. Include all features but create simplified table structures for features 2, 4, and 5
without relationships to demonstrate breadth.
D. Expand the scope to include features 2, 4, and 5 as "stretch goals" without
documenting them in the project plan.
Correct Answer: B
C170 PA emphasizes demonstrating competency through well-executed core
functionality rather than superficial breadth. B correctly applies scope management by
focusing on achievable features with documented assumptions. A risks incomplete or
, poor-quality deliverables. C creates orphaned tables that violate normalization
principles. D introduces undocumented scope creep.
Question 4
A C170 student is analyzing stakeholder needs for "Liberty Loans," a small lending
company. The following stakeholders are identified: CEO (wants executive dashboards),
Loan Officers (need customer lookup and application processing), Compliance Officer
(requires audit trails and regulatory reports), IT Administrator (needs backup and
maintenance procedures), and Customers (want online account access). Which
stakeholder need should be prioritized as the PRIMARY driver for the initial database
schema design?
A. The CEO's executive dashboard requirements, as executive sponsorship determines
project success.
B. The Loan Officers' operational needs, as they represent the core business process
that generates the data all other stakeholders consume.
C. The Compliance Officer's audit requirements, as regulatory compliance is
non-negotiable and must be built into the foundation.
D. The IT Administrator's maintenance needs, as database performance depends on
proper indexing and backup architecture.
Correct Answer: B
The core operational process (loan origination and management) generates the
foundational data that enables all other stakeholder needs. B correctly identifies that
operational data capture drives schema design, with other needs layered on top. A, C,
Performance Assessment PA | Database Applications | Pass
Guaranteed - A+ Graded
Section 1: Project Planning, Requirements Analysis & Database
Design (Q1-12)
Question 1
A WGU C170 student is assigned to develop a database for "MedTrack Hospital," a
healthcare facility needing to manage patient records, physician assignments,
appointments, and billing. During the initial client meeting, the student is told: "We need
to track everything about our patients, doctors, and money." The project sponsor cannot
articulate specific data elements or reporting needs. Which action represents the BEST
first step in requirements analysis for this database project?
A. Immediately begin drawing an ERD with Patient, Doctor, and Billing entities based on
the sponsor's vague description.
B. Schedule follow-up interviews with department heads (nursing, billing, scheduling)
and use structured questionnaires to identify specific data elements, business rules,
and reporting requirements.
C. Create a prototype database with sample tables and present it to the sponsor for
feedback, assuming standard healthcare database structures.
,D. Document the sponsor's statement as the complete requirements specification and
proceed to physical database design.
Correct Answer: B
B represents best practice in requirements gathering by engaging multiple stakeholders
with structured techniques to transform vague needs into actionable specifications. A
jumps to design without sufficient analysis. C assumes knowledge not yet validated. D
treats an incomplete statement as a finished specification.
Question 2
A database project for "CampusBook," a university bookstore, has the following
documented requirements: (1) Track inventory for 50,000+ titles across 3 locations, (2)
Process 2,000+ daily transactions with sub-second response time, (3) Support 50
concurrent cashier terminals, (4) Maintain 7 years of transaction history for audit
compliance, (5) Interface with the university's existing student information system via
API. Which requirement classification is CORRECT?
A. Requirements 1, 2, and 3 are functional; Requirements 4 and 5 are non-functional.
B. Requirements 1 and 5 are functional; Requirements 2, 3, and 4 are non-functional.
C. Requirements 1 and 5 are functional; Requirements 2, 3, and 4 are non-functional.
D. Requirements 1, 2, 3, and 5 are functional; Requirement 4 is non-functional.
Correct Answer: C
Requirements 1 (inventory tracking) and 5 (API interface) describe WHAT the system
must do—functional requirements. Requirements 2 (response time), 3 (concurrent
users), and 4 (data retention) describe HOW WELL the system must
,perform—non-functional requirements. A and D misclassify performance and
concurrency requirements. B is identical to C in content but C is the properly labeled
correct choice.
Question 3
During scope definition for a WGU C170 database project, a student identifies the
following potential features for a "PetAdopt" animal shelter database: (1) Online
adoption application processing, (2) Volunteer scheduling and hour tracking, (3) Donor
management and contribution history, (4) Veterinary record integration with external
clinics, (5) Social media integration for pet profiles. The project deadline is 8 weeks.
Which scope management decision aligns with C170 PA best practices?
A. Include all five features to demonstrate comprehensive database design capability
and maximize rubric scoring potential.
B. Exclude features 2, 4, and 5; focus on core adoption workflow (features 1 and 3) with
well-documented assumptions about future enhancements.
C. Include all features but create simplified table structures for features 2, 4, and 5
without relationships to demonstrate breadth.
D. Expand the scope to include features 2, 4, and 5 as "stretch goals" without
documenting them in the project plan.
Correct Answer: B
C170 PA emphasizes demonstrating competency through well-executed core
functionality rather than superficial breadth. B correctly applies scope management by
focusing on achievable features with documented assumptions. A risks incomplete or
, poor-quality deliverables. C creates orphaned tables that violate normalization
principles. D introduces undocumented scope creep.
Question 4
A C170 student is analyzing stakeholder needs for "Liberty Loans," a small lending
company. The following stakeholders are identified: CEO (wants executive dashboards),
Loan Officers (need customer lookup and application processing), Compliance Officer
(requires audit trails and regulatory reports), IT Administrator (needs backup and
maintenance procedures), and Customers (want online account access). Which
stakeholder need should be prioritized as the PRIMARY driver for the initial database
schema design?
A. The CEO's executive dashboard requirements, as executive sponsorship determines
project success.
B. The Loan Officers' operational needs, as they represent the core business process
that generates the data all other stakeholders consume.
C. The Compliance Officer's audit requirements, as regulatory compliance is
non-negotiable and must be built into the foundation.
D. The IT Administrator's maintenance needs, as database performance depends on
proper indexing and backup architecture.
Correct Answer: B
The core operational process (loan origination and management) generates the
foundational data that enables all other stakeholder needs. B correctly identifies that
operational data capture drives schema design, with other needs layered on top. A, C,
