How does the data retention setting affect time travel?

It determines the minimum version number that can be queried.

It determines the maximum timestamp that can be used in a time travel query.

It determines how long historical versions remain available for time travel.

It determines the maximum number of versions that can be queried.

A data analyst needs to determine the latest version number of the `inventory` table. Which command should the analyst run?

SELECT MAX(version) FROM inventory

SELECT * FROM inventory VERSION AS OF LATEST

Which command or function can you use to see the version history of a Delta table?

SELECT * FROM table_name HISTORY

A data analyst needs to find the exact version number of the `customer` table as it existed at 14:22 UTC on April 10, 2024. The analyst has access to the table's history. Which command should the analyst run first?

SELECT * FROM customer TIMESTAMP AS OF '2024-04-10T14:22:00'

SELECT version FROM customer.history

What information does DESCRIBE HISTORY provide for a Delta table?

The current schema and partition columns of the table.

The permissions granted on the table.

A list of versions with timestamps and operation details.

The physical file locations of all data files.

DatabricksCertified Data Analyst Associate

Domain 4Objective 9

Use Delta Lake's Time Travel to Access and Query Historical Data Versions. DATA-ANALYST-ASSOCIATE Practice Questions (Page 3)

Part of the Section 4: Executing queries using Databricks SQL and Databricks SQL Warehouses domain, which makes up ~22% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–13 in this domain), expect 1–1 from this objective — we provide 22 practice questions to prepare you well beyond it. (estimate)

22questions here

5free pages

7concepts

Questions 11–15

11foundation · easy
How does the data retention setting affect time travel?
Select an answer first
12application · easy
A data analyst needs to determine the latest version number of the `inventory` table. Which command should the analyst run?
Select an answer first
13foundation · easy
Which command or function can you use to see the version history of a Delta table?
Select an answer first
14application · medium
A data analyst needs to find the exact version number of the `customer` table as it existed at 14:22 UTC on April 10, 2024. The analyst has access to the table's history. Which command should the analyst run first?
Select an answer first
15foundation · easy
What information does DESCRIBE HISTORY provide for a Delta table?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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.