Databricks Databricks-Certified-Data-Engineer-Associate Exam Dumps

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

Question # 11

Which of the following describes the type of workloads that are always compatible with Auto Loader? 

A. Dashboard workloads 
B. Streaming workloads 
C. Machine learning workloads 
D. Serverless workloads 
E. Batch workloads 

Show Answer

Question # 12

Which of the following SQL keywords can be used to convert a table from a long format to a wide format? 

A. PIVOT
 B. CONVERT 
C. WHERE 
D. TRANSFORM
 E. SUM 

Show Answer

Question # 13

A data engineering team has noticed that their Databricks SQL queries are running too slowly when they are submitted to a non-running SQL endpoint. The data engineering team wants this issue to be resolved. Which of the following approaches can the team use to reduce the time it takes to return results in this scenario?

 A. They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to "Reliability Optimized." 
B. They can turn on the Auto Stop feature for the SQL endpoint. 
C. They can increase the cluster size of the SQL endpoint.
 D. They can turn on the Serverless feature for the SQL endpoint. 
E. They can increase the maximum bound of the SQL endpoint's scaling range 

Show Answer

Question # 14

A data engineer needs to use a Delta table as part of a data pipeline, but they do not know if they have the appropriate permissions. In which of the following locations can the data engineer review their permissions on the table? 

A. Databricks Filesystem 
B. Jobs 
C. Dashboards
 D. Repos 
E. Data Explorer 

Show Answer

Question # 15

A single Job runs two notebooks as two separate tasks. A data engineer has noticed that one of the notebooks is running slowly in the Job's current run. The data engineer asks a tech lead for help in identifying why this might be the case. Which of the following approaches can the tech lead use to identify why the notebook is running slowly as part of the Job?

 A. They can navigate to the Runs tab in the Jobs UI to immediately review the processing notebook. 
B. They can navigate to the Tasks tab in the Jobs UI and click on the active run to review the processing notebook. 
C. They can navigate to the Runs tab in the Jobs UI and click on the active run to review the processing notebook.
 D. There is no way to determine why a Job task is running slowly. 
E. They can navigate to the Tasks tab in the Jobs UI to immediately review the processing notebook.

Show Answer

Question # 16

A data analysis team has noticed that their Databricks SQL queries are running too slowly when connected to their always-on SQL endpoint. They claim that this issue is present when many members of the team are running small queries simultaneously. They ask the data engineering team for help. The data engineering team notices that each of the team's queries uses the same SQL endpoint. Which of the following approaches can the data engineering team use to improve the latency of the team's queries? 

A. They can increase the cluster size of the SQL endpoint. 
B. They can increase the maximum bound of the SQL endpoint's scaling range. 
C. They can turn on the Auto Stop feature for the SQL endpoint. 
D. They can turn on the Serverless feature for the SQL endpoint.
 E. They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to œReliability Optimized.

Show Answer

Question # 17

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project's release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project's release. Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project's release? 

A. They can set a limit to the number of DBUs that are consumed by the SQL Endpoint. 
B. They can set the query's refresh schedule to end after a certain number of refreshes. 
C. They cannot ensure the query does not cost the organization money beyond the first week of the project's release. 
D. They can set a limit to the number of individuals that are able to manage the query's refresh schedule. 
E. They can set the query's refresh schedule to end on a certain date in the query scheduler. 

Show Answer

Question # 18

A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True. Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?

A. if day_of_week = 1 and review_period: 
B. if day_of_week = 1 and review_period = "True": 
C. if day_of_week == 1 and review_period == "True": ] 
D. if day_of_week == 1 and review_period: 
E. if day_of_week = 1 & review_period: = "True": 

Show Answer

Question # 19

Which of the following benefits is provided by the array functions from Spark SQL? 

A. An ability to work with data in a variety of types at once 
B. An ability to work with data within certain partitions and windows 
C. An ability to work with time-related data in specified intervals
 D. An ability to work with complex, nested data ingested from JSON files 
E. An ability to work with an array of tables for procedural automation 

Show Answer

Question # 20

A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL. Which of the following commands could the data engineering team use to access sales in PySpark? 

A. SELECT * FROM sales 
B. There is no way to share data between PySpark and SQL. 
C. spark.sql("sales") 
D. spark.delta.table("sales") 
E. spark.table("sales") 

Show Answer

Question # 21

A data engineer has left the organization. The data team needs to transfer ownership of the data engineer's Delta tables to a new data engineer. The new data engineer is the lead engineer on the data team. Assuming the original data engineer no longer has access, which of the following individuals must be the one to transfer ownership of the Delta tables in Data Explorer?

 A. Databricks account representative 
B. This transfer is not possible 
C. Workspace administrator 
D. New lead data engineer 
E. Original data engineer 

Show Answer

Question # 22

A data organization leader is upset about the data analysis team's reports being different from thedata engineering team's reports. The leader believes the siloed nature of their organization's dataengineering and data analysis architectures is to blame.Which of the following describes how a data lakehouse could alleviate this issue?

A. Both teams would autoscale their work as data size evolves
B. Both teams would use the same source of truth for their workrs1. Reference: 1: What is a Data Lakehouse? - Databricks 2:What is a data lakehouse? | IBM
C. Both teams would reorganize to report to the same department
D. Both teams would be able to collaborate on projects in real-time
E. Both teams would respond more quickly to ad-hoc requests

Show Answer

Question # 23

A data engineer has joined an existing project and they see the following query in the project repository: CREATE STREAMING LIVE TABLE loyal_customers AS SELECT customer_id - FROM STREAM(LIVE.customers) WHERE loyalty_level = 'high'; Which of the following describes why the STREAM function is included in the query?

A. The STREAM function is not needed and will cause an error. 
B. The table being created is a live table. 
C. The customers table is a streaming live table. 
D. The customers table is a reference to a Structured Streaming query on a PySpark DataFrame. 
E. The data in the customers table has been updated since its last run. 

Show Answer