Databricks Databricks-Certified-Data-Engineer-Associate Practice Exam Questions

Databricks Databricks-Certified-Data-Engineer-Associate Sample Question Answers

Question # 1

Which two components function in the DB platform architecture's control plane? (Choose two.) 

A. Virtual Machines 
B. Compute Orchestration 
C. Serverless Compute 
D. Compute 
E. Unity Catalog

Show Answer

Question # 2

Identify the impact of ON VIOLATION DROP ROW and ON VIOLATION FAIL UPDATE for a constraint violation. A data engineer has created an ETL pipeline using Delta Live table to manage their company travel reimbursement detail, they want to ensure that the if the location details has not been provided by the employee, the pipeline needs to be terminated. How can the scenario be implemented? 

A. CONSTRAINT valid_location EXPECT (location = NULL)
 B. CONSTRAINT valid_location EXPECT (location != NULL) ON VIOLATION FAIL UPDATE 
C. CONSTRAINT valid_location EXPECT (location != NULL) ON DROP ROW 
D. CONSTRAINT valid_location EXPECT (location != NULL) ON VIOLATION FAIL 

Show Answer

Question # 3

Which method should a Data Engineer apply to ensure Workflows are being triggered on schedule? 

A. Scheduled Workflows require an always-running cluster, which is more expensive but reduces processing latency. 
B. Scheduled Workflows process data as it arrives at configured sources. 
C. Scheduled Workflows can reduce resource consumption and expense since the cluster runs only long enough to execute the pipeline. 
D. Scheduled Workflows run continuously until manually stopped.

Show Answer

Question # 4

Identify a scenario to use an external table. A Data Engineer needs to create a parquet bronze table and wants to ensure that it gets stored in a specific path in an external location. Which table can be created in this scenario? 

A. An external table where the location is pointing to specific path in external location.
 B. An external table where the schema has managed location pointing to specific path in external location. 
C. A managed table where the catalog has managed location pointing to specific path in external location. 
D. A managed table where the location is pointing to specific path in external location. 

Show Answer

Question # 5

Identify how the count_if function and the count where x is null can be used Consider a table random_values with below data. What would be the output of below query? select count_if(col > 1) as count_ a. count(*) as count_b.count(col1) as count_c from random_values col1 012 NULL - 23

 A. 3 6 5 
B. 4 6 5 
C. 3 6 6 
D. 4 6 6 

Show Answer

Question # 6

A data engineer needs access to a table new_uable, but they do not have the correct permissions. They can ask the table owner for permission, but they do not know who the table owner is. Which approach can be used to identify the owner of new_table? 

A. There is no way to identify the owner of the table 
B. Review the Owner field in the table's page in the cloud storage solution 
C. Review the Permissions tab in the table's page in Data Explorer 
D. Review the Owner field in the table's page in Data Explorer 

Show Answer

Question # 7

A data engineer wants to create a new table containing the names of customers who live in France. They have written the following command: CREATE TABLE customersInFrance _____ AS SELECT id, firstName, lastName FROM customerLocations WHERE country = 'FRANCE'; A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (Pll). Which line of code fills in the above blank to successfully complete the task? 

A. COMMENT "Contains PIT 
B. 511 
C. "COMMENT PII" 
D. TBLPROPERTIES PII 

Show Answer

Question # 8

A data engineer needs to create a table in Databricks using data from their organization's existing SQLite database. They run the following command: CREATE TABLE jdbc_customer360 USING OPTIONS ( url "jdbc:sqlite:/customers.db", dbtable "customer360" ) Which line of code fills in the above blank to successfully complete the task?

A. autoloader 
B. org.apache.spark.sql.jdbc 
C. sqlite 
D. org.apache.spark.sql.sqlite 

Show Answer

Question # 9

What is stored in a Databricks customer's cloud account? 

A. Data 
B. Cluster management metadata 
C. Databricks web application 
D. Notebooks 

Show Answer

Question # 10

Which file format is used for storing Delta Lake Table? 

A. Parquet 
B. Delta 
C. SV 
D. JSON 

Show Answer