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

Questions 16–20

1. 16application · medium

   A logistics company streams shipment tracking events into a Bronze layer. They want a Gold layer object that maintains a continuously updated, deduplicated list of the latest status for each shipment, and they want this object to be automatically maintained as new events arrive. What should you build?

   • AA streaming table built with a streaming query that applies deduplication
   • BA standard table that is manually truncated and reloaded each hour
   • CA materialized view with a streaming refresh
   • DA view that reads the Bronze layer and applies a deduplication query
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   In the Gold layer, what is a common use case for a materialized view?

   • ATo store raw data in its original format for compliance
   • BTo cache the results of a complex, expensive query so that BI dashboards can load quickly
   • CTo create a temporary table that exists only for the duration of a notebook session
   • DTo provide a real-time, always-current view of raw streaming data
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A retail analytics team needs to query a Gold layer object that always reflects the latest committed data from the Silver layer, including new rows added every 15 minutes. They run ad-hoc SQL queries and need the object to be immediately queryable without any manual refresh step. The team does not need to modify the object's definition. What should you create in Unity Catalog?

   • AA view defined with CREATE VIEW over the Silver layer
   • BA standard table created with CREATE TABLE AS SELECT from the Silver layer
   • CA streaming table with a trigger interval of 15 minutes
   • DA materialized view with a manual refresh schedule
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which technique is commonly used to optimize Gold layer tables for BI query performance?

   • AStoring data in CSV format for compatibility
   • BCreating a view for every table to avoid physical storage
   • CUsing Z-ordering on frequently filtered columns
   • DAvoiding all aggregations to keep data granular
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   What is the primary purpose of the Gold layer in a medallion architecture?

   • ATo provide curated, business-ready datasets that are optimized for BI and analytics consumption
   • BTo store raw ingested data in its original format for compliance and audit purposes
   • CTo perform complex transformations and feature engineering for machine learning models
   • DTo enforce data quality rules and clean data before it is stored in the Silver layer
   Reveal Solution Discussion Select an answer first