Understand the Difference Between, and How to Build, Gold Layer Objects Such as Materialized Views, Views, Streaming Tables, and Tables for BI and Analytics Teams in Unity Catalog. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   What is a key governance benefit of storing Gold layer objects in Unity Catalog?

   • AIt automatically backs up all data to a different region
   • BIt provides a centralized audit log of all data access and permission changes
   • CIt eliminates the need for any data quality checks
   • DIt automatically encrypts all data at rest and in transit
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   How does a streaming table differ from a materialized view in Databricks?

   • AStreaming tables can only be created from Kafka sources, while materialized views can be created from any source
   • BMaterialized views store data physically, while streaming tables do not
   • CStreaming tables are only used in the Bronze layer, while materialized views are used in the Gold layer
   • DStreaming tables are updated incrementally as new data arrives, while materialized views are refreshed on a schedule or when underlying data changes
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A data engineer needs to create a Gold layer object that provides a cleaned, business-friendly version of a Silver table for a BI team. The BI team should see only a subset of columns and rows, and the object must always reflect the latest Silver data. The BI team has SELECT permission on the Gold schema but not on the Silver schema. What should the engineer create?

   • AA materialized view in the Gold schema with a manual refresh
   • BA streaming table in the Gold schema that reads the Silver table
   • CA table in the Gold schema created with CREATE TABLE AS SELECT
   • DA view in the Gold schema that selects the required columns and rows from the Silver table
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A company has a materialized view in the Gold layer that aggregates sales data. The underlying Silver table is updated every 30 minutes. The materialized view is refreshed every hour. A BI analyst complains that the data in the materialized view is sometimes up to 90 minutes old. What is the most likely cause?

   • AThe materialized view is automatically refreshed on every query
   • BThe materialized view refresh schedule is misaligned with the Silver table update schedule
   • CThe materialized view is defined with a UNION that duplicates rows
   • DThe BI analyst is querying a different table
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A data engineer creates a materialized view in a Gold schema. The underlying Silver table is updated hourly. The engineer wants the materialized view to reflect the latest Silver data automatically. What must the engineer configure?

   • ANothing; materialized views refresh automatically on every query
   • BA trigger on the Silver table that fires on every insert
   • CA refresh schedule on the materialized view
   • DA streaming table that reads the materialized view
   Reveal Solution Discussion Select an answer first