4.2 Describe Automated Data Preparation Tasks (quality Checks, Formatting, Transformation, Cleaning) AI-TECHNICAL-PRACTITIONER Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A healthcare analytics team is building an automated pipeline to process patient records. They need to detect records with unusually high blood pressure readings (outliers) and records that are missing critical fields like 'age'. Which automated quality checks should they implement?

   • AOnly check for missing values in critical fields; outliers are not a data quality issue.
   • BRemove all records with missing 'age' and ignore outliers.
   • CUse statistical methods (e.g., z-score) to flag outliers and check for missing values in critical fields.
   • DUse a fixed threshold to flag outliers and replace missing 'age' with the average age.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A multinational e-commerce company collects order data with dates in various formats (e.g., '2024-01-15', '15/01/2024', 'Jan 15, 2024'). They also need to calculate the total revenue per month for reporting. Which automated data preparation steps should they implement?

   • AParse all dates into a standard format (e.g., ISO 8601) and then aggregate revenue by month.
   • BAggregate revenue by month without standardizing dates.
   • CStandardize dates to a common format and then scale revenue values.
   • DOnly parse dates into a standard format; aggregation is not a data preparation task.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which automated data preparation task ensures that all date values in a dataset follow the same pattern, such as YYYY-MM-DD?

   • ATransformation
   • BQuality check
   • CFormatting
   • DCleaning
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which transformation technique converts categorical labels, such as "red", "green", and "blue", into a numerical format that machine learning algorithms can process?

   • AEncoding
   • BScaling
   • CAggregation
   • DCleaning
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which automated quality check is specifically designed to detect records that appear more than once in a dataset?

   • AOutlier analysis
   • BSchema validation
   • CMissing value imputation
   • DDuplicate detection
   Reveal Solution Discussion Select an answer first