Data Wrangling,Mangling orMunging — Learn free

Self-check

Questions 1–10 of 10

1. Which three terms are used interchangeably to describe preparing data for processing?
Question 1A. Data Mining, Data Science and Data AnalyticsB. Data Cleaning, Data Cleansing and Data ScrubbingC. Data Wrangling, Data Mangling and Data MungingD. Data Discovery, Data Structuring and Data PublishingE. Data Blending, Data Mashup and Data Integration
2. In simple words, what is Data Wrangling?
Question 2A. Preparing data for processing, not processing the dataB. Running machine learning models on raw dataC. Publishing dashboards for executivesD. Encrypting data before it is storedE. Deleting all historical data
3. When is Data Wrangling performed in relation to Data Mining, Data Science, Business Intelligence and Business Analytics?
Question 3A. After all of them have finishedB. Only during Business IntelligenceC. At the same time as Data ScienceD. Only when a model failsE. Before any of them
4. Which of the following is NOT given as an example of Data Wrangling?
Question 4A. Removing spaces from the left and right of a field using LTRIM or RTRIMB. Training a machine learning model to predict buying behaviourC. Replacing empty date rows with 01/01/9999D. Removing special characters from a fieldE. Removing a row whose year is missing when the analysis is on date
5. In a nutshell, what does Data Wrangling transform raw data into?
Question 5A. A trained machine learning modelB. A visual dashboardC. An encrypted archiveD. Quality and useful raw dataE. A management summary
6. What happens in the Data Discover step of Data Wrangling?
Question 6A. Data from multiple sources is collected in one place, analysed and understood before any action is takenB. Data is published for stakeholdersC. Third-party data is purchasedD. Dirty data is removed by an algorithmE. Data is converted from unstructured to structured format
7. Which Data Wrangling step organises data into a single format, for example converting semi-structured or unstructured data into a structured form?
Question 7A. Data ValidatingB. Data EnrichingC. Data StructuringD. Data PublishingE. Data Discover
8. Which Data Wrangling step is optional and normally done as part of Data Self-Service?
Question 8A. Data DiscoverB. Data StructuringC. Data CleaningD. Data ValidatingE. Data Enriching
9. Which set of rules can Data Validating apply during Data Wrangling?
Question 9A. Cost, speed, and storage sizeB. Quality, consistency, accuracy, security and authenticityC. Colour, font and layoutD. Latitude, longitude and postal codeE. Marital status, income and family hierarchy
10. Besides reducing human effort, what other benefit comes from Data Wrangling policies applied from landing to staging?
Question 10A. The database schema no longer needs a primary keyB. Models no longer need testingC. Business users no longer need access to dataD. CPU and memory processing power is reduced because fewer quality checks are needed during processingE. Data no longer needs to be published