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

Questions 11–15

1. 11foundation · easy

   Which characteristic is typical of a streaming table in Databricks?

   • AIt is only available in Delta Live Tables, not Databricks SQL
   • BIt requires a full recomputation on each refresh
   • CIt processes data incrementally as it arrives
   • DIt stores data only in memory
   Reveal Solution Discussion Select an answer first
2. 12application · easy

   A data analyst has a materialized view that is no longer needed because the underlying source table has been decommissioned. The analyst wants to remove the materialized view and its associated metadata from the metastore. Which SQL statement should the analyst use?

   • ADROP MATERIALIZED VIEW sales_summary;
   • BALTER MATERIALIZED VIEW sales_summary SET DISABLED;
   • CDELETE MATERIALIZED VIEW sales_summary;
   • DREMOVE MATERIALIZED VIEW sales_summary;
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which statement about managing materialized views is correct?

   • AYou can drop a materialized view using the DROP VIEW command
   • BMaterialized views cannot be dropped once created
   • CYou cannot change the refresh schedule after creation
   • DYou must drop and recreate a materialized view to change its query
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which SQL clause is used in Databricks SQL to specify how often a materialized view should be refreshed?

   • AREFRESH
   • BINTERVAL
   • CUPDATE
   • DSCHEDULE
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A data analyst is evaluating whether to use a materialized view or a dynamic view for a new reporting dashboard. The dashboard is used by executives and queries a large fact table joined with several dimension tables. The executives expect the data to be no more than 1 hour old. The analyst is concerned about the cost of running the complex query repeatedly. Which consideration is most important when deciding between the two view types?

   • AA dynamic view is always the best choice because it does not require any storage.
   • BA materialized view is always the best choice because it is faster for all queries.
   • CA materialized view always returns fresh data because it is stored in memory.
   • DA dynamic view always returns fresh data but recomputes the query on every access, which could be costly for a frequently used dashboard.
   Reveal Solution Discussion Select an answer first