A query returns a column named total_price, but the desired output should label it as total_sales. Which SELECT clause modification achieves this?

Use WHERE total_price = total_sales

Add an alias: SELECT total_price AS total_sales

Rename the column in the underlying table

DatabricksCertified Data Analyst Associate

Domain 5Objective 6

Fix a Query to Achieve the Desired Results. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

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

16questions here

4free pages

9concepts

Questions 16–16

16foundation · easy
A query returns a column named total_price, but the desired output should label it as total_sales. Which SELECT clause modification achieves this?
Select an answer first

Finished these 1 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.

Fix a Query to Achieve the Desired Results. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

Questions 16–16

A query returns a column named total_price, but the desired output should label it as total_sales. Which SELECT clause modification achieves this?

Keep studying — Section 5: Analyzing Queries