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

Questions 6–10

1. 6foundation · easy

   Which statement correctly creates a Gold layer view that filters sensitive columns from a Silver table?

   • ACREATE STREAMING TABLE gold.customer_public AS SELECT * FROM silver.customers
   • BCREATE TABLE gold.customer_public AS SELECT * FROM silver.customers
   • CCREATE MATERIALIZED VIEW gold.customer_public AS SELECT * FROM silver.customers
   • DCREATE VIEW gold.customer_public AS SELECT customer_id, name FROM silver.customers
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A finance team runs a daily dashboard that executes the same expensive aggregation query over a large Silver layer fact table. The query takes 20 minutes and the dashboard is accessed by 50 users throughout the day. The finance team wants faster dashboard load times and is willing to accept data that is up to one day old. What should you create in Unity Catalog?

   • AA standard table created once from the Silver layer
   • BA view that runs the aggregation query each time the dashboard loads
   • CA materialized view refreshed daily
   • DA streaming table that ingests the raw Silver data
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What is a defining characteristic of a materialized view in Databricks?

   • AIt is a streaming table that ingests data in real-time
   • BIt stores the results of a query physically and refreshes automatically on a schedule
   • CIt is a table that can only be updated manually by a data engineer
   • DIt is a virtual table that always returns the latest data without storing anything
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which SQL statement would you use to create a Gold layer table that stores the results of a query in Unity Catalog?

   • ACREATE STREAMING TABLE gold.sales_summary AS SELECT ...
   • BCREATE VIEW gold.sales_summary AS SELECT ...
   • CCREATE TABLE gold.sales_summary AS SELECT ...
   • DCREATE MATERIALIZED VIEW gold.sales_summary AS SELECT ...
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A data engineer needs to build a Gold layer object that continuously updates a table with the latest clickstream events from a streaming source. The object should be maintained automatically as new events arrive, and the BI team should be able to query it with standard SQL. What should the engineer build?

   • AA streaming table that reads from the streaming source
   • BA materialized view with a manual refresh
   • CA view that reads from the streaming source
   • DA standard table that is manually loaded each hour
   Reveal Solution Discussion Select an answer first