Describe the Core Components of the Databricks Intelligence Platform, Including Mosaic AI, DeltaLive Tables, Lakeflow Jobs, Data Intelligence Engine, Delta Lake, Unity Catalog, and Databricks SQL. DATA-ANALYST-ASSOCIATE Practice Questions (Page 3)

Questions 11–15

1. 11expert · hard

   A company has multiple teams using Databricks, each with their own workspace. They want to centralize data governance so that a single set of permissions applies across all workspaces, but they also want to allow each team to have some local flexibility in how they organize their data. What is the best way to achieve this?

   • AUse Unity Catalog to define global permissions and data assets, and allow teams to create local schemas within their own catalogs
   • BUse Delta Lake to enforce permissions across workspaces
   • CUse Databricks SQL to manage permissions for each workspace
   • DUse separate Unity Catalog instances for each workspace to maintain local control
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which statement best describes the overall architecture of the Databricks Intelligence Platform?

   • AA cloud-agnostic tool that only provides data visualization and dashboarding for business users.
   • BA single monolithic service that combines storage, compute, and governance into one fixed deployment.
   • CA proprietary storage format that replaces cloud object storage for all data workloads.
   • DA set of integrated services built on a lakehouse architecture, combining data engineering, data science, and AI capabilities.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A data team has multiple data processing tasks that need to run in a specific order: first, ingest data; second, clean and transform it; third, load it into a Delta table. They want a managed service to schedule these tasks, monitor their execution, and automatically retry failed tasks. Which component should they use?

   • ADatabricks SQL
   • BMosaic AI
   • CDelta Live Tables
   • DLakeflow Jobs
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A company wants to build a real-time recommendation system that uses machine learning. They have streaming data coming from user interactions, and they need to train and update the model continuously. They also need to serve the model with low latency. Which combination of Databricks components is best suited for this?

   • AData Intelligence Engine for model training and Delta Live Tables for serving
   • BLakeflow Jobs for model training and Unity Catalog for serving
   • CDelta Live Tables for model training and Databricks SQL for serving
   • DMosaic AI for model training and serving, with Delta Lake for storing streaming data
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What is the role of the Data Intelligence Engine in the Databricks platform?

   • ATo use AI to optimize query performance and automate administrative tasks.
   • BTo serve as a governance solution for managing data access and permissions.
   • CTo offer a SQL interface for creating dashboards and BI reports.
   • DTo provide a storage layer with ACID transactions and time travel.
   Reveal Solution Discussion Select an answer first