Which of the following describes a benefit of creating an external table from Parquet rather than CSV when using a CREATE TABLE AS SELECT statement?

• A.Parquet files have a well-defined schema
• B.CREATE TABLE AS SELECT statements cannot be used on files
• C.Parquet files can be partitioned
• D.Parquet files will become Delta tables
• E.Parquet files have the ability to be optimized

Comment: *

Name: *

Email: *

Verification: *

In which of the following file formats is data from Delta Lake tables primarily stored?

• A.Delta
• B.CSV
• C.Parquet
• D.JSON
• E.A proprietary, optimized format specific to Databricks

Comment: *

Name: *

Email: *

Verification: *

A data engineer is designing an ETL pipeline to process both streaming and batch data from multiple sources. The pipeline must ensure data quality, handle schema evolution, and provide easy maintenance. The team is considering using Delta Live Tables (DLT) in Databricks to achieve these goals. They want to understand the key features and benefits of DLT that make it suitable for this use case. Why is Delta Live Tables (DLT) an appropriate choice?

• A.Automatic data quality checks, built-in support for schema evolution, and declarative pipeline development
• B.Manual schema enforcement, high operational overhead, and limited scalability
• C.Requires custom code for data quality checks, no support for streaming data, and complex pipeline maintenance
• D.Supports only batch processing, no data versioning, and high infrastructure costs

Comment: *

Name: *

Email: *

Verification: *

A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team.
Which of the following commands can be used to grant the necessary permission on the entire database to the new team?

• A.GRANT VIEW ON CATALOG customers TO team;
• B.GRANT CREATE ON DATABASE customers TO team;
• C.GRANT USAGE ON CATALOG team TO customers;
• D.GRANT CREATE ON DATABASE team TO customers;
• E.GRANT USAGE ON DATABASE customers TO team;

Comment: *

Name: *

Email: *

Verification: *

A data engineer is building an ETL pipeline in Databricks that loads raw JSON files from cloud object storage into a Delta Lake table. The pipeline must ensure ACID transactions and schema enforcement while supporting scalable reads and writes from multiple concurrent jobs. Which storage format should the engineer use?

• A.Avro
• B.Parquet
• C.CSV
• D.Delta Lake

Comment: *

Name: *

Email: *

Verification: *