Assessment Requirements for ICTDBS402 Complete database backup and restore

Release: 1

Assessment Requirements for ICTDBS402 Complete database backup and restore

Modification History

Release	Comments
Release 1	This version first released with ICT Information and Communications Technology Training Package Version 1.0.

Performance Evidence

Evidence of the ability to:

determine and prepare the appropriate methods for backup, maintenance and recovery, including a contingency plan

implement the backup and restore procedures, with minimum disruption to the business

create, implement and document a standby database.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

explain the basic principles of:

diagnostic tools

structured query language (SQL)

databases

tuning methodologies

outline and apply the principles of:

backup and recovery methods

database administration

database security

open file backup procedures and restore operations.

Assessment Conditions

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the database field of work, and include access to:

equipment and materials

documentation standards

backup and recovery policies

sites with a representative range of current industry standard software and diagnostic tools

database package with data

technical records

organisational guidelines

vendor documentation

the server, and a networked personal computer, on which to conduct the backup and restore procedures.

Assessors must satisfy NVR/AQTF assessor requirements.

Links

Companion volumes available from the IBSA website: http://www.ibsa.org.au/companion_volumes - https://vetnet.education.gov.au/Pages/TrainingDocs.aspx?q=a53af4e4-b400-484e-b778-71c9e9d6aff2