A DataFrame has a column 'quantity' stored as a string. The data engineer needs to convert it to an integer type. Which PySpark SQL expression correctly performs this cast?

SELECT CAST(quantity AS INT) FROM df

SELECT CONVERT(quantity, INT) FROM df

DatabricksCertified Data Engineer Associate

Domain 3Objective 1

Implement Data Cleaning by Reading Bronze Tables with PySpark/SQL, Cleaning Nulls, Standardizing Data Types, and Writing to New Silver Tables. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 3)

Part of the Data Transformation and Modeling domain, which accounts for 22% of the DATA-ENGINEER-ASSOCIATE exam. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–13 in this domain), expect 1–2 from this objective — we provide 11 practice questions to prepare you well beyond it. (estimate)

11questions here

3free pages

4concepts

22%of the exam

Questions 11–11

11foundation · easy
A DataFrame has a column 'quantity' stored as a string. The data engineer needs to convert it to an integer type. Which PySpark SQL expression correctly performs this cast?
Select an answer first

Finished these 1 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DATA-ENGINEER-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-ENGINEER-ASSOCIATE” is a trademark of its owner, used for identification only.

Implement Data Cleaning by Reading Bronze Tables with PySpark/SQL, Cleaning Nulls, Standardizing Data Types, and Writing to New Silver Tables. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 3)

Questions 11–11

A DataFrame has a column 'quantity' stored as a string. The data engineer needs to convert it to an integer type. Which PySpark SQL expression correctly performs this cast?

Keep studying — Data Transformation and Modeling