Databricks Certified Data Analyst Associate

Which Databricks component provides centralized governance for data and AI assets across catalogs, schemas, tables, views, and volumes?

• ADatabricks SQL
• BUnity Catalog
• CPhoton
• DLakeflow Jobs

A team needs serverless SQL compute to run analyst queries and dashboards without managing clusters directly. Which Databricks component should they use?

• ASQL Warehouse
• BCatalog Explorer
• CMarketplace
• DDelta Sharing

In Unity Catalog, what is the correct hierarchy for naming a table?

• Aschema.catalog.table
• Bcatalog.table.schema
• Ccatalog.schema.table
• Dworkspace.schema.table

What best describes a managed table in Unity Catalog?

• ADatabricks manages both the table metadata and the underlying data lifecycle
• BThe data always stays in an external system that Databricks cannot track
• COnly the SQL Warehouse configuration is managed by Databricks
• DIt is a read-only object created from Marketplace listings

Which Catalog Explorer feature helps an analyst trace where a certified table came from and which downstream assets depend on it?

• AResult cache
• BLineage
• CQuery history
• DAuto Loader

What does a certified table signal in Databricks?

• AThe table is automatically materialized every minute
• BThe table has been reviewed and marked as a trusted source for use
• CThe table is encrypted with a customer-managed key
• DThe table can only be queried from notebooks

Which Databricks offering lets an organization discover third-party datasets, models, notebooks, and other data products from providers?

• ALakeflow Jobs
• BDatabricks Marketplace
• CPhoton
• DQuery Profile

A data steward wants to browse all schemas inside a catalog, inspect object privileges, and open lineage details from one interface. Which interface fits that need?

• ANotebook sidebar
• BCatalog Explorer
• CQuery Profile
• DGenie space

Which statement about external tables in Unity Catalog is correct?

• AThey can only point to Delta Sharing recipients
• BThey require Databricks to own the data lifecycle in workspace storage
• CThey reference data stored at an external location while Unity Catalog manages metadata a…
• DThey cannot be queried from Databricks SQL Warehouses

Which Databricks component is most directly associated with optimized execution of SQL and DataFrame workloads on supported compute?

• APhoton
• BMarketplace
• CCatalog Explorer
• DDelta Sharing

An analyst wants a secure read-only view of provider data without copying files into their own storage account. Which Databricks capability best matches that requirement?

• AAuto Loader
• BDelta Sharing
• CDBFS root uploads
• DLiquid clustering

What is the main role of Databricks Marketplace in an analyst workflow?

• AScheduling ETL jobs
• BDiscovering and accessing curated data or model products
• CReplacing SQL Warehouses with notebook compute
• DEncrypting external volumes

A workspace contains several catalogs. Which privilege is required before an analyst can browse objects inside a specific catalog from Unity Catalog?

• AMODIFY on every table
• BUSE CATALOG on that catalog
• CCREATE TABLE on the schema
• DMANAGE on the SQL Warehouse

Which description best fits Databricks SQL?

• AA storage format for managed tables
• BA governance layer for catalogs and schemas
• CThe analytics experience for running SQL queries, dashboards, and related BI workflows
• DA replacement for Delta Lake transaction logs

An analyst sees both a catalog and a schema named `finance`. Which fully qualified reference points to the table `transactions` in the `finance` schema inside the `prod` catalog?

• Afinance.prod.transactions
• Bprod.finance.transactions
• Ctransactions.prod.finance
• Dprod.transactions.finance

Why would a team certify a table in Unity Catalog instead of simply sharing its name in documentation?

• ACertification makes the table immutable
• BCertification improves trust and discoverability directly in the platform UI
• CCertification automatically partitions the table
• DCertification forces all queries to use Photon