Data Analytics - Unit-1
Aa type of computer hardware
Ba programming language for analytics
Cthe models, policies and rules that define how data is collected, stored, arranged and used
Da chart used to display data
Correct Answer
the models, policies and rules that define how data is collected, stored, arranged and used
ATemperature readings from an IoT sensor
BA handwritten letter
CA printed invoice
DA scanned textbook
Correct Answer
Temperature readings from an IoT sensor
Alatitude, longitude and time stamps
Bonly text documents
Conly audio recordings
Donly email addresses
Correct Answer
latitude, longitude and time stamps
AImages and free text
BRows in a relational table
CA spreadsheet with fixed columns
DA table of student marks
Correct Answer
Images and free text
Aaudio files
Brows and columns of tables
Cvideo streams
Dfree-form documents
Correct Answer
rows and columns of tables
Aa missing column
Ba duplicate table
Can encrypted file
Drandom error or variance in a measured variable
Correct Answer
random error or variance in a measured variable
Aa value that is always zero
Ba duplicate record
Ca data point that differs significantly from the other observations
Da missing value
Correct Answer
a data point that differs significantly from the other observations
AEncryption
BCompilation
CImputation
DIndexing
Correct Answer
Imputation
Aa record has no value
Bdata is stored in a warehouse
Cthe same record appears more than once
Ddata is sorted
Correct Answer
the same record appears more than once
AAccuracy
BCompleteness
CColourfulness
DConsistency
Correct Answer
Colourfulness
Agrouping sorted values into bins and replacing them with bin means or boundaries
Bdeleting the entire dataset
Cencrypting the values
Dconverting numbers to text
Correct Answer
grouping sorted values into bins and replacing them with bin means or boundaries
Adeleting all old data
Bcreating charts
Cdetecting and correcting errors and inconsistencies in data
Ddesigning hardware
Correct Answer
detecting and correcting errors and inconsistencies in data
Asplitting one table into many files
Bremoving all duplicates only
Cprinting reports
Dcombining data from multiple sources into a unified view
Correct Answer
combining data from multiple sources into a unified view
AExtract, Transform, Load
BEvaluate, Test, Launch
CEncode, Transfer, Link
DEdit, Translate, Learn
Correct Answer
Extract, Transform, Load
Aa subject-oriented, integrated, time-variant, non-volatile collection of data
Ba small personal spreadsheet
Ca type of sensor
Da programming library
Correct Answer
a subject-oriented, integrated, time-variant, non-volatile collection of data
Aimage metadata
Bsignal data
Crelational data
Da data dictionary
Correct Answer
signal data
ANormalization
BBackup
CPrinting
DFormatting a disk
Correct Answer
Normalization
A-1 to -100
B0 to 1000
C1 to 10 only
D0 to 1
Correct Answer
0 to 1
Abetween Q1 and Q3
Bexactly at the median
Cbelow Q1 − 1.5×IQR or above Q3 + 1.5×IQR
Dequal to the mean
Correct Answer
below Q1 − 1.5×IQR or above Q3 + 1.5×IQR
Areduce the data volume while preserving analytical results
Bincrease the data volume
Cremove all attributes
Dencrypt the data
Correct Answer
reduce the data volume while preserving analytical results
AVolume, Velocity and Variety
BValue, Version and Vision
CVolume, Validity and Vector
DVariety, Visual and Vault
Correct Answer
Volume, Velocity and Variety
Aonly drawing charts
Bonly buying hardware
Conly writing programs
Dpolicies for the availability, usability, integrity and security of data
Correct Answer
policies for the availability, usability, integrity and security of data
Athe mean and standard deviation of the attribute
Bonly the maximum value
Conly the minimum value
Dthe number of records
Correct Answer
the mean and standard deviation of the attribute
AA printer
BA keyboard
CA GPS receiver
DA monitor
Correct Answer
A GPS receiver
Abinning
Bsampling
Cpartitioning
Dmean imputation
Correct Answer
mean imputation
Fill in the Blanks
26
GPS data contains latitude, longitude and __________ stamps.
Correct Answer
time
27
__________ is random error or variance in a measured variable.
Correct Answer
Noise
28
A data point that differs greatly from the other observations is called an __________.
Correct Answer
outlier
29
Records that appear more than once are called __________ data.
Correct Answer
duplicate
30
Replacing missing values with estimated values is called __________.
Correct Answer
imputation
31
ETL stands for Extract, Transform and __________.
Correct Answer
Load
32
The __________ rule uses Q1 − 1.5×IQR and Q3 + 1.5×IQR to detect outliers.
Correct Answer
IQR
33
Min-max normalization scales values to the range 0 to __________.
Correct Answer
1
34
A __________ is a subject-oriented, integrated, time-variant, non-volatile collection of data.
Correct Answer
data warehouse
35
The three Vs of big data are Volume, Velocity and __________.
Correct Answer
Variety
36
__________ data has no predefined format, for example images and free text.
Correct Answer
Unstructured
37
__________ smoothing groups sorted values into bins to reduce noise.
Correct Answer
Binning
38
__________ cleaning is the process of detecting and correcting errors in data.
Correct Answer
Data
39
Z-score normalization uses the mean and the __________ deviation.
Correct Answer
standard
40
Data __________ describes how data is collected, stored and integrated in an organisation.
Correct Answer
architecture