INTERNATIONAL DATA ENGINEERING AND ANALYTICS
CERTIFICATION EXAMINATION -2026
ETL/ELT PIPELINES | DELTA LAKE ARCHITECTURE | SQL
ANALYTICS | DATA GOVERNANCE | BUSINESS
INTELLIGENCE REPORTING
data integration, transformation, and advanced analytical querying (sql / spark)
final professional certification assessment – 2025/2026
The data analysis team wants to perform a rapid analysis of data on the tableau from 2 different
data sources and their behavior together, what activity would they be performing
A) Data integration
B) last-mile ETL
C) Data enhancement
D) data blending
D
Which layer in the medallion architecture is best suited for ad-hoc reporting, advanced
analytics, and ML?
A) Diamond Layer
B) Bronze Layer
C) Gold Layer
D) Silver Layer
1|Page
,D
What is Delta Sharing?
A) Delta sharing allows data present in only Delta format to be sharable inside the organization
only
B) Delta Sharing is a protocol to share data present inside databricks with other organizations
C) Delta Sharing is the industry's first open protocol for secure data sharing, making it simple to
share data with other organizations regardless of where the data lives
D) Delta Sharing is a protocol to share data present inside databricks within the organizations
C
Which of these is the incorrect approach to handling Complex Data Types?
A) Explore and Collect
B) Support for Complex Data types is yet to be introduced
C) User Defined Function
D) Lambda Function
B
On the dashboard, If you have a parameter added to the dashboard, how will it affect the
visualizations:
A) The parameter will be used to fetch data for all the visualizations which use this parameter
B) The parameter will be used to fetch data for some visualizations but not for others though
they use the same parameter
2|Page
,C) The parameter is not added if a parameterized query/visualization is added
D) The parameter will not make any difference to the visualizations
A
What are the use of the Delta Lake Transaction log?
A) To provide ACID transaction capabilities
B) To track changes
C) All of the above
D) None of the above
C
Which of the following is NOT a benefit of data governance?
A) Consistent and high data quality for analytics and machine learning
B) Data democratization for Decision-making
C) Increased data complexity
D) Reduced time to insight
C
Which of the following is incorrect about Auto loader in Databricks SQL:
A) Loads json, parquet, csv files
B) Ensures file contents are loaded only once
C) Removes duplicates in the file
3|Page
, D) Automatically uploads files
C
What are various warehouse types available in Databricks SQL when creating SQL Warehouse?
A) Serverless warehouse only
B) Serverless, Classic, and Pro
C) Enterprise, OnPrem and Classic
D) Classic and Pro Warehouse
B
Question 12: Correct
For Data Ingestion in Databricks SQL using existing files, which of the following format is not
supported by Databricks?
A) Delta
B) JSON
C) Parquet
D) Microsoft Word
E) CSV
D
There seem to be SSN details in a particular table, it is considered as PII data in US. How should
the data engineering team deal with the PII data here?
A) PII data should be encrypted and stored.
4|Page
CERTIFICATION EXAMINATION -2026
ETL/ELT PIPELINES | DELTA LAKE ARCHITECTURE | SQL
ANALYTICS | DATA GOVERNANCE | BUSINESS
INTELLIGENCE REPORTING
data integration, transformation, and advanced analytical querying (sql / spark)
final professional certification assessment – 2025/2026
The data analysis team wants to perform a rapid analysis of data on the tableau from 2 different
data sources and their behavior together, what activity would they be performing
A) Data integration
B) last-mile ETL
C) Data enhancement
D) data blending
D
Which layer in the medallion architecture is best suited for ad-hoc reporting, advanced
analytics, and ML?
A) Diamond Layer
B) Bronze Layer
C) Gold Layer
D) Silver Layer
1|Page
,D
What is Delta Sharing?
A) Delta sharing allows data present in only Delta format to be sharable inside the organization
only
B) Delta Sharing is a protocol to share data present inside databricks with other organizations
C) Delta Sharing is the industry's first open protocol for secure data sharing, making it simple to
share data with other organizations regardless of where the data lives
D) Delta Sharing is a protocol to share data present inside databricks within the organizations
C
Which of these is the incorrect approach to handling Complex Data Types?
A) Explore and Collect
B) Support for Complex Data types is yet to be introduced
C) User Defined Function
D) Lambda Function
B
On the dashboard, If you have a parameter added to the dashboard, how will it affect the
visualizations:
A) The parameter will be used to fetch data for all the visualizations which use this parameter
B) The parameter will be used to fetch data for some visualizations but not for others though
they use the same parameter
2|Page
,C) The parameter is not added if a parameterized query/visualization is added
D) The parameter will not make any difference to the visualizations
A
What are the use of the Delta Lake Transaction log?
A) To provide ACID transaction capabilities
B) To track changes
C) All of the above
D) None of the above
C
Which of the following is NOT a benefit of data governance?
A) Consistent and high data quality for analytics and machine learning
B) Data democratization for Decision-making
C) Increased data complexity
D) Reduced time to insight
C
Which of the following is incorrect about Auto loader in Databricks SQL:
A) Loads json, parquet, csv files
B) Ensures file contents are loaded only once
C) Removes duplicates in the file
3|Page
, D) Automatically uploads files
C
What are various warehouse types available in Databricks SQL when creating SQL Warehouse?
A) Serverless warehouse only
B) Serverless, Classic, and Pro
C) Enterprise, OnPrem and Classic
D) Classic and Pro Warehouse
B
Question 12: Correct
For Data Ingestion in Databricks SQL using existing files, which of the following format is not
supported by Databricks?
A) Delta
B) JSON
C) Parquet
D) Microsoft Word
E) CSV
D
There seem to be SSN details in a particular table, it is considered as PII data in US. How should
the data engineering team deal with the PII data here?
A) PII data should be encrypted and stored.
4|Page
