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

Questions 1–5

1. 1foundation · easy

   In Unity Catalog, what is a key difference between a view and a table?

   • AA table is always created in the Bronze layer, while a view is created in the Gold layer
   • BA view can only be created from a table, not from another view
   • CA view stores data physically, while a table does not
   • DA view is a saved query that does not store data, while a table stores data physically
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A BI team frequently runs a query that filters a large Gold table on a 'region' column and then aggregates sales. The query is slow because it scans the entire table. The team wants to improve query performance without changing the query logic. What should you do?

   • ACreate a view that pre-filters by region
   • BCreate a materialized view that pre-aggregates the data by region
   • CConvert the table to a streaming table
   • DAdd a comment to the table describing the region column
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A data engineer needs to build a Gold layer object that provides a daily snapshot of the total sales per product. The snapshot should be computed once per day and stored for fast querying by the BI team. The BI team queries the same snapshot repeatedly throughout the day. What should the engineer create?

   • AA view that computes total sales per product
   • BA streaming table that ingests sales events
   • CA materialized view with a daily refresh
   • DA standard table created once with the current sales data
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A data engineer is designing a Gold layer for a company that has both batch and streaming data sources. The batch data is loaded daily, and the streaming data arrives continuously. The Gold layer must provide: (1) a daily snapshot of batch data, and (2) a real-time view of streaming data. The engineer wants to minimize the number of objects. What is the most efficient design?

   • ACreate a single streaming table that ingests both batch and streaming data
   • BCreate a single materialized view that refreshes every minute
   • CCreate a materialized view for the batch snapshot and a streaming table for the real-time data
   • DCreate a single view that unions the batch and streaming data
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which type of data object is most commonly used in the Gold layer to serve aggregated metrics to a BI dashboard?

   • AA Delta table with pre-aggregated metrics and business-defined dimensions
   • BA temporary view created within a single notebook session
   • CA raw JSON file stored in cloud storage
   • DAn external table pointing to a CSV file in cloud storage
   Reveal Solution Discussion Select an answer first