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

Questions 21–23

1. 21foundation · easy

   Which statement correctly describes how to create a streaming table in Databricks SQL?

   • AUse CREATE STREAMING TABLE with a query that reads from a streaming source
   • BUse CREATE MATERIALIZED VIEW with a STREAM keyword
   • CUse CREATE TABLE with a STREAMING clause
   • DUse CREATE VIEW with a STREAMING option
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is the primary purpose of a materialized view in Databricks SQL?

   • ATo provide a logical abstraction over underlying tables without storing data
   • BTo automatically optimize the physical layout of underlying tables
   • CTo store the results of a query physically and keep them updated according to a schedule
   • DTo cache query results only for the duration of a single session
   Reveal Solution Discussion Select an answer first
3. 23foundation · easy

   Which command is used to manually refresh a materialized view in Databricks SQL?

   • AALTER MATERIALIZED VIEW view_name REFRESH
   • BEXECUTE REFRESH ON view_name
   • CREFRESH MATERIALIZED VIEW view_name
   • DUPDATE MATERIALIZED VIEW view_name
   Reveal Solution Discussion Select an answer first