A logistics company's dataset contains customer addresses with several records where the 'city' field is missing, and some records have the same address but different customer IDs. The data team wants to automate the cleaning process to improve data quality. Which automated cleaning tasks should be prioritized?

Remove all records with missing city values, and keep duplicate addresses for completeness.

Replace missing city values with 'Unknown' and keep duplicates.

Impute missing city values using the most common city in the dataset, and remove duplicate addresses.

Only remove duplicate addresses; missing city values do not affect delivery.

CiscoAI Technical Practitioner

Domain 4Objective 2

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

Part of the Data Research and Analysis domain, which accounts for 10% of the AI-TECHNICAL-PRACTITIONER exam. Cisco does not publish an official question count, but from its 60-minute exam (~25–40 total, ~3–4 in this domain), expect 1–1 from this objective — we provide 17 practice questions to prepare you well beyond it. (estimate)

17questions here

4free pages

4concepts

10%of the exam

Questions 16–17

16foundation · easy
Which automated cleaning task would you use to fill in missing values in a dataset with the mean of the column?
Select an answer first
17application · medium
A logistics company's dataset contains customer addresses with several records where the 'city' field is missing, and some records have the same address but different customer IDs. The data team wants to automate the cleaning process to improve data quality. Which automated cleaning tasks should be prioritized?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to AI-TECHNICAL-PRACTITIONER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Cisco. “AI-TECHNICAL-PRACTITIONER” is a trademark of its owner, used for identification only.

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

Questions 16–17

Which automated cleaning task would you use to fill in missing values in a dataset with the mean of the column?

Keep studying — Data Research and Analysis