Question 20 A group needs an interactive workspace for code development but wants production execution separated to avoid interference. Which arrangement is best? Disable all scheduled job runs Run production only from one engineer's private notebook session Use development compute for iteration and job compute for production runs Keep the production jobs on the developers’ shared cluster while applying stricter workspace permissions Explanation Correct Answer C:Separating compute lifecycles prevents notebook experiments from competing directly with scheduled batch execution. Incorrect Answers A:Eliminating schedules does not satisfy the production execution requirement. B:A personal development session creates availability and operational ownership risks for production. D:Workspace permissions may restrict users, but the production batch still competes with active development compute, defeating the requested execution isolation.
Question 21 A newly added data asset needs central owner attribution, discoverability, and permissions. Which action provides a governed foundation? Register the asset in the appropriate Unity Catalog catalog and schema Store metadata only in notebook parameters instead of registering a governed catalog object Place the only copy inside a temporary cluster directory Store data only at an unregistered external storage path with direct path access Explanation Correct Answer A:The namespace and associated securable permissions establish governed discovery and ownership. Incorrect Answers B:Notebook parameters are not a shared ownership, lineage and privilege system for a durable data asset. C:Temporary cluster-local data lacks the requested durable governed namespace. D:A storage path by itself does not provide the central governed catalog registration, ownership metadata and securable privileges requested.
Question 22 A team needs Unity Catalog to choose the storage location, optimize the data files, and manage cleanup when a table is dropped. The team does not want to manage its own external table path. Which table type should it create? An external table registered against a customer-maintained object-storage path A Unity Catalog managed table A view over separately maintained Parquet files An external volume with a folder of manually managed data files Explanation Correct Answer B:A Unity Catalog managed table allows the catalog to manage the data storage location, optimization and post-drop file lifecycle. Incorrect Answers A:An external table is centrally governed, but its underlying storage path and file lifecycle remain under the external owner’s control. C:A view can expose query results, but does not itself supply the requested managed table storage and file lifecycle. D:An external volume governs files at an owned cloud location, but is not a managed table with catalog-directed storage lifecycle.
Question 23 A team assumes a Databricks notebook is the authoritative durable store for enterprise table data. Which correction is appropriate? Use workspace files as the authoritative shared store for regularly updated CSV extracts Export notebook display output as CSV and use that export as the authoritative table Persist table data as governed Delta tables and keep notebook code separate Shutdown Unity Catalog to simplify persistence Explanation Correct Answer C:Notebooks store executable analysis code; durable governed tables hold shared transactional records. Incorrect Answers A:Workspace files can store project artifacts, but they do not provide governed Delta transactions and a durable shared analytical table contract. B:A display export can be stale and lacks the table registration, transactional writes and governance required for the durable system of record. D:Removing governance does not transform notebook content into durable datasets.
Question 24 A regulated team wants a single table source of truth while analysts create different BI-facing views. What should be shared? An unrestricted public link to the cloud bucket One governed Delta table with authorized downstream views Publish cached report extracts separately for each business unit with no shared governed table Independent manual spreadsheets for every department Explanation Correct Answer B:A common table preserves controlled data lineage while views tailor presentation to user needs. Incorrect Answers A:Public object access undermines the stated regulatory access controls. C:Independent cached extracts can become stale and cannot preserve one centrally governed source table for the regulated consumers. D:Manual extracts drift as source data changes and lose a consistent governance boundary.
Question 25 Engineers need to investigate which committed operation changed the number of records in a Delta table. Which source is relevant? Inspect only the workflow run status that executed the last transformation Use the job execution history alone without checking the Delta table transaction history Delta table history showing committed operations Infer the transaction solely from cloud file modification times Explanation Correct Answer C:Table history records changes and metadata about transactional versions for incident reconstruction. Incorrect Answers A:A task success or failure state does not list the precise committed operation that changed table rows; Delta table history is the relevant record. B:Job history identifies when a notebook ran, but it does not establish which Delta table commit changed the record count or what version was published. D:Modification times do not reliably bind a collection of files to one committed Delta operation with operation metadata.
Question 26 A SQL analyst complains that querying a table through a compatible SQL warehouse still requires the catalog to authorize access. Why? Compute authorization and data-object privileges are separate controls The storage file extension grants table-level SELECT Warehouses bypass table privileges by design Notebook language controls catalog security Explanation Correct Answer A:A running SQL warehouse provides execution capacity but does not grant SELECT on a governed table. Incorrect Answers B:A file format does not confer read permissions to the SQL principal. C:Governed data access is checked separately from whether compute is available. D:Changing code language does not supersede Unity Catalog table privileges.
Question 27 A platform architecture review asks how Delta Lake can support SQL dashboards and Spark transformations on the same underlying data. What is the key characteristic? All data must run through one driver process Each workload receives an unrelated copy from notebook memory Transactional tables can be read by different compatible Databricks execution workloads SQL dashboards can only access CSV files Explanation Correct Answer C:Common Delta metadata and storage permit separate compute engines to use consistent committed datasets. Incorrect Answers A:Shared lakehouse datasets are not confined to one driver memory. B:Independent in-memory copies lack consistent durable table history. D:Databricks SQL can query governed Delta tables; CSV-only is an artificial restriction.
Question 28 A development workload is brief and sporadic, while its compute remains allocated all weekend. Which platform cost practice should be applied? Configure termination policies and right-size the development compute Keep every job running continuously Enable larger Spark executors but keep the development compute running across idle weekends Increase cluster size to finish boot faster Explanation Correct Answer A:Shutting down idle resources and matching size to interactive needs addresses weekend idle charges. Incorrect Answers B:Continuous runs would exacerbate spending for an intermittent development task. C:More capacity can increase idle cost and does not enforce the requested termination of development compute during nonuse. D:A larger cluster can increase spend and does not remove the extended idle interval.
Question 29 A team stores cloud data in Parquet but demands a way to track which files belong to each committed table version. Which layer adds that capability? Object-store folder naming conventions alone Use cloud object file timestamps as the authoritative table commit record Delta transaction metadata over data files Notebook job tags alone Explanation Correct Answer C:The Delta log tracks versioned table state while data remains in files such as Parquet. Incorrect Answers A:Folders by date do not ensure atomic versioned table updates. B:Object modification times do not define an atomic Delta-style transaction snapshot across the table file set. D:Job tags help identify runs but do not define consistent table snapshots.
Question 30 A team plans to put data quality curation directly in the presentation layer while discarding all raw evidence. Which revision fits the medallion model? Create only gold tables and delete input immediately Call every identical table bronze, silver, and gold Store raw source files in gold with no quality checks Preserve raw bronze evidence and add validated transformations before gold Explanation Correct Answer D:Bronze preserves source fidelity, silver standardizes records, and gold provides trusted business-facing products. Incorrect Answers A:Removing raw evidence can impede replay and diagnosing source inconsistencies. B:Renaming duplicates is not the meaningful refinement described by medallion architecture. C:Gold is intended for consumption-ready representations rather than unchecked source records.