What is a key difference between a dynamic view and a materialized view in Databricks SQL?

A dynamic view always reflects the latest data, while a materialized view may be stale until refreshed

A dynamic view stores data physically, while a materialized view does not

A materialized view can be used in queries, but a dynamic view cannot

A materialized view is faster to create than a dynamic view

In Delta Live Tables, what is the purpose of a streaming table?

To provide a read-only snapshot of a table

To store data in a format optimized for columnar queries

To create a table that is only updated manually

To process data incrementally from a streaming source

What is a limitation of materialized views in Databricks SQL?

They require a streaming source

They do not support SQL queries

They may not always reflect the latest data until refreshed

Which characteristic is true for a materialized view but not for a dynamic view?

It uses physical storage to persist query results

It does not require any storage

It always returns the most up-to-date data

It is automatically updated on every query

A media streaming company has a continuous stream of user click events landing in a Delta table. A data analyst needs to create a table that tracks the total number of clicks per video, updated continuously as new events arrive. The analyst will use Databricks SQL. What should the analyst create?

A dynamic view that queries the click events table.

A regular table that is recreated every hour with a scheduled job.

A streaming table that reads from the click events table and aggregates the data.

A materialized view with a 5-minute refresh schedule.

DatabricksCertified Data Analyst Associate

Domain 4Objective 4

Create a Materialized View, Including Knowing When to Use Streaming Tables and Materialized Views, and Differentiate Between Dynamic and Materialized Views. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

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 23 practice questions to prepare you well beyond it. (estimate)

23questions here

5free pages

8concepts

Questions 16–20

16foundation · easy
What is a key difference between a dynamic view and a materialized view in Databricks SQL?
Select an answer first
17foundation · easy
In Delta Live Tables, what is the purpose of a streaming table?
Select an answer first
18foundation · easy
What is a limitation of materialized views in Databricks SQL?
Select an answer first
19foundation · easy
Which characteristic is true for a materialized view but not for a dynamic view?
Select an answer first
20application · medium
A media streaming company has a continuous stream of user click events landing in a Delta table. A data analyst needs to create a table that tracks the total number of clicks per video, updated continuously as new events arrive. The analyst will use Databricks SQL. What should the analyst create?
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.