DATABRICKS DATA ENGINEER COMPREHENSIVE EXAM
QUESTIONS AND ANSWERS GUARANTEE A+
✔✔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
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.
B) PII is Publicly available information
C) None of the above
D) PII data doesn't get any additional special handling - ✔✔A
✔✔Databricks can integrate with which of the following BI tools?
A) Tableau
B) Qlik
C) HEX
D) Power BI
E) All of the above - ✔✔E
✔✔Which of the following statement is correct to display all the cities with the condition,
temperature, and humidity whose humidity is in the range of 60 to 75 from the 'weather'
table?
A) SELECT * FROM weather WHERE humidity BETWEEN 60 AND 75
,B) SELECT * FROM weather WHERE humidity IN (60 to 75)
C) SELECT * FROM weather WHERE humidity NOT BETWEEN 60 AND 75
D) SELECT * FROM weather WHERE humidity NOT IN (60 AND 75) - ✔✔A
✔✔How are Delta Live Tables and Delta Lake related?
A) Delta Lake is a subset of Delta Live Table
B) Delta Live Tables extends the functionality of Delta Lake.
C) Both are same
D) None of the above - ✔✔B
✔✔Which of the following is a benefit of Delta Lake?
A) Time Travel capabilities
B) All of the above
C) None of the above
D) ACID Transactions
E) Schema Enforcement - ✔✔B
✔✔Which of the following option is not available on the Databricks SQL landing page?
A) Query history
B) Partner Connect
C) Recent Queries and Dashboards
D) Blog posts
E) Documentation - ✔✔A
✔✔A new data analyst has joined your team. He has recently been added to the
company's Databricks workspace as . The data analyst
should be able to query the table sales in the database retail. The new data analyst has
been granted USAGE on the database retail already.
Which of the following commands can be used to grant the appropriate permission to
the new data analyst?
A) GRANT USAGE ON TABLE sales TO ;
B) GRANT USAGE ON TABLE TO sales;
C) GRANT SELECT ON TABLE TO sales;
D) GRANT SELECT ON TABLE sales TO ;
E) GRANT CREATE ON TABLE sales TO ; - ✔✔D
✔✔What is Data Cleaning?
A) This is a process that involves adding additional information to the data
B) This is a process that involves filling in missing data
C) This is the process that involves identifying or correcting the errors in the data
, D) This is a process that involves moving the data from the bronze layer to silver layer -
✔✔C
✔✔How to change the owner of the schema to a specific user?
A) Go to SQL Warehouses > Click on the SQL Warehouse > Change owner
B) Once set, the owner cannot be changed
C) Go to Workspace > Change Owner
D) Go to Data Explorer > Click on the schema > Click on owner option under the
schema name and change it to the other username - ✔✔D
✔✔How are materialized views refreshed?
A) Automatically every hour
B) Manually by the user
C) Only when there are changes in upstream datasets
D) According to the updated schedule of the pipeline - ✔✔D
✔✔Which of the following operation(s) is/are possible from Data Explorer?
A) All of above
B) View schema details
C) View Data warehouse, Tables, Locations Detail, Query History, Sample data
D) None of above
E) Grant and revoke permissions - ✔✔A
✔✔Which warehouse type supports entry-level performance features and a limited set
of Databricks SQL functionality?
A) Unity Catalog
B) Pro
C) Classic
D) Serverless - ✔✔C
✔✔Which of the following syntax is correct to delete all target rows that have a match in
the source table?
A) MERGE INTO target USING source
ON target.key = source.key
WHEN MATCHED THEN DELETE
B) DELETE target USING source
ON target.key = source.key
WHEN MATCHED THEN DELETE
C) INNER JOIN target USING source
ON target.key = source.key
WHEN MATCHED THEN DELETE
QUESTIONS AND ANSWERS GUARANTEE A+
✔✔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
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.
B) PII is Publicly available information
C) None of the above
D) PII data doesn't get any additional special handling - ✔✔A
✔✔Databricks can integrate with which of the following BI tools?
A) Tableau
B) Qlik
C) HEX
D) Power BI
E) All of the above - ✔✔E
✔✔Which of the following statement is correct to display all the cities with the condition,
temperature, and humidity whose humidity is in the range of 60 to 75 from the 'weather'
table?
A) SELECT * FROM weather WHERE humidity BETWEEN 60 AND 75
,B) SELECT * FROM weather WHERE humidity IN (60 to 75)
C) SELECT * FROM weather WHERE humidity NOT BETWEEN 60 AND 75
D) SELECT * FROM weather WHERE humidity NOT IN (60 AND 75) - ✔✔A
✔✔How are Delta Live Tables and Delta Lake related?
A) Delta Lake is a subset of Delta Live Table
B) Delta Live Tables extends the functionality of Delta Lake.
C) Both are same
D) None of the above - ✔✔B
✔✔Which of the following is a benefit of Delta Lake?
A) Time Travel capabilities
B) All of the above
C) None of the above
D) ACID Transactions
E) Schema Enforcement - ✔✔B
✔✔Which of the following option is not available on the Databricks SQL landing page?
A) Query history
B) Partner Connect
C) Recent Queries and Dashboards
D) Blog posts
E) Documentation - ✔✔A
✔✔A new data analyst has joined your team. He has recently been added to the
company's Databricks workspace as . The data analyst
should be able to query the table sales in the database retail. The new data analyst has
been granted USAGE on the database retail already.
Which of the following commands can be used to grant the appropriate permission to
the new data analyst?
A) GRANT USAGE ON TABLE sales TO ;
B) GRANT USAGE ON TABLE TO sales;
C) GRANT SELECT ON TABLE TO sales;
D) GRANT SELECT ON TABLE sales TO ;
E) GRANT CREATE ON TABLE sales TO ; - ✔✔D
✔✔What is Data Cleaning?
A) This is a process that involves adding additional information to the data
B) This is a process that involves filling in missing data
C) This is the process that involves identifying or correcting the errors in the data
, D) This is a process that involves moving the data from the bronze layer to silver layer -
✔✔C
✔✔How to change the owner of the schema to a specific user?
A) Go to SQL Warehouses > Click on the SQL Warehouse > Change owner
B) Once set, the owner cannot be changed
C) Go to Workspace > Change Owner
D) Go to Data Explorer > Click on the schema > Click on owner option under the
schema name and change it to the other username - ✔✔D
✔✔How are materialized views refreshed?
A) Automatically every hour
B) Manually by the user
C) Only when there are changes in upstream datasets
D) According to the updated schedule of the pipeline - ✔✔D
✔✔Which of the following operation(s) is/are possible from Data Explorer?
A) All of above
B) View schema details
C) View Data warehouse, Tables, Locations Detail, Query History, Sample data
D) None of above
E) Grant and revoke permissions - ✔✔A
✔✔Which warehouse type supports entry-level performance features and a limited set
of Databricks SQL functionality?
A) Unity Catalog
B) Pro
C) Classic
D) Serverless - ✔✔C
✔✔Which of the following syntax is correct to delete all target rows that have a match in
the source table?
A) MERGE INTO target USING source
ON target.key = source.key
WHEN MATCHED THEN DELETE
B) DELETE target USING source
ON target.key = source.key
WHEN MATCHED THEN DELETE
C) INNER JOIN target USING source
ON target.key = source.key
WHEN MATCHED THEN DELETE
