Databricks Certified Professional Data Engineer Exam Questions with Verified Answers

Databricks Certified Professional Data Engineer Exam Questions with Verified Answers Which of the following locations in Databricks product architecture hosts jobs/pipelines and queries?A.Data planeB.Control planeC.Databricks FilesystemD.JDBC data sourceE.Databricks web application Answer: B Which of the following type of tasks cannot setup through a job?A.NotebookB.DELTA LIVE PIPELINEC.Spark SubmitD.PythonE.Databricks SQL Dashboard refresh Answer: E Which of the following functions can be used to convert JSON string to Struct data type?A.TO_STRUCT (json value)B.FROM_JSON (json value)C.FROM_JSON (json value, schema of json)D.CONVERT (json value, schema of json)E.CAST (json value as STRUCT) Answer: C Drop the customers database and associated tables and data, all of the tables inside the database are managed tables. Which of the following SQL commands will help you accomplish this?A.DROP DATABASE customers FORCEB.DROP DATABASE customers CASCADEC.DROP DATABASE customers INCLUDED.All the tables must be dropped first before dropping databaseE.DROP DELTA DATABSE customers Answer: C What is the underlying technology that makes the Auto Loader work?A.LoaderB.Delta Live TablesC.Structured StreamingD.DataFramesE.Live DataFames Answer: C You are currently working on storing data you received from different customer surveys, this data is highly unstructured and changes over time, why Lakehouse is a better choice compared to a Data warehouse? A.Lakehouse supports schema enforcement and evolution, traditional data warehouses lack schema evolution. B.Lakehouse supports SQL C.Lakehouse supports ACID D.Lakehouse enforces data integrity E.Lakehouse supports primary and foreign keys like a data warehouse Answer: A While investigating a performance issue, you realized that you have too many small files for a given table, which command are you going to run to fix this issue A.COMPACT table_name B.VACUUM table_name C.MERGE table_name D.SHRINK table_name E.OPTIMIZE table_name Answer: E You are asked to debug a databricks job that is taking too long to run on Sunday's, what are the steps you are going to take to identify the step that is taking longer to run? A.A notebook activity of job run is only visible when using all-purpose cluster. B.Under Workflow UI and jobs select job you want to monitor and select the run, notebook activity can be viewed. C.Enable debug mode in the Jobs to see the output activity of a job, output should be available to view. D.Once a job is launched, you cannot access the job's notebook activity. E.Use the compute's spark UI to monitor the job activity. Answer: B You are asked to debug a databricks job that is taking too long to run on Sunday's, what are the steps you are going to take to identify the