Font size
Worksheetsrevision paper 3
Total questions: 115
Worksheet time: 57mins
Big data is the massive amount of rapidly moving and freely ..................
Available data
Unavailable data
Structured Data
Unstructured Data
What is NOT a characteristic of big data?
Volume
Variety
Vision
Velocity
What is the true definition of big data
huge amount of space
large, diverse sets of information
unlimited speed data internet connection
small, undiverse sets of information
Variety is a characteristic of big data. Which type of formats does Variety comes from?
Structured
Unstructured
Semi-structured
All of the above
What does Velocity refers to?
processing speed of a data
speed of an internet
the volume to the city
Variety comes from structured or unstructured format. What is the difference between them?
Handwritten / Computer-typed
Numerical format / Natural Language
Clean / Dirty
Subjective / Objective
Which of the following would NOT use big data analysis?
Healthcare companies
Public agencies
Retail companies
High school students doing homework
How does the app above counts as a big data?
It stores their user healthcare data
It helps people find a date with their data
It stores videos that is uploaded by their user
It helps stores people's fat
Volume is one of the characteristics of big data. What does Volume refers to?
The amount of water in a glass bottle
The amount of money
The amount of love given
The amount of Youtube videos that existed
The amount of data
What is the advantages on using big data in education in real life?
A: Cost reduction
B: Higher risk
C: Effective learning
D: A and B only
E: A and C only
Big Data is significant because of all of the following except it___________________.
helps us in identifying trends in data
allows us to determine how much data a database can store
can be used to make connections in data
helps us solve questions we might have
What are the four V's that best define Big Data?
Vacant - Victini - Volume-Validity
Volume - Velocity - Variety- Veracity
Validity - Velocity - Veracity- Volume
Varsity - Velocity - Volume- Validity
Spreadsheets and databases are examples of software tools that allow us to process Big Data.
True
False
Height, age, speed, length are all examples of this type of data:
Exploratory
Qualitative
Quantitative
Subjective
What does SaaS mean?
Software as a Service
Software as a Solution
Software as a System
Software as a Secret
What would Amazon/Lazada/Shopee use Big Data for?
To store customer details
To analyse buying trends and recommend future purchases
To store payment details
To predict future company earnings
Biologists often attach tracking collars to wild animals. For each animal, the following geolocation data is collected at frequent intervals.
- time
- date
- location of the animal
Which of the following questions about a particular animal could NOT be answered using only the data collected from the tracking collars?
Approximately how many miles did the animal travel in one week?
Do the movement patterns of the animal vary according to the weather?
In what geographic locations does the animal typically travel?
Does the animal travel in groups with other tracked animals?
Big Data is significant because of all of the following except it___________________.
helps us in identifying trends in data
allows us to determine how much data a database can store
can be used to make connections in data
helps us solve questions we might have
What is one of the main characteristics of Big Data processing
Centralized data processing
Centralized storage of data in a Data Warehouse
Distributed collection and computing of data
Collection of information through highly optimized computer systems
What do companies collect that can identify you on the internet?
consumer
cookies
privacy policy
personal information
What is the tiny piece of data that allows google to remember our password?
identity theft
cookie
personal information
privacy policy
What does this padlock sign mean in the address bar of your browser?
The site is secure and data is transmitted using SSL
There is a padlock available for purchase
The website does not include "safety locks"
The page is locked down for some odd reason
What does SSL stand for?
Secure Socket Layer
Secret Secure Layer
Taking a secret message and reproducing the original plain text is known as?
Caesar Cipher
Encryption
Cipher Text
Decryption
Asymmetric encryption uses only 1 key.
True
False
Maybe
God Knows
The process of converting plaintext to ciphertext.
cryptography
cyphertext
decryption
encryption
A string of text that has been converted to a secure form using encryption.
encryption
decryption
ciphertext
plaintext
The process of converting a ciphertext into plaintext.
encryption
decryption
plaintext
cryptography
How many stages are in the project lifecycle?
1
2
3
4
What is the first stage of the project lifecycle?
Planning
Execution
Initiation
Evaluation
Briefly what happens in the initiation phase?
Knowing what you want to achieve and how to achieve it
Finding out what the project is about
Physically completing the product/project/task
Reviewing the finalised project
I will save alot of money by my 16th birthday
NOT a SMART goal
SMART goal
I will score 15 soccer goals this season
SMART goal
NOT a SMART goal
What is the main purpose of Natural Language Processing?
Helping the machine to understand human language
Let machine understand the human mind
Guide human to process the language naturally
Allow human to interpret machine language easily
Normalisation is:
Removing all necessary data from a database
Organising a database to remove repeated entries and increase the accuracy of the data
Putting fields from different tables into one big database
Which of the following statements fully describes data in 2NF:
When any repeating fields have been removed and the table is given a primary key
When all repeating entries of data are removed and the fields in each table are directly related to the primary key and no fields are present that are not related to each other
When all the fields in each table are directly related to the primary key
An advantage of normalisation is:
The storage space needed for a normalised database is likely to be smaller
The process of normalising a database is very easy and doesn’t require any skill
It is possible to see previous details that have been changed, such as a customer’s address, as we can look back at an older entry
What is an atomic field?
A field that contains multiple items of data
A field that is repeated
A field that contains only one item of data
What is a foreign key?
A unique identifier in a database
A primary key of one table that appears in another table
A field that should not be in a table and needs removing
A relation is in 1NF if it doesn't contain any ____________?
Determinants
Repeating groups
Null values in primary key fields
Functional dependencies
When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?
Remove any functional dependencies from both relations
Assign both relations the same primary key field(s)
Create a primary key(s) for the new relation
Tables in ____ will perform suitably in business transactional databases.
0NF
1NF
2NF
3NF
When is a table is said to be 3NF
Normalization improves performance by reducing redundancy.
If and only if it is in 2NF and every non key attribute is Non-transitively dependent on the primary key
It involves introduction of redundancy in data
None of the above
1.Which of the following is TRUE about normalisation?
It is the process of dividing larger tables into smaller interlinked tables.
Increases data redundancy.
It is the process of dividing larger tables into smaller independent tables.
It is the process of removing duplicate entries in a table.
What type of entity relationships always require a link table?
One-to-one
One-to-many
Many-to-many
Which of the following is the main motive of normalisation?
Join many smaller tables
Reduce data redundancy while merging smaller tables
Creating a larger table with all entities
None of the above
What is Agile ?
Airbus Great Initiative to Leverage Enhancements
Agile is a sprint approach method
Agile is new process and methodology
Agile is set of Values and Principles
What is the top benefit of adopting Agile ?
Cost reduction
Team Morale
Ability to change priorities
Breaking Silos
Agile methods are
Phase gate approaches
Iterative and incremental approaches
Incremental development approaches
Iterative development approaches
I want to develop a software that requires a lot of documentation. What approach should I use?
Waterfall method
SCRUM
Agile
All of the above
The waterfall method is......
pouring water on your keyboard and hoping it makes software
a linear approach to software development
a way to develop software quickly
unorganized
Select words which can be used to describe the waterfall method. [2 Words Max]
Rigid
Dynamic
Thorough
Fluid
Partial
Agile Software Development is based on
Incremental Development
Iterative Development
Linear Development
Both Incremental and Iterative Development
A linear approach to software development is called?
Linear Strait Method
Waterfall method
Scream method
Downpour method
My watch displays the current weather downloaded from the internet. My watch is an IOT device.
True
False
Which of the following could be an IOT device?
A Lamp
A Couch
A Pen
All of the Above
The following trend is NOT related to the growth in IOT technology
Increase in computer monitor size over time
Increase in computer performance over time
Decrease in computer size over time
Decrease in computer cost over time
Which of these security approaches is feasible for most IOT devices?
Use of antivirus software
Use of internal firewall
Regular installation of product firmware updates
Complete separation of the device from the internet
IOT devices gather private information about users. Which statement is most true about the security of that data?
User can ensure security of collected data by encrypting it manually
Users must rely on data collecting agencies to securely store and transmit their data
User can sue data collecting agencies if their data is not held securely
Most data gathered by IOT devices is safe because IOT devices are not a target of hackers
Although people are aware of the dangers of cyber attack, they often do not understand the risks to IOT device
True
False
_______ are devices that detect and respond to changes in an environment. They’re embedded in smart phones and an integral part of the Internet of Things (IoT).
ZigBee
Wi-Fi
Barcode
RFID
Sensors
True
False
One difference between system flowcharts and data flow diagrams is that system flowcharts show conditional logic whereas DFDs don't.
True
False
This is the symbol for
External entitles
Processes
Data stores
Data flows
This is the symbol for
External entitles
Processes
Data stores
Data flows
This is the symbol for
External entitles
Processes
Data stores
Data flows
The process symbol is used to represent
Customers queries in process
Shipping of goods in process
Manual or computer-driven process that changes data
Sales negotiation in process
What is the external entity used for?
To show all the external works taking place outside the organisation
To represent source or destination of data that is external to the system
To represent all employees who work out on the field
To represent private event held
An individual virtual machine; also called an application cell.
deep web
container
onion network
virus
Looks and functions like an actual Computer Operating System (COS), but is separated from the operating system running on the machine.
application cell
host operating system
hypervisor
virtual machine
In virtualization, the operating system that hosts the virtual operating systems.
virtual machine (VM)
Virtual machine (VM) sprawl
hypervisor
host operating system
Software that runs on a physical computer and manages one or more virtual machine operating systems.
snapshot
sandbox
hypervisor
provisioning
A virtual environment running programs and processes from the main computer system to provide an isolated place to test and deploy applications and configurations - a safe zone for investigating and finding issues in systems.
virtual machine escape
sandbox
application cell
hypervisor
