Untitled Quiz

What is the primary purpose of the Medallion architecture in Databricks?

• To visualize data

• To schedule jobs

• To manage compute resources

• To organize data into layers for improved quality and governance

In the Medallion Architecture data pipeline demonstrated, what is the core conceptual purpose of the Silver layer transformation step, distinct from the Bronze (raw ingestion) and Gold (final aggregation) layers?

• To provide an exact, immutable copy of the raw source data files

• To execute complex joins and machine learning model training prior to final consumption

• To perform data cleansing, schema refinement, column selection, and the addition of processing metadata (e.g., timestamps)

• To manage data governance and set restrictive access controls for business users

What is the function of the rescued data column during ingestion into a bronze table?

• Handles records that do not match the schema

• Stores records that match the schema

• Encrypts sensitive data

• Deletes invalid records

What must you select before creating streaming tables with Databricks SQL?

• A notebook

• A cluster

• A shared SQL warehouse

• A dashboard

Which product line focuses on ingest, ETL, and streaming?

• AI/BI Business Intelligence

• Mosaic AI

• Lakeflow

• Databricks SQL

What are the three core components of the Databricks Lakeflow offering?

• ETL, Streaming, and Ingestion

• Compute, Storage, and Governance

• Connect, Spark Declarative Pipelines, and Jobs

• Delta Lake, Unity Catalog, and Photon

The COPY INTO command is described as an idempotent operation, meaning it can be run multiple times against the same source location without duplication. When the command is executed a second time on the same set of files, which specific metric in the operation result confirms that the previous data insertion was successfully skipped?

• num_inserted_rows being zero

• num_skipped_correct_files being greater than zero

• num_affected_rows being zero

• num_output_bytes being zero

A data engineer runs the DESCRIBE EXTENDED command on a table and notices the metadata output includes the Type field listed as Managed. What conceptual responsibility does this designation indicate for Databricks regarding this table?

• The table is automatically protected by Row-Level Security and Column Masking policies

• Databricks exclusively handles all I/O operations, making the table inaccessible via external cloud tools

• The table is inherently optimized for the Photon engine and cannot be queried by non-Photon clusters

• Databricks manages the table's underlying file structure and lifecycle, storing the data within a specified cloud location assigned by the metastore

Which ingestion method is supported by Lakeflow Connect Standard Connectors?

• Manual UI Upload only

• Only cloud object storage

• Batch only

• Streaming and Batch

What information is stored alongside the Parquet files in a Delta table directory?

• Delta Sharing configuration

• Cloud Storage Credentials

• Databricks runtime version

• Transaction logs with metadata