PowerSchool Aptitude Test Data Management 4 — Questions and Answers
Question 1: A district migrates from a legacy SIS to PowerSchool. During data validation, some student birthdates imported as '00/00/0000'. What is the best corrective action?
- Leave them blank; PowerSchool accepts null birthdates
- Run a mass update SQL script to set them to NULL
- Identify and manually correct each record using the student search
- Re-import with a corrected file after fixing source data (Correct answer)
Correct answer: Re-import with a corrected file after fixing source data
The safest corrective action is to fix the source data and re-import using the Data Import Manager to maintain an audit trail.
Question 2: Which PowerSchool feature allows administrators to define which data fields are visible and editable for different staff roles?
- Security Groups
- Field Level Security (Correct answer)
- Data Access Tags (DAT)
- School Security Permissions
Correct answer: Field Level Security
Field Level Security in PowerSchool controls which database fields each security group can view or edit.
Question 3: When exporting a Quick Export from PowerSchool, which delimiter is most commonly used to ensure compatibility with Excel?
- Pipe (|)
- Comma (,) (Correct answer)
- Tab (\t)
- Semicolon (;)
Correct answer: Comma (,)
Comma-separated values (CSV) is the most universally compatible format and the default for most PowerSchool Quick Exports.
Question 4: A student transfers from School A to School B within the same district. After the transfer, where does PowerSchool store the student's enrollment history at School A?
- In a separate archive database
- In the [ReEnrollments] table (Correct answer)
- In the [StoredGrades] table only
- Records at School A are deleted upon transfer
Correct answer: In the [ReEnrollments] table
PowerSchool stores historical enrollment records in the [ReEnrollments] table, preserving the student's prior school history.
Question 5: What does 'NCLB ethnicity' consolidation mean in the context of PowerSchool demographic data?
- Combining race codes into a single state-reportable ethnicity value
- Removing non-US ethnicity codes from the database
- Applying federal No Child Left Behind race/ethnicity categories for reporting (Correct answer)
- Encrypting ethnicity data for privacy compliance
Correct answer: Applying federal No Child Left Behind race/ethnicity categories for reporting
NCLB ethnicity consolidation maps PowerSchool's multi-select race/ethnicity fields to the federal reporting categories required by No Child Left Behind.
Question 6: Which approach correctly retrieves the current school year's start date in a PowerSchool report using [terms] table data?
- Filter where yearid = current_year and portion = 1
- Filter where name = 'Year' and firstday <= today and lastday >= today (Correct answer)
- Filter where portion = 1 and schoolid = 0
- Filter where yearid = 0 and name = 'FY'
Correct answer: Filter where name = 'Year' and firstday <= today and lastday >= today
Filtering the [terms] table by name='Year' and date range straddling today reliably returns the current year term record.
Question 7: A data manager notices that two students share the same state student ID. What is the recommended first step?
- Delete one of the duplicate records immediately
- Assign a new state ID to the newer record automatically via PowerSchool
- Investigate both records to determine which student the ID belongs to before making changes (Correct answer)
- Report the error to the state agency and await instruction
Correct answer: Investigate both records to determine which student the ID belongs to before making changes
Investigating first prevents accidental deletion of legitimate records; the correct student must be identified before any changes are made.
PowerSchool Aptitude Test Data Management 4
A district migrates from a legacy SIS to PowerSchool.
During data validation, some student birthdates imported as '00/00/0000'.
What is the best corrective action?