Question 1

Although the Databricks Utilities Secrets module provides tools to store sensitive credentials and avoid accidentally displaying them in plain text users should still be careful with which credentials are stored here and which users have access to using these secrets. Which statement describes a limitation of Databricks Secrets?

Options :

A : Because the SHA256 hash is used to obfuscate stored secrets, reversing this hash will display the value in plain text.

B : Account administrators can see all secrets in plain text by logging on to the Databricks Accounts console.

C : Secrets are stored in an administrators-only table within the Hive Metastore; database administrators have permission to query this table by default.

D : Iterating through a stored secret and printing each character will display secret contents in plain text.

E : The Databricks REST API can be used to list secrets in plain text if the personal access token has proper credentials.

Answer: D

Question 2

Which of the following statements correctly describes End-to-End Testing ?

Options :

A : It’s an approach to simulate a user experience to ensure that the application can run properly under real-world scenarios

B : It’s an approach to test the interaction between subsystems of an application to ensure that modules work properly as a group.

C : It’s an approach to test individual units of code to determine whether they still work as expected if new changes are made to them in the future

D : It’s an approach to verify if each feature of the application works as per the business requirements

E : It’s an approach to measure the reliability, speed, scalability, and responsiveness of an application

Answer: A

Question 3

The data engineering team maintains the following code:

Assuming that this code produces logically correct results and the data in the source table has been deduplicated and validated, which statement describes what will occur when this code is executed?

Options :

A :

The silver_customer_sales table will be overwritten by aggregated values calculated from all records in the gold_customer_lifetime_sales_summary table as a batch job.

B :

A batch job will update the gold_customer_lifetime_sales_summary table, replacing only those rows that have different values than the current version of the table, using customer_id as the primary key.

C :

The gold_customer_lifetime_sales_summary table will be overwritten by aggregated values calculated from all records in the silver_customer_sales table as a batch job.

D :

An incremental job will leverage running information in the state store to update aggregate values in the gold_customer_lifetime_sales_summary table.

E :

An incremental job will detect if new rows have been written to the silver_customer_sales table; if new rows are detected, all aggregates will be recalculated and used to overwrite the gold_customer_lifetime_sales_summary table.

Answer: C

Question 4

Which of the following describes Cron syntax in Databricks Jobs ?

Options :

A : It’s an expression to represent the maximum concurrent runs of a job

B : It’s an expression to represent the retry policy of a job

C : It’s an expression to describe the email notification events (start, success, failure)

D : It’s an expression to represent the run timeout of a job

E : It’s an expression to represent complex job schedule that can be defined programmatically

Answer: E

Question 5

Which of the following statements regarding the retention policy of Delta lake CDF is correct ?

Options :

A : Running the VACUUM command on the table deletes CDF data as well

B : Running the VACUUM command on the table does not deletes CDF data

C : Running the VACUUM command on the table does not deletes CDF data unless CASCADE clause is set to true

D : CDF data files can be purged by running VACUUM CHANGES command

E : CDF data files can never be permanently purged from Delta Lake

Answer: A