NTISthis.com

Evidence Guide: ICTDBS407 - Monitor physical database implementation

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTDBS407 - Monitor physical database implementation

What evidence can you provide to prove your understanding of each of the following citeria?

Undertake database

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

management system modelling

  1. Review the database prototype as appropriate, to determine the acceptance criteria and performance standards
  2. Load the test data according to the technical sequence detailed in the relevant documentation
  3. Generate a test schedule for the database, of tasks to be performed and the results expected
Review the database prototype as appropriate, to determine the acceptance criteria and performance standards

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Load the test data according to the technical sequence detailed in the relevant documentation

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Generate a test schedule for the database, of tasks to be performed and the results expected

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Monitor database performance

  1. Evaluate database performance against the acceptance criteria and performance standards
  2. Identify discrepancies in the results, when the expected outcomes do not meet the acceptance criteria
  3. Identify areas needing enhancement, and document the changes to be made
  4. Modify the database according to project standards
  5. Repeat performance testing until the expected results are achieved
Evaluate database performance against the acceptance criteria and performance standards

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Identify discrepancies in the results, when the expected outcomes do not meet the acceptance criteria

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Identify areas needing enhancement, and document the changes to be made

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Modify the database according to project standards

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Repeat performance testing until the expected results are achieved

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Seek client feedback and sign-off

  1. Present test results in a document, and provide to the client for feedback
  2. Incorporate client change requests as appropriate
  3. Obtain client sign-off to the monitoring process
Present test results in a document, and provide to the client for feedback

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Incorporate client change requests as appropriate

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Obtain client sign-off to the monitoring process

Completed
Date:

Teacher:
Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Undertake database

management system modelling

1.1 Review the database prototype as appropriate, to determine the acceptance criteria and performance standards

1.2 Load the test data according to the technical sequence detailed in the relevant documentation

1.3 Generate a test schedule for the database, of tasks to be performed and the results expected

2. Monitor database performance

2.1 Evaluate database performance against the acceptance criteria and performance standards

2.2 Identify discrepancies in the results, when the expected outcomes do not meet the acceptance criteria

2.3 Identify areas needing enhancement, and document the changes to be made

2.4 Modify the database according to project standards

2.5 Repeat performance testing until the expected results are achieved

3. Seek client feedback and sign-off

3.1 Present test results in a document, and provide to the client for feedback

3.2 Incorporate client change requests as appropriate

3.3 Obtain client sign-off to the monitoring process

Required Skills and Knowledge

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Undertake database

management system modelling

1.1 Review the database prototype as appropriate, to determine the acceptance criteria and performance standards

1.2 Load the test data according to the technical sequence detailed in the relevant documentation

1.3 Generate a test schedule for the database, of tasks to be performed and the results expected

2. Monitor database performance

2.1 Evaluate database performance against the acceptance criteria and performance standards

2.2 Identify discrepancies in the results, when the expected outcomes do not meet the acceptance criteria

2.3 Identify areas needing enhancement, and document the changes to be made

2.4 Modify the database according to project standards

2.5 Repeat performance testing until the expected results are achieved

3. Seek client feedback and sign-off

3.1 Present test results in a document, and provide to the client for feedback

3.2 Incorporate client change requests as appropriate

3.3 Obtain client sign-off to the monitoring process

Evidence of the ability to:

identify technical considerations affecting the implementation of a database

analyse and monitor performance issues during the implementation of a database

modify a database to meet project and client performance requirements.

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

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

describe the client business domain

list current industry-accepted hardware and software products

describe requirements of basic database design

identify required database performance standards

outline quality assurance practices

outline testing and benchmarking processes

list three or more current principles of databases.