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

Questions 21–23

1. 21expert · medium

   A data engineer needs to provide a Gold layer object to a BI team. The object must: (1) show only rows where 'status = 'active'', (2) always reflect the latest Silver data, and (3) be queryable by the BI team without granting them access to the underlying Silver table. The BI team also needs to be able to add their own calculated columns in their queries. What should the engineer create?

   • AA materialized view in the Gold schema with a manual refresh
   • BA streaming table in the Gold schema that filters active rows
   • CA table in the Gold schema with only active rows
   • DA view in the Gold schema that filters on status = 'active'
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   In Unity Catalog, how are permissions managed for Gold layer objects?

   • APermissions are managed at the workspace level only, not at the object level
   • BPermissions are managed by the cloud provider's IAM policies only
   • CPermissions are granted using GRANT statements on the specific catalog, schema, or table/view
   • DPermissions are automatically inherited from the underlying Silver layer objects
   Reveal Solution Discussion Select an answer first
3. 23foundation · easy

   Why is it beneficial to pre-aggregate data in Gold layer tables for BI dashboards?

   • AIt eliminates the need for any data governance
   • BIt reduces the amount of data that BI tools need to scan, leading to faster query responses
   • CIt automatically creates indexes on all columns
   • DIt ensures that all data is stored in a single table for simplicity
   Reveal Solution Discussion Select an answer first