Grade 12 Theory IV — Data Protection, Warehousing & Mining

Question 1

Keeping a detailed log of every change made to important data, including who made it and when, is called:

Question 2

Storing a duplicate copy of critical data on a completely separate system, so operations can continue if the main system fails, describes:

Question 3

A malicious technique where an attacker inserts crafted SQL code into an input field to manipulate or extract data from a database is called:

Question 4

Which of these is a genuine safeguard against SQL injection attacks?

Question 5

A large, centralised repository built specifically to store data collected from MANY different sources for later analysis is called a:

Question 6

The process of analysing large volumes of stored data to discover hidden patterns and useful knowledge is called:

Question 7

Using RFID (Radio Frequency Identification) tags to automatically track items — e.g. stock in a warehouse — is an example of:

Question 8

Data collected without the person directly realising it's being captured — e.g. via a loyalty card or toll road pass — is described as:

Question 9

Which of these best describes the relationship between data warehousing and data mining?

Question 10

Which of these is a role/responsibility typically associated with a Database Administrator (DBA)?

Question 11

Controlling exactly which users may access which parts of a database, and what they're allowed to do there, is an example of protecting data through:

Question 12

Which of these best explains why 'the value of data' is emphasised when discussing data protection?

Question 13 — Match the columns

Match each data protection term in Column A to its description in Column B.

Question 14 — Match the columns

Match each data collection example in Column A to its description in Column B.

Question 15

Confirming that captured data accurately matches its original source document — e.g. proofreading typed data against a paper form — is called:

Question 16

Deliberately feeding a database false or invalid data to corrupt its accuracy is best described as:

Question 17

Data collected specifically from a device's GPS position or nearby cell towers is an example of:

Question 18

Using patterns discovered through data mining to directly inform an organisation's future decisions is an example of:

Question 19

Which of these is a typical responsibility of a PROGRAMMER, as distinct from a DBA, in database systems development?

Question 20

Which best reflects how organisations actually protect their data, according to the syllabus?