Which Delta Lake feature makes time travel possible?

The schema enforcement that prevents incompatible data types.

The OPTIMIZE command that compacts small files.

The transaction log that records every commit as a new version.

The auto-merge feature that combines concurrent writes.

Which query correctly retrieves data from the Delta table 'events' as of January 15, 2024 at 10:00:00?

SELECT * FROM events FOR TIMESTAMP '2024-01-15T10:00:00';

SELECT * FROM events TIMESTAMP AS OF '2024-01-15T10:00:00';

SELECT * FROM events VERSION AS OF '2024-01-15T10:00:00';

SELECT * FROM events AT TIMESTAMP '2024-01-15T10:00:00';

Which query correctly retrieves data from version 5 of the Delta table 'sales'?

SELECT * FROM sales AT VERSION 5;

SELECT * FROM sales FOR VERSION 5;

SELECT * FROM sales VERSION AS OF 5;

SELECT * FROM sales TIMESTAMP AS OF 5;

A data analyst is writing a query to retrieve data from the `products` table as of version 7. The analyst is unsure about the correct syntax. Which query is valid in Databricks SQL?

SELECT * FROM products FOR VERSION 7

SELECT * FROM products AS OF VERSION 7

SELECT * FROM products VERSION AS OF 7

A data analyst attempted to query the `sales` table using `VERSION AS OF 10`, but the query failed with an error stating the version does not exist. The table has been in use for several months. What is the most likely cause of this error?

The table was overwritten, and the version number was reset.

The VACUUM command was run, which removed the data files for older versions.

The table was created with a different name and the analyst is querying the wrong table.

The analyst used the wrong syntax for the time travel query.

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 1)

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 1–5

1foundation · easy
Which Delta Lake feature makes time travel possible?
Select an answer first
2foundation · easy
Which query correctly retrieves data from the Delta table 'events' as of January 15, 2024 at 10:00:00?
Select an answer first
3foundation · easy
Which query correctly retrieves data from version 5 of the Delta table 'sales'?
Select an answer first
4application · easy
A data analyst is writing a query to retrieve data from the `products` table as of version 7. The analyst is unsure about the correct syntax. Which query is valid in Databricks SQL?
Select an answer first
5application · medium
A data analyst attempted to query the `sales` table using `VERSION AS OF 10`, but the query failed with an error stating the version does not exist. The table has been in use for several months. What is the most likely cause of this error?
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.