In a data warehouse, what happens during the transform step of ETL?

Extracted data is cleaned and converted into a consistent format

Why does a relational database reduce the update anomalies that occur in a flat-file database?

Each fact is stored once and linked to other tables through keys

Under the Notifiable Data Breaches scheme, which body must be notified when an eligible data breach is likely to cause serious harm?

The Office of the Australian Information Commissioner

What is the central idea of Indigenous data sovereignty?

Aboriginal and Torres Strait Islander peoples govern data about them

Why is it very hard to change a record in an earlier block of a blockchain without the change being detected?

Each block holds the previous block's hash, so edits break the links

Why is a pre-ticked checkbox for marketing emails considered poor practice for informed consent?

Users may agree without making an active, informed choice

Which of these is a risk, rather than a benefit, of mining customer purchase records?

Revealing sensitive traits customers never chose to share

§-Quiz

← back to the guide

Data Science: HSC Enterprise Computing objective-response practice quiz

13 questions. Pick an answer and you'll see why right away. Options are shuffled each attempt, and the review at the end links each missed question to the dot point to revise.

A retailer's store sensors send readings continuously, and the readings must be processed within seconds to adjust stock displays. Which characteristic of big data does this mainly describe?
In a data warehouse, what happens during the transform step of ETL?
Customer satisfaction is recorded as 1 = poor, 2 = fair, 3 = good and 4 = excellent. What level of measurement is this?
Why does a relational database reduce the update anomalies that occur in a flat-file database?
Which of these variables is measured at the interval level?
Under the Notifiable Data Breaches scheme, which body must be notified when an eligible data breach is likely to cause serious harm?
What is the central idea of Indigenous data sovereignty?
Why is it very hard to change a record in an earlier block of a blockchain without the change being detected?
A fitness app records a user's location in the background while they run, without the user entering anything. How is this data collected?
A business wants to know what unit price would give a profit of exactly $50 000. Which spreadsheet tool finds this input value directly?
Why is a pre-ticked checkbox for marketing emails considered poor practice for informed consent?
Which of these is a risk, rather than a benefit, of mining customer purchase records?
A model is trained on past loan applications labelled repaid or defaulted so that it can predict whether new applicants will repay. What type of learning is this?