A data analyst is working with the Unity Catalog table `user_profiles` that contains a `name` column with inconsistent formatting: some entries have leading/trailing spaces, some are in uppercase, and some are in lowercase. The analyst needs to create a cleaned version of the data for reporting, standardizing all names to title case (e.g., 'john doe' → 'John Doe'). Which SQL approach should they use?

SELECT INITCAP(TRIM(name)) AS cleaned_name FROM user_profiles;

SELECT TRIM(name) AS cleaned_name FROM user_profiles;

SELECT UPPER(TRIM(name)) AS cleaned_name FROM user_profiles;

SELECT LOWER(TRIM(name)) AS cleaned_name FROM user_profiles;

DatabricksCertified Data Analyst Associate

Domain 2Objective 3

Perform Data Cleaning on Unity Catalog Tables in SQL, Including Removing Invalid Data or Handling Missing Values. DATA-ANALYST-ASSOCIATE Practice Questions (Page 2)

Part of the Section 2: Managing Data domain, which makes up ~5% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~2–3 in this domain), expect 1–1 from this objective — we provide 7 practice questions to prepare you well beyond it. (estimate)

7questions here

2free pages

4concepts

Questions 6–7

6foundation · easy
Which SQL function is used to replace NULL values with a specified default value in a query?
Select an answer first
7application · medium
A data analyst is working with the Unity Catalog table `user_profiles` that contains a `name` column with inconsistent formatting: some entries have leading/trailing spaces, some are in uppercase, and some are in lowercase. The analyst needs to create a cleaned version of the data for reporting, standardizing all names to title case (e.g., 'john doe' → 'John Doe'). Which SQL approach should they use?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DATA-ANALYST-ASSOCIATE

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 Databricks. “DATA-ANALYST-ASSOCIATE” is a trademark of its owner, used for identification only.

Perform Data Cleaning on Unity Catalog Tables in SQL, Including Removing Invalid Data or Handling Missing Values. DATA-ANALYST-ASSOCIATE Practice Questions (Page 2)

Questions 6–7

Which SQL function is used to replace NULL values with a specified default value in a query?

Keep studying — Section 2: Managing Data