Data Conversion — Learn free

Self-check

Questions 1–10 of 10

1. What is the key difference between Data Conversion and Data Transformation?
Question 1A. Data Conversion applies only to numbers, Data Transformation only to textB. In Data Conversion the data is not changed, whereas in Data Transformation data can be changed based on business requirementsC. Data Conversion is done by business users, Data Transformation by machinesD. Data Conversion is always reversible, Data Transformation neverE. There is no difference; the terms are interchangeable
2. Which of the following is given as a basic example of Data Conversion?
Question 2A. Calculating total sales per regionB. Removing duplicate customer recordsC. Masking credit card numbersD. Converting weather data from Celsius to FahrenheitE. Aggregating daily data into monthly totals
3. Why is it better to convert a field that contains only numbers from a string data type to a number data type?
Question 3A. Because processing is much faster on a number data type than on a stringB. Because strings cannot be stored in databasesC. Because regulators require numeric typesD. Because it anonymises the dataE. Because it reduces the number of rows
4. A field holding predefined values such as Male/Female or Yes/No is stored as varchar; to which data type is it better converted?
Question 4A. IntegerB. DateC. BlobD. TextE. Char
5. In the Big Data era, roughly what proportion of datasets are described as semi-structured or unstructured?
Question 5A. About 20%B. About 50%C. More than 90%D. Less than 10%E. About 75%
6. What should happen to semi-structured and unstructured data before it can be cleaned, cleansed or scrubbed?
Question 6A. It should be encryptedB. It should be converted or standardisedC. It should be archivedD. It should be loaded straight into reportsE. It should be deleted if older than a year
7. What does Data Governance contribute to Data Conversion?
Question 7A. It performs the conversions automaticallyB. It chooses the database engineC. It replaces the need for Data QualityD. It adds policies to make sure data is standardisedE. It converts unstructured data into images
8. Which of the following is NOT listed as a use of Data Conversion?
Question 8A. Changing data values according to business decisionsB. Standardising different formats into one unified formatC. Converting one format into different formatsD. Converting one data model to another for business ease of useE. Converting data into reporting and dashboard formats
9. Which activity is said to produce much better and faster results once data has been standardised?
Question 9A. Data EncryptionB. Data BackupC. Data ArchivingD. Data CompressionE. Data Profiling
10. Converting images, PDFs, video or audio into semi-structured or structured file formats is an example of what?
Question 10A. Data MaskingB. Data SegmentationC. Data ConversionD. Data LineageE. Data Redaction